HWB Posted March 18, 2007 Share Posted March 18, 2007 Hello everyone, This is a very simple problem, and I'm hoping to find a very simple answer. I've looked on several sites for the answer but no luck as of yet. I'm using a script called MultipurposeForm.php to create an easy dropdown list that will populate text fields below using information from an SQL database. I've managed to modify the script for my needs, except for one remaining issue. The dropdown list is shown in no particular order, and I need this to be shown in alphabetical order. If someone could please take a look at this script and modify the dropdown to be shown in alphabetical order, I would greatly appreciate it. Even more than appreciation, I would gladly pay $15 USD to anyone who can modify the script for me to complete this task. The script can be viewed at http://servicecomplete.net/formtest/soft.php or download the attached script. Thank you in advance! [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
AndyB Posted March 18, 2007 Share Posted March 18, 2007 Modify the query so it selects whatever ORDER by ASC Quote Link to comment Share on other sites More sharing options...
HWB Posted March 18, 2007 Author Share Posted March 18, 2007 Modify the query so it selects whatever ORDER by ASC I'm not wanting to be a pain in the ass, but would it be possible for you to point this out to me in the script? Thank you. Quote Link to comment Share on other sites More sharing options...
AndyB Posted March 18, 2007 Share Posted March 18, 2007 (re)save the example script with a .phps extension(best), or as a text file. Then people can view it online instead of downloading, opening in an editor, blah blah Quote Link to comment Share on other sites More sharing options...
HWB Posted March 18, 2007 Author Share Posted March 18, 2007 (re)save the example script with a .phps extension(best), or as a text file. Then people can view it online instead of downloading, opening in an editor, blah blah Done. http://servicecomplete.net/formtest/soft.txt Quote Link to comment Share on other sites More sharing options...
HWB Posted March 18, 2007 Author Share Posted March 18, 2007 (re)save the example script with a .phps extension(best), or as a text file. Then people can view it online instead of downloading, opening in an editor, blah blah I'm sorry for the multiple replies, but I added the PHPS extension. Thanks a lot PHPS: http://servicecomplete.net/formtest/soft.phps TXT: http://servicecomplete.net/formtest/soft.txt PHP: http://servicecomplete.net/formtest/soft.php Quote Link to comment Share on other sites More sharing options...
AndyB Posted March 18, 2007 Share Posted March 18, 2007 Here's an example. $result = mysql_query ("SELECT nachname, id, vorname FROM autor", $verbindung); returns data in order it was entered $result = mysql_query ("SELECT nachname, id, vorname FROM autor ORDER by vorname ASC", $verbindung); returns data ordered alphabetically by vorname Quote Link to comment Share on other sites More sharing options...
HWB Posted March 18, 2007 Author Share Posted March 18, 2007 Thank you so very much I really appreciate it. If you want the $15, send me a paypal address Quote Link to comment Share on other sites More sharing options...
AndyB Posted March 18, 2007 Share Posted March 18, 2007 If you want the $15, send me a paypal address No,no. Just perform a random act of kindness for someone else Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.