Why is my MYSQL database being read by the wrong column?

Asked Jun 02 '22 at 08:25

Active Jun 02 '22 at 08:29

Viewed 17 times

-3

Here is a list of Id's that I have php print out showing which id is read next in the database.

"Read id's = 1 3 6 2 5 7 8 9 10 12 13 15 16 17 18 19 20 21 23 24 25 11"

I need the id's to be read in order. In cpanel I have the 'id' column with a Primary Key so I thought when doing a Select * my id column would be read in order.

I have looked everywhere in mysql and I can't find anything that might force a particular column to be read in order.

edited Jun 02 '22 at 08:29

Your Common Sense

154,967
38
205
325

asked Jun 02 '22 at 08:25

Apollo31

2

Please include the command you used, and the column information of your table. – ewong Jun 02 '22 at 08:29
here is my database https://prnt.sc/s9WYw09BNJWJ – Apollo31 Jun 02 '22 at 09:34
My database call is: $sql = mysqli_query($con, "SELECT * FROM ride_prices WHERE id >= '1'"); – Apollo31 Jun 02 '22 at 09:34
Data in a table is unordered. Unless you include an `ORDER BY` clause in the query, don't expect to get any specific order. – deceze Jun 02 '22 at 09:38
Thank you so much. I can't believe it was that easy to fix.! :) – Apollo31 Jun 02 '22 at 09:46

Why is my MYSQL database being read by the wrong column?

0 Answers0