[Rahil]

Hi everyone,

I'm working on a script where you can view a submission and see if there is already a submission with a similar name or email address in the database. The following SQL query doesn't seem to return the right results. It keeps showing me the same row we're looking at (ie the ID!='$id' isn't working). I think it has something to do with paramater precedence:

PHP Code:

// ID cannot equal $id because we don't want the query to return the same row we're looking at

$sql = "SELECT ID,Artist_name,Artist_email,Artist_URL,Artist_URLtitle FROM gallery_submissions WHERE ID!='$id' AND Artist_name LIKE '$Artist_name' OR Artist_email LIKE '$Artist_email'"; 

However, the following simple query excludes the same row we're looking at:

PHP Code:

$sql = "SELECT ID,Artist_name,Artist_email,Artist_URL,Artist_URLtitle FROM gallery_submissions WHERE ID!='$id'"; 

Can anyone shed some let on this issue? I hope I was clear enough. Thanks in advance!

[mab]

You are right about the cause of this. If we assume that the email has a match, your query evaluates as follows:

WHERE ID!='$id' AND Artist_name LIKE '$Artist_name' OR Artist_email LIKE '$Artist_email'

WHERE anything (id) AND anything (name) OR true (email). The OR will return anything with a matching email.

Use ( ) to force the evaluation logic that you want.

I suspect you want - WHERE ID!='$id' AND (Artist_name LIKE '$Artist_name' OR Artist_email LIKE '$Artist_email')

[Rahil]

Thank you soo much mab! What you said worked perfectly