jordankab Posted June 14, 2010 Share Posted June 14, 2010 Hey guys, I am having trouble coming up with a way to do this: I have two pages. One is an html page, which code looks like this: <html> <head> <link rel="stylesheet" type="text/css" href="style.css"> </head> <form action="abc123.php" method="POST"> Say it:  <input type="text" name="talk" class="style1" />  <input type="submit" value="Go!" class="input"/> </form> </html> So pretty much, its just asking for a string. Here's the roadblock. I want my PHP file called abc123 to do these things: - get what you said (I know how to do this). - enter it into a database (I have created). - echo back last 99 rows in the database of UNIQUE messages. So, this site will be a public message board, but I'm having a little trouble. Thanks, Jordan. Quote Link to comment https://forums.phpfreaks.com/topic/204753-calling-last-99-rows-in-database-echo-them-to-user/ Share on other sites More sharing options...
ignace Posted June 14, 2010 Share Posted June 14, 2010 ORDER BY id DESC LIMIT 99 Quote Link to comment https://forums.phpfreaks.com/topic/204753-calling-last-99-rows-in-database-echo-them-to-user/#findComment-1071976 Share on other sites More sharing options...
jordankab Posted June 14, 2010 Author Share Posted June 14, 2010 ORDER BY id DESC LIMIT 99 Ignace, could you give me an example of where I would put thisin my php code? AKA a syntax example? thanks. Quote Link to comment https://forums.phpfreaks.com/topic/204753-calling-last-99-rows-in-database-echo-them-to-user/#findComment-1072065 Share on other sites More sharing options...
jcbones Posted June 14, 2010 Share Posted June 14, 2010 Append it to the end of the MySQL query. Quote Link to comment https://forums.phpfreaks.com/topic/204753-calling-last-99-rows-in-database-echo-them-to-user/#findComment-1072120 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.