MySQL - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » MySQL

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

16th Mar 07 at 12:31

What would cause an SQL insert statement to randomly add a record to the beginning of the table and not the end?

Basically every now and again the record will go to the beginning of the table not all the time so im a bit stumped.

its a problem because the blogs lists the comments in the order it features in the database

[Edited on 16-03-2007 by Steve]

James

Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline

16th Mar 07 at 14:05

You got an Id with auto increment set?

PaulW

Member

Registered: 26th Jan 03
Location: Atherton, Greater Manchester
User status: Offline

16th Mar 07 at 17:23

quote:
Originally posted by James
You got an Id with auto increment set?

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

16th Mar 07 at 17:24

iv gotten round this now by adding an ORDER BY and adding an id number field to the table, so whereva the record is in the database it will always order it by id number

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

17th Mar 07 at 12:11

You not got a date column you can order on?

Do a SHOW FIELDS FROM table see if has auto_increment bit in there and also make sure all your INSERTs throughout the programming all insert a blank value for that field.

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

17th Mar 07 at 20:57

thanks ian il give that a go

New Topic

New Poll