[SOLVED] How to INSERT @ row 0

[FlyingIsFun1217]

Hey!

 

For a project I have, table results are returned in what seems to be a FIFO order (as in the first result, row 0, is returned first, and the last row will be returned last), and since I want to have new results returned first, I would like to insert new results into the table 'at the top'. Is there an easy way to do insert operations at row 0?

 

Thanks!

FlyingIsFun1217

[MadnessRed]

this is a complete guess but would it be done like this?

 

ALTER TABLE `##table name##` ADD `##new news##` BEFORE `##Whatever is first atm##` ;

[FlyingIsFun1217]

Ok, I see how I could go about doing that.

 

I found it easier to just add a 'number' field, set it to auto_increment, and sort descending by it.

 

Thanks for your help!

FlyingIsFun1217

[MadnessRed]

like mikelmao is doing.

 

http://www.phpfreaks.com/forums/index.php/topic,203375.0.html

[FlyingIsFun1217]

like mikelmao is doing.

 

http://www.phpfreaks.com/forums/index.php/topic,203375.0.html

 

That was quite comical. Either way, I've fixed it.

 

Thanks!

FlyingIsFun1217