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');
$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]
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] Selecting max
3 matches
Mail list logo
