#mysql - Sun 20 May 2007 between 16:22 and 16:52

NY Lost Funds



HarisJisao: Go to -> ##php
Jisaook.
tx
HarisThis is a php issue
Code-Eis there anything wrong with mysql_query("UPDATE News SET content = '".$_POST['content']."',subject = '".$_POST['subject']."' WHERE ID = '".$_POST['ID']."'");
?
pdxuserIs it possible on a join to order t1 by t1.foo and t2 by t2.bar? http://erxz.com/pb/2767
Code-Eis there anything wrong with mysql_query("UPDATE News SET content = '".$_POST['content']."',subject = '".$_POST['subject']."' WHERE ID = '".$_POST['ID']."'");
?
subsonicWhen I do date on the linux server it shows the correct time, when I "SELECT NOW();" it shows 2 hours ahead
how can I fix that?
pdxusernm on my q.
prismhey all
i have this query: $sql = "UPDATE session SET accessed = $time WHERE id=$user{sessionid}";
I would actually liek to update two coloums
I I just add another SET after $time ?
svn-yea
nils_just leave out the set keyword and use a comma instead
svn-not another set but another column
SET foo=bar, baz=bad
prism$sql = "UPDATE session SET accessed = $time, ip = $ENV{REMOTE_ADDR} WHERE id=$user{sessionid}";
Code-Eis there anything wrong with mysql_query("UPDATE News SET content = '".$_POST['content']."',subject = '".$_POST['subject']."' WHERE ID = '".$_POST['ID']."'");
prismsvn-, ah I get it, many thanks
nils_tias
the_wenchTry it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok
Code-Ewell it does not seem to work ?
svn-subsonic: http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
Code-E: your question is related to php, not mysql
however I don't get the amount of " you have in there
I would also strongly suggest you validate the import before inserting it into the db
s/import/input/
Code-E...?
zed___check ##php
or #phpc
pdxuserWhy is the MySQL default collation latin1_swedish instead of something like utf8_general?
Or utf8_bin might make even more sense.
bberhello
how would i structure ORDER BY if i wanted to start from last row to first?
pdxuserORDER BY foo DESC
bberfoo being the field?

Page: 4 11 18 

IrcArchive

NY Lost Funds