Form Validation

mitch7468

I have a form where 6 items need to be ranked 1 thru 6 via list menues with numbers 1 thru 6 in each. All of the 6 items need to be ranked but none of the items can be ranked the same as any other. For example I can't have two items ranked number 5. I would also like to send the results to mysql. I could probably use a hand on the database setup as well.

I would really appreciate it if someone could hook me up with some advice and get me headed in the right direction.

Any assistance would be appreciated.

Thanks.

Mitch

jpmoriarty

i wouldnt use drop down lists - if you use option boxes, and then name the first ones "1st", second "2nd" etc, then it will only let you select one from each. That way you could list all the items each with 6 option boxes next to them, and they'd only be able to select a position once. Dont know if that messes around with your layout, but it's how i'd do it.

Also how much help do you need setting up the database? if you really have no idea, then i'd check the MySQL manual (http://www.mysql.com), or possibly invest in a good book (I use Web development using PHP and MySQL by Luke welling and laura thompson).

vaska

myphpadmin...or is it phpmyadmin?...will give you alot of help setting up a database...assuming the server is ready to go...

as far as the form validation...option boxes make much more sense...it sounds like a javascript project...you might research from that angle...then have the data passed to the db...

this is a pretty powerful premade script for form validation...it might be customizable to do what you are looking for, but i'm not sure...

http://www.peterbailey.net/fValidate/site.php?page=demo

mitch7468

Thanks folks...think I'm headed in the right direction now. Looks like it's going to be a "custom" job. I appreciate both your responses. Looks like it's going to be java and option boxes. I'll post it back here when I'm done...someone else may be able to use it too.

Thanks for the prompt responses.

Mitch