[SOLVED] Select Highest ID number from rows?

[Jnerocorp]

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

[Zane]

SELECT MAX(id) as highest FROM pins

[Jnerocorp]

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

[Zane]

SELECT pin FROM pins

ORDER by id DESC

[Jnerocorp]

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

[Zane]

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.

[Jnerocorp]

how do i echo it only once?

[Zane]

$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 "
";
//  }

[Jnerocorp]

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?

[Zane]

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