Last record

[prokhaled]

In this code:

$Sql = "select * from $TableName where ID=What? ";

I want to go to last record that it's ID=last ID in the table.

[scoutt]

you want to display tha last ID or row in a table?

$Sql = "select * from $TableName order by ID DESC ";


that should work, make sure you only loop once as it will list all of them. hope thisis what you meant.

[chrisjk]

you can also append LIMIT to the end of that so it only returns 1 record

$Sql = "select * from $TableName order by ID DESC LIMIT 1";

[The Hobo]

or, to get the last id (if they're in order with no breaks), do:


$num = mysql_num_rows(mysql_query("SELECT * FROM $TableName"));

$sql = "SELECT $TableName WHERE ID='$num'";

[scoutt]

that will not always work. if you have spaces in the rows like

1
2
3
6
8
9

it will only turn out 6 rows and your id will be 9


edit: sorry did see you said no breaks :)