Re-Setting the ID number?
Posted 13 July 2006 - 12:35 AM
it comes later and not in-order by name. Since i cannot order by name due to complexities, how can I re-assign the id numbers in my database so that
the restaurants are displayed alphabetically correctly within each city. I can do a script each time for each city does not bother me. I want to keep my data of course. Hope you can help and thanks.
Posted 13 July 2006 - 12:50 AM
It might take a while, I would try re-thinking your database.
Posted 13 July 2006 - 01:36 AM
Why can't you simply display them in alphabetical order (ORDER by restaurant_name for example)?
Posted 13 July 2006 - 10:07 PM
Posted 13 July 2006 - 10:24 PM
ORDER BY restaurant_city ASC, restaurant_name ASC
this will sort by city first, then among each city, by restaurant name.
(agreed about the importance of leaving a key be)
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users