PHP General :: View ordered list from MySQL
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Daryl Toogood
03-23-2007 18:09:16 GMT +2
|
I am a bit new to all of this.
I have created a form that people can submit a name and an email address. A number is automaticaly assigned.
I have had to remove a few entries from the database as they had entred their details twice.
There lies my problem - I have re entered some details directly into the database and have assigned them to the numbers that I deleted - now the list is showing the information in a jumbled manor rather than ascending.
I have used the Looper Wizard to view the data.
When I change the view in phpMyAdmin I can see the records in Ascending order, but they are still shown on the page unordered.
Also if people enter their details via the form, the numbers continue from the last number assigned by the database automaticaly, we are therfore also 2 number out!
|
|
|
Razvan Racasanu[InterAKT]  03-26-2007 12:29:46 GMT +2
|
Hello,
When deleting records, the new ones will not have those ids. The counter (when using autoincrement) will just assign them a new number. This is normal behavior.
As for ordering, you need to edit the recordset that you have on your page, and specify by which field you want it to be ordered.
Regards,
Razvan RACASANU
|
|
|
