PHP MySQL - How to insert row of data

Question

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: alt text

Thanks for the help!

Answer 1

Best Answer

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.

Add comment · Show 1 · Share

MythStrott · Apr 21, 2011 at 08:39 PM 0

Share

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!

PHP MySQL - How to insert row of data

1 Reply

Your answer

Follow this Question

Related Questions