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 [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 4:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Selecting max(id) of a table
Hello all,
I am having a table named 'mytable' of 5 rows in a
MySQL database. I tried to print '5' which is the
highest row onto the screen. I used the following code
for that:
$result=mysql_query('select max(id) from mytable');
$max=mysql_result($result);
print ('Max id in the table=$max');
But what all i am getting is an error like below:
Warning:Wrong parameter count for mysql_result() in
/home/httpd/info.php on line xx
Max id in the table=$max
i am confused about which function to use instead of
mysql_result().
please help
Chakravarthy K Sannedhi
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
--
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]
--
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]
