fetch_array just 1 rec??

[Anon]

I want to retrieve 1 record from my table. the most recent record. Im stumped as to how to do that

heres where Im at:

mysql_select_db($db,$link);
$result = mysql_query("SELECT * FROM lg_log ORDER BY lg_crtdt DESC", $link);

If I do a while it will read through the whole thing when I just want to get that first record. Yes this is probably terribly simple.

while ($myrow = mysql_fetch_array($result)) 

{
$id = $myrow["id"];

[polson]

Don't loop it, so :

$row = mysql_fetch_object($result)

$row->id
$row->name
$row->email
...

I used mysql_fetch_object as it's easier to type 🙂 And btw, use LIMIT in your sql statement too so :

SELECT * FROM lg_log ORDER BY lg_crtdt DESC LIMIT 1

[ciaranmg]

You could also use mysql_result()

e.g.

$id=mysql_result($result,0,"id");

Regards
Ciaran