Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001122

[PHP] last row in the table From: Andrey Hristov (ahristov <email protected>)
Date: 12/21/01

Ususally when someone needs to select last row in a table (s)he do:
select * from some_table order by some_field desc limit 1;
but there is another possible solution for mysql :
<?
mysql_free_result(mysql_query('select  <email protected>:=max(member_id) from memberInfo'));
$res=mysql_query('select * from memberInfo where member_id= <email protected>;');
$brr=mysql_fetch_array($res);
mysql_free_result($res);

var_dump($brr);
?>
 
More info here : http://www.mysql.com/doc/V/a/Variables.html

Regards,
Andrey Hristov 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>