PHP - check $_POST against 4 separate fields in MySQL database table

Marking this thread as assumed answered.

It sounds as though your database structure is probably at fault, but if you want to check a single value in four fields, create a recordset like this:

SELECT id FROM mytable
WHERE field1 = myval OR field2 = myval
OR field3 = myval OR field4 = myval

In the Variables section of the Advanced Recordset dialog box, set Name to myval, Type to text, and Runtime Value to $_POST['input_name'] (obviously, change the various names to match your setup).

Let's say you call the recordset "check", you can then use $totalRows_check to see if there are any matches. If there aren't, let the insert go ahead.

if ($totalRows_check == 0) {
  // the insert record server behavior code goes here
} else {
  // redisplay the form with an error message
}

Dreamweaver always puts the code for recordsets immediately above the DOCTYPE declaration, so you will need to move the code around yourself to check whether there are exisiting records before allowing the insert to go ahead.