checking value of fields

[Desbrina]

I know how to do this the extremely long way, but i'm wondering if theres a simpler solution.

I have 6 text fields, all named num1 - num6

I need to make sure that the values in one text fields does not equal the value of another text field

IE: User enters
1 2 3 4 5 6

in the text fields, the values are different, so it does an sql query

if they enter
1 2 3 4 4 5

in them, it comes back saying that you cant have duplicate values and then does nothing else

The only way i know is by using a lot of if statements, but there would be a lot of them doing it that way
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG

[Scott]

The easiest way I can think of is something like this:

[Desbrina]

thanks, works perfectly
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG

[marinaroz]

If this is for some kind of interaction with a user, you could write a javascript script to do the testing instead of going to the server. This way you can serve the user an appropriate error message without having the page refreshed.
_________________
Tarakana NET

[Desbrina]

you, its part of a script where there are 6 text fields, where a user has to enter a value between 1 and 20 in each, but not have the same number in any of them

With the example Scott posted, i can seem to work out where to put the sql statement
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG

[krt]

Easier way:
Box 1: <input type="text" name="num[1]" />
Box 2: <input type="text" name="num[2]" />
Box 3: <input type="text" name="num[3]" />
...

PHP: