Insert into database help?

OK I have this form that inserts stuff into a database so I can later display the information I insert. And I order it by newest, the code I use for that is

Is this wrong or right? What I want it to do is display the newest one I inserted on top, because it's a Top 10 Recent Updates section. It inserts everything I do, but sometimes doesn't display it before the older ones I've inserted which is the whole point of this script.

But anyway, when I looked in phpMyAdmin in my table, it had some of the stuff I entered into it, but also a bunch of empty fields as well. What could be the problem?

I've been just getting into PHP lately, so I'm not 100% sure on this, but this is what I use on one of my queries.

This is sorting my table by the i_id, newest one being on the top and I'm limiting the results to 1, which is the newest entry.

So for yours maybe try

Your SQL statement is not selecting the 10 newest entries. It is selecting the last 10 entries when ordered by "name". That's a subtle difference I know, but if "name" is a string then you'll get the last 10 in descending alphabetical order. Try ordering by id. Also, your LIMIT clause is technically correct, but you don't need the 0. 0 is the default offset, so LIMIT 0,10 is the same as LIMIT 10.

Originally Posted by ditch182 Your SQL statement is not selecting the 10 newest entries. It is selecting the last 10 entries when ordered by "name". That's a subtle difference I know, but if "name" is a string then you'll get the last 10 in descending alphabetical order. Try ordering by id. Also, your LIMIT clause is technically correct, but you don't need the 0. 0 is the default offset, so LIMIT 0,10 is the same as LIMIT 10.

Did you read anything I typed?

I didn't mean to step on your toes Jako. I was just trying to give Caden some more information as to why his query wasn't working. What you wrote is absolutely correct, and you are both a gentleman and a scholar.

Originally Posted by Jako I've been just getting into PHP lately, so I'm not 100% sure on this, but this is what I use on one of my queries. PHP Code: $image_id = "SELECT * FROM images ORDER BY i_id DESC LIMIT 1";  This is sorting my table by the i_id, newest one being on the top and I'm limiting the results to 1, which is the newest entry. So for yours maybe try PHP Code: $queryRecent = "SELECT name FROM table ORDER BY id DESC LIMIT 10";

this is the right query.