- Home /
PHP MySQL - How to insert row of data
Hey,
I'm writing a PHP file that will take variables from the POST method (I know how to do this) and insert them into a table at the top. Then it will push the other 10 rows down one, and delete the last one.
So basically it's a table with rows of the most recent 10 updates. Here it is:
Thanks for the help!
Answer by jahroy · Apr 21, 2011 at 05:33 AM
I would suggest adding a timestamp column to your table that gets set to the current time when a row is added.
Then you could query the table and order the results by the new column to get what your after.
If you have to limit the number of rows in the table for some reason, you could delete rows 11-n programmatically.
I have a feeling that's not what you're looking for, but here's some quick pseudo-code anyways...
SQL:
CREATE TABLE user_comment (
comment_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
comment_text VARCHAR(100),
comment_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
PHP:
$result = mysql_query("SELECT * FROM user_comment ORDER BY comment_date DESC LIMIT 10");
You could also order the result by comment_id descending to get the same effect.
Thanks very much!
I know the language well enough that I can go off of that pseudo-code. What I really needed was just the structural idea of how to organize it. And using timestamps ins$$anonymous$$d of an id that changes is perfect.
Thank you very much, this should work!
Your answer
Follow this Question
Related Questions
Javascript with php 1 Answer
Web Player and database 1 Answer
Android Mysql Database online 3 Answers
Unity to PHP/MySQL: password and username security 1 Answer
Saving a leaderboard using PHP and C#. 2 Answers