Select from where OR where OR where OR where...

[listenmirndt]

$sqlClistings = "SELECT count(*) FROM $table2 WHERE
CATEGORY = '$row[ID]' OR WHERE
CATEGORY2 = '$row[ID]' OR WHERE
CATEGORY3 = '$row[ID]' OR WHERE
CATEGORY4 = '$row[ID]'";
$resClistings = mysql_query($sqlClistings);
$rowClistings = mysql_fetch_row($resClistings);

This dosnt seem to work.. how can I select from where any of the columns equals the correct $row[ID]

Thanks

[laserlight]

You are probably looking for something like:

$sqlClistings = "SELECT COUNT(*) FROM $table2
	WHERE CATEGORY = '{$row['ID']}'
		OR CATEGORY2 = '{$row['ID']}'
		OR CATEGORY3 = '{$row['ID']}'
		OR CATEGORY4 = '{$row['ID']}'";