This has nothing to do with PHP, and you should
never expect a relational database to store records
in a specific order.
If you need to order your data, you should create
a key field. Look up AUTO INCREMENT in the manual,
then, if you have trouble, read
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_0_0.
Use that column to sort your result (look up ORDER
BY in the manual)
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -----Original Message-----
> From: Xinkun Wang [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 24, 2001 12:10 PM
> To: [EMAIL PROTECTED]
> Subject: Insert problem in MYSQL with PHP
>
>
> Hi
>
> I've got a problem about Mysql table. if I insert several records in a
> certain order, firstly it is ok, but when I delete them and insert those
> records again (in the same sequence), But the order in MySql is totally
> different. For instance, I have 78 records, when I do insert
> secondly, it dispalys 58th record firstly and others in reverse order.
> Anybody know why? (I use PHP script)
>
> Thank you in advance.
>
> Xinkun WANG
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
