Mysql_fetch_assoc Only Once

[franzwarning]

Is there any way that I can get mysql_fetch_assoc only to run once?

 

Here is my code:

$query = mysql_query("SELECT * FROM items ORDER BY id DESC");
while ($row = mysql_fetch_assoc($query))
{

$id = $row['id'];
}

[kenrbnsn]

Don't put in a while loop

<?php
$query = mysql_query("SELECT * FROM items ORDER BY id DESC");
if (mysql_numrows($query) > 0) {
  $row = mysql_fetch_assoc($query);
  $id = $row['id'];
}
?>

 

Ken

[franzwarning]

Guess I never thought of that.... thanks!