[SOLVED] Select Highest ID number from rows?

ok i have a table called pins.

in the table pins there are 2 rows

id and pin

I need to do something like this:

SELECT highest id FROM pins

i am just not sure how to select highest id

SELECT MAX(id) as highest FROM pins

ok actually i made a mistake what i need is a code like this one

SELECT pin FROM pins WHERE MAX(id) as highest

I need to select the pin from table pins where the highest id is sorry for the confusion

SELECT pin FROM pins

ORDER by id DESC

ok i tried this code

$result = mysql_query("SELECT pin FROM pins
ORDER by id DESC")
or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  echo $row['pin'];
  echo "<br />";
  }

but it just displays every pin in descending order i need it to just display the one with the highest id not all of them

  Quote

i need it to just display the one with the highest id not all of them

then why would you loop through all of them? just echo it once.

how do i echo it only once?

$result = mysql_query("SELECT pin FROM pins
ORDER by id DESC")
or die(mysql_error());

// You echo it once by not using a loop in the first place
//while($row = mysql_fetch_array($result))
//  {
  echo $row['pin'];
  echo "
";
//  }

this is the code i am using it works perfectly

$query = "SELECT pin, id FROM `pins` ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);

echo "The highest id is  " . $row['id'] . " and has pin number: " . $row['pin'];

what would be the code that i use to delete that id and pin out of the pins table?

$sql = "DELETE FROM pins WHERE id = {$row['id']}";