I have a fairly large database, and it seems that each time my script loads it's contents, they're always in a different order.
does PHP/MySQL automatially sort results in some way i'm not seeing? and if not. Is there a way to sort (i.e. By ID#)
ORDER BY can control the order. If ORDER BY is not used, usually the data is returned in physical order within the table or based on the query.
See: http://linux.oreillynet.com/pub/a/linux/2001/02/13/aboutSQL.html
