RE: [PHP] Selecting max(id) of a table

If you are using auto-incrementing id column mysql_num_rows won't give you a reliable number try $max=mysql_result($result, 0); -Original Message- From: Liam Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 1:48 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Selectin

RE: [PHP] Selecting max(id) of a table

Try this: $result=mysql_query('select max(id) as max_id from mytable'); $max=mysql_result($result, 0, 'max_id'); print ('Max id in the table=$max'); HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Chakravarthy K Sannedhi [mai

Re: [PHP] Selecting max(id) of a table

> $max=mysql_result($result); $max = mysql_num_rows($result). - the L -- PHP General 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]