select query problem

[affordit]

I am wanting to use the below code to check table to find out if name OR email address already exists but I get an error. Says syntax error near

 

FROM test Where name = '$name' || email = '$email'";

 

Here is all of the code:

 

$query = "Select name, email, from test Where name = '$name' || email = '$email'";

$results = mysql_query($query) or die(mysql_error()."<br /><br />".$query);

$num=mysql_numrows($results);

if ($name == name) {

print "Name exists";

exit();

}elseif

($email == email){

print "Email exists";

exit();

[revraz]

This might be useful, it's a checkunique function I use

 

function checkUnique($table, $field, $compared){
if (get_magic_quotes_gpc()) {
$table = stripslashes($table);
$field = stripslashes($field);
$compared = stripslashes($compared);
}
$table = mysql_real_escape_string($table);
$field = mysql_real_escape_string($field);
$compared = mysql_real_escape_string($compared);

$result = mysql_query("SELECT $field FROM $table WHERE $field = '$compared'");
if(mysql_num_rows($result)==0) {
return TRUE;
}
else {
return FALSE;
}
}

[affordit]

I have no clue what to do with what you just posted???