SELECT NOW() Query

phplearner

If I use SELECT NOW(); in MYSQLCC I get the proper Date & Time back no problem.

I'm trying to get the same results via a .php page but it keeps returning: 'Resource id #2' instead of the date & time.

MySQL 3.23.x & PHP 4.2.x on WIN2K (but will be using the same .php script on a Unix).

Thanks for any help.

$hostname = "localhost";
$database = "mydb";
$username = "me";
$password = "";
$dbcnx = mysql_connect($hostname, $username, $password) or die(mysql_error());

mysql_select_db($database, $dbcnx);
$query = "SELECT NOW();";
$result = mysql_query($query, $dbcnx) or die(mysql_error());
echo "MySQL Query NOW(): "."$result";

Sxooter

Classic beginner mistake. The "result" var you get back from an exec is just a handle. you need to use mysql_fetch or some other function to get actual data out of memory and into a var.

Look up the docs and try again, but it's just adding a:

$row = mysql_fetch_array($res,$conn);

print $row['now'] or whatever the row is called.

phplearner

Thanks...yup, I'm a noob.

But I don't want to pull any 'row' data out...just the result of the SELECT NOW(); which is date & time.

There is no name on the row...I'm just trying to access the MySQL DB table or MySQL itself to get the date & time. Is this not possible?

I'm getting: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Sxooter

$hostname = "localhost";
$database = "mydb";
$username = "me";
$password = "";
$dbcnx = mysql_connect($hostname, $username, $password) or die(mysql_error());

mysql_select_db($database, $dbcnx);
$query = "SELECT NOW() as datetime;";
$result = mysql_query($query, $dbcnx) or die(mysql_error());
$datetime = mysql_fetch_result($result,0,'datetime');
echo "MySQL Query NOW(): ".$datetime;

Rows are what gets returned by a database, whether you hit the data underlying it or now. You basically get back a matrix in memory that is indexed along one access by an integer for row number of the result, and across the other access by either field number or name. this applies to ALL queries, whether they hit the datastore underneath them or now.

phplearner

Sxooter:

I certainly appreciate all your help and info.

There is still a gremlin in this somewhere, however, 'cuz I copied & pasted your code two different times and still get the same:

Fatal error: Call to undefined function: mysql_fetch_result()

RE:

$datetime = mysql_fetch_result($result,0,'datetime');

Dunno what is going on here.

Sxooter

Sorry, the function is mysql_result(), not mysql_fetch_result. typo...

phplearner

Hey THANKS, Sxooter...it works fine now.

I will study this a bit too.