herghost Posted April 15, 2009 Share Posted April 15, 2009 Here is what I want to do: I have a table that has a userid, which is an auto increment number (basically the user number). How would I echo the last entry into a database, eg the highest user number? Thanks Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/ Share on other sites More sharing options...
mrMarcus Posted April 15, 2009 Share Posted April 15, 2009 i'm not falling for that one again. Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811014 Share on other sites More sharing options...
Maq Posted April 15, 2009 Share Posted April 15, 2009 i'm not falling for that one again. ??? ORDER BY userid DESC LIMIT 1 Is this a SQL question? Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811015 Share on other sites More sharing options...
herghost Posted April 15, 2009 Author Share Posted April 15, 2009 i'm not falling for that one again. I was wondering that, but I guessed that as I was calling and displaying in php then this would be the right section, perhaps we need a php/mysql section Oh and thanks and mrMarcus, Sorry?!? Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811016 Share on other sites More sharing options...
mrMarcus Posted April 15, 2009 Share Posted April 15, 2009 i'm not falling for that one again. ??? ORDER BY userid DESC LIMIT 1 Is this a SQL question? yesterday somebody asked a very similar question, and i spent a fair bit of time on it only to realize i read the question as 'last', when it was actually 'latest'. a little inside joke with myself i guess Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811059 Share on other sites More sharing options...
Maq Posted April 16, 2009 Share Posted April 16, 2009 Is this thread solved? yesterday somebody asked a very similar question, and i spent a fair bit of time on it only to realize i read the question as 'last', when it was actually 'latest'. a little inside joke with myself i guess I see, I think I replied in that thread. Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811464 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.