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 Quote 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. Quote 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? Quote 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?!? Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/154267-show-latest/#findComment-811464 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.