Bionoid, I had to fool around with it a bit in order to figure out why your solution worked, and why the enum data type was necessary, but now I see it. Not only did you solve my problem, but you've...
Hey Bionoid, I just looked more closely at your solution, and I think you've put me on the right path (sorry, I posted my last reply before I'd played with your code). That returns one record per...
Bionoid, thanks so much for your reply. The thing is, I'm not trying to sort, I'm trying to return only one record for each box, based on the priority I listed. If there's a record for value, then...
Thanks for your reply, spufi. The table I provided is not an actual table I"m using, just a quick-and-dirty illustration of the point I was trying to make. In my example, I want to assume that the...
I have a table that has from one to four records for each item, each with a different attribute for that item. It's actually a fairly complicated database with chemistry records, but I've created a...
I have a page with an HTML Select object (listbox). When my user makes a selection, I'm using AJAX to create and populate a second listbox. Works great. Then I want my user to select options in the...
I have a browser-based search utility with many .php files and many forms. My users select their query parameters from list boxes and submit the form; a new php page comes up that displays their...
