database ordering and arrays

[Anon]

The database on live server had exactly the same data has that of both dev and our local database. Both the live database was pulling the data in different order than that of both dev and local. The result is when uploading or creating databases on live the order and sequence that the scripts are run are vital. If this is not adhered to records in tables result in different orders, this is particularly relevant when dealing with arrays.

can this be explained

[[deleted]]

If you don't specify an order in your SQL query, the database will give you the results in the order in which it finds the records in the tables.

So you may never rely on the database giving you the correct order, if you didn't tell it how to order the results.