necrotic — Thu, 16 May 2002 00:29:57 +0000

Well god! I feel like a complete idiot! Thanks... it works like a charm.

nike_guy_man — Thu, 16 May 2002 00:03:46 +0000

<?php
$first_result = mysql_query (\"SELECT * FROM anime ORDER BY id DESC\");
  $first_num_rows = mysql_num_rows ($first_result);
  $last_result = mysql_query (\"SELECT * FROM anime WHERE id = $first_num_rows\");
?>

Necrotic... You are saying to see how many rows are in the table anime and then in picks the last one... remove the WHERE id = $first_num_rows bit... thats whats causing the problem...
Hope this works

necrotic — Wed, 15 May 2002 23:30:39 +0000

One thing I see is that it is displaying the Lowest row in the table. Not the first. So... does that help?