multiple insert queries causing problems.. HELP!

[sois]

I have series of queries i am uploading to a database. they are stats for players. (one insert for QB, one instert for RB , on insert for team stats... etc)

for some reason, they go into the database all out of order. like RB3's stats will go in before RB1, even though i have RB1's insert query listed before RB3's.

is there any way to make these go in in order? do i have to disconnect and then conenct from the DB after every player?

help!

[devinemke]

post the code

[BSTRhino]

Hi sois,

If you learn the theory of relational databases, you'll learn that tables are unordered. So, the order you enter the data into the database will have no effect on the order they come out.

When you query the database to get data out, that is when you specify the order. So for example:

SELECT * 
FROM myTable
ORDER BY id ASC

Will return all the data in myTable in order of ID. You can also specify to see them in a different order:

SELECT * 
FROM myTable
ORDER BY views DESC

My point is, if you just go:

SELECT * FROM myTable

There is no guarantee that myTable will be in any order, you need to specify a field in the ORDER BY clause when you query if you want everything in a particular order.

Most people make an ID field that is set to AUTO_INCREMENT, and so that will increase by 1 each time a new row is inserted. If you sort by a field that is set up like that, you'll get the data in the order you added them to the table.