select final entry

pablodelapena

I ws using a code which counted the total number of rows.

say there were 10 rows it wuld return 10.

Each row also had an AutoID value.

However, some fool went and added an invalid entry to the database (:o !) and had to delete a row.

Now the counting code still returns the right number of rows, however i wanted to display the LAST row in an echo statement.

basically, the row that the counter echos dont exist. ill try and emonstrate visually:

The original 10 entries:

entry
entry
entry
entry
entry
entry
entry
entry
entry
entry

then someone came along and forgot put a value in:
1. entry
2. entry
3. entry
4. entry
5. entry
6. entry
7. entry
8. entry
9. entry
10. entry
11.

So i deleted it, however now the next entry is added and the auto number reads 12

entry
entry
entry
entry
entry
entry
entry
entry
entry
entry
entry

There are however still only 11 rows, and the echo statemen looks for the 11th row, which isnt there! so it echos nothing!!

Is there some MySQL code to select the LAST entry? Or can i change the autonumber back one through phpMyAdmin??

thanks!

toddmarx

Ok, I think I understand the question a little bit. I am not exactly sure but I will explain both options,

1) try manually putting in the the 11'th record next time and that should set the autonumber back.

2) if you are wanting sql to select the last record, then (I am sure that there is an easier way of doing this) first, create a query to count all the rocords and give it a variable, then build a query to take the assigned variable and use that in the next query.

$recordCount = "SELECT count(*) FROM table"

now, use that variable in your next statement to take the total number of records. I am not exactly sure about the syntax, but I think this is close:

"SELECT * FROM table WHERE id = .'$recordCount'."

If you want it to display the last record then throw in another variable and have it echo that var:

$lastRecord = "SELECT * FROM table WHERE id = .'$recordCount'.";
echo $recordCount;

Use that one instead. I hope that this helps. If not, I am sure one of the php guru's here will pick this up and fix it. 🙂

Knowing me, I probably misunderstood the question. (have not had enough coffee this orn yet). 😉

kevinsequeira

if the table name is user and columns are f_name, l_name and id is auto-increment
do this to get the last row

$query = "select max(id), f_name,l_name from user group by id"

reg
kevin

toddmarx

Like I said, I am sure that there was an easier way! :rolleyes: 😃