you have changed the command from when you do it in mysql to when you do it
in php - you are leaving out the "'" quote marks around the date you are
passing :)
// $sql="SELECT TO_DAYS(2001-01-01) AS bar";
should be
// $sql="SELECT TO_DAYS('2001-01-01') AS bar";
HTH
beau
// -----Original Message-----
// From: Garry Optland [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 1 February 2002 2:12 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] More Date operations.
//
//
// Hi,
//
// I am trying to access the MySQL function TO_DAYS() from PHP.
//
// From MySQL I can type in: SELECT TO_DAYS('2000-1-1') AS bar;
//
// and I get:
//
// +--------+
// | bar |
// +--------+
// | 730485 |
// +--------+
// 1 row in set (0.00 sec)
//
// From PHP, I have tried:
//
// $sql="SELECT TO_DAYS(2001-01-01) AS bar";
// $result=mysql_query($sql) or die("Could not access database");
// $days=mysql_fetch_array($result);
// echo "days: ".$days["bar"]."<br>";
//
// But I don't get the result coming through.
//
// I have tried mysql_field_name and the name comes across as "bar".
//
// mysql_num_rows shows that there is one row in the result.
//
// Am I missing something really really obvious?
//
// Regards,
// Garry.
//
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
