ordering info in DB

[Anon]

I have a couple of things in my DB that needs to be ordered by Id #

When I use all this PHP code to insert some info into the base, it isn't ordered by how I want it. How would I order it right?

I tried:
@ ("INSERT into crewInfo (id, ppic, name, style, why, how, other, email, sn, shouts, shoutsS, shortname) VALUES (NULL, '$Cppic', '$Cname', '$Cstyle', '$Cwhy', '$Chow', '$Cother', '$Cemail', '$Csn', '$Cshouts', '$CshoutsS', '$Cshortname') ORDER BY id") or die("Invalid query");

but it failed giving an "Invalid query"

any help?

[Anon]

http://www.mysql.com/doc/I/N/INSERT.html

[mattw]

You got the right idea, but you're just using it in the wrong place. Proceed with your inserts the way you were doing them before you added that ORDER BY on the end. Don't worry about the order they are stored in the database. When you use a select statement to get your data out, then you use the ORDER BY.

Matt Wade
codewalkers.com