fetch last row

zhopa

How to fetch ONLY the last row in a column?

wizkid

Hi,

do you have something like an ID which is being [FONT=courier new]AUTO_INCREMENTED[/FONT]?

wizkid

zhopa

Nopers, sure don't. 🙁

At one point I had tried using
$tot = mysql_num_rows($query)
and I think, been a long day on this
$endrow = mysql_fetch_row($tot)

ended up with the error "Can not jump to row 870"

any help would be MUCH appriciated

wizkid

Hi,

I would recommend you to make a column with an [FONT=courier new]AUTO_INCREMENTED[/FONT] value. That would make things a lot easier.

wizkid

zhopa

Hya...

hrmm ok, can do that without messing anything up. How would you go about getting the last row with Auto ID on?

BTW, thanks for your time on this. My wife has been looking at me funny for the last couple hours as I mumble strings, etc aloud 🙂

wizkid

Hi,

I just tried it on a test table and it didn't mess anything up. But, if you want to, you can do a backup 😉 .
So try following, when you got the AUTO_INCREMENTED column set up:

SELECT * FROM test ORDER BY id DESC LIMIT 1

wizkid

PS: You can use phpMyAdmin to set up the AUTO_INCREMENTED column.

zhopa

GAHHH....smackshead, that's cheating 😛 but understood.

Thanks

zhopa

Nope Auto_Increment wont work:

ERROR 1062 at line 15: Duplicate entry '127' for key 1

Back to banging my head against the wall.

zhopa

blah it is to late for me to try to make sense. Thank you again wizkid. I found my error in the auto increment column.

michael

I was thinking
select * from table limit 0,1

I think that accomplishes the same thing.