Re: [PHP-DB] Simple question on auto_increment

www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) Or even the MySQL function LAST_INSERT_ID(): http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2725312 -- PHP Database

Re: [PHP-DB] Re: Diff between 2 date

the problem is DATEDIFF command available in MySQL ver 4.1.1 above In MySQL versions 4.1.1 you can use the following construct: SELECT TO_DAYS('2006-10-06') - TO_DAYS('2006-10-05') -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php