Date/MySQL Simple Problem...

Illumini

I havea fairly simple problem... and I've pushed it down to this step in my code. I know the first two lines work as I've used them dozens of times... The next three are very similar to something I do in another script, however when using SQL's NOW/CURDATE functions I can't seem to get anything. The code below outputs nothing... Any help would be apprieciated.

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("mydb", $db);
$res1 = mysql_query("SELECT NOW()", $db);
$res2 = mysql_fetch_row($res1, $db);
echo $res2[0];

Pig

I'm unclear of what you are trying to do? Are you doing all that to get a time? Why not just use time(), or strtotime()?

Illumini

Well.. Original I was doing "SELECT CURDATE()", because I wanted to get the current date in the SQL format. I was going to use this in a INSERT INTO query... However I can't even get the above line to work... Even though that is an example in the manual. If you know a PHP function that gives the date in the SQL format I'd use that instead.

Pig

look up date() in the manual. You can format a date any way you like it.

$var = date( "YmdHi", time() );
will return the current date in YYYYMMDDHHMM (24 hour format for the hours).

I don't know what the sql format is since I always use a unix timestamp (100 times easier than any other format), but you can create any format you want with date().