[SOLVED] New to PHP....help with query please!

[g3mma111]

I am trying to get records from the database where the username= $username and the comment does not equal $comment. Ive heard != means not equal so this is what i have so far:

 

 $sql="select * from comments where (tousername= '$username') AND (commment != $comment) ORDER by date";

 

im not sure if its meant to be in brackets??? I basically dont have a clue what im doing..

[micah1701]

unless $comment is a number, you need single quotes around it

 

comment != '$comment'

 

also, sometimes it works better to use NOT LIKE instead.

 

comment NOT LIKE '$comment'

 

this also lets you throw in some wildcard, like:

 

comment NOT LIKE '%$comment$'

[reages]

check your comment comparison... isn't it supposed to be string?

 

instead of:

$sql="select * from comments where (tousername= '$username') AND (commment != $comment) ORDER by date";

try

$sql="select * from comments where (tousername= '$username') AND (commment != '$comment') ORDER by date";

 

also, don't forget to check for other syntax, such as spelling. commment?

 

regards.