Re: Insert problem in MYSQL with PHP

2001-01-28 Thread Adrian D'Costa
On Wed, 24 Jan 2001, Xinkun Wang wrote: | |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 7

RE: Insert problem in MYSQL with PHP

2001-01-24 Thread Carsten H. Pedersen
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#c