PHP/MySql Query?? (need to access last record???)

[ghazianibros]

$query_rs = "SELECT * FROM buyerCompanyInfo";
//$row_rs = mysql_fetch_assoc($rs);

$rs = mysql_query($query_rs, $connGlobal) or die(mysql_error());
$numberOfRecord = mysql_num_rows($rs);

it shows the total number of records...BUT here i need to access:

i) last record from query result and/or
ii) specific record from query and/or

plzzzz help 🙁
Imran

[bubblenut]

Come on now mate, a little searching wouldn't go a miss :rolleyes:. Here's the man page for the mysql functions and what you're looking for is [man]mysql_data_seek()[/man] and [man]mysql_num_rows()[/man].

HTH
Bubble