Oh yes thats fine but im just wondering cause its a bug that been around for ages.

Example:
- I add a row with the wrong values and that takes up the auto increment of number 31
- I delete the...

There must be a fix or way around.

This is a big problem which ive seen re occuring all the time.

Any Ideas?

Thanks, Regards X

I am using phpMyAdmin and as I delete a row, it stuffs up the auto increment once I insert a new row.

Example:
Delete - 21
Insert - 22 (should be 21)

Thanks, Regards X

I figured it out!

Stupid Syntax imo but I know now.

Go the mysql reference manual!

Ya thats what I have been trying.

The problem is I keep getting the same result.

That is:
The table comes out perfect BUT
it comes out backwards...

So what should be first is last, second...

Field Type Collation Attributes Null Default Extra Action
a int(2) Yes 0

they all have the same structure, thats copied and pasted straight from phpMyAdmin.

But like I...

I have multiple columns I wish to order by.

I have columns:
# # # # (1, 2, 3, 4)
A 0 0 0 0
B 1 0 1 3
C 1 0 2 3

I want to ORDER BY 4, 3, 2, 1.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near."

Now this is a really stupid error. (yes that sums up the...

Theres 500 lines worth, so I wont be spamming the forums. In short I just need some sort of concept or idea that allows you to access a row not based on the Primary Key. Eg:


SELECT * FROM WHERE...

Im trying to figure out a way to access a row I 'just created' via the primary key.

As it being a primary key it is auto incremented.

I am using php/mysql to create the row then I require to...