[SOLVED] Is it possible to do this?

[madspof]

Hi everyone i am trying to create a mysql query that finds something in a row when the WHERE in the query has to variables it has to satisfy here is what i am try to do (is this possible):

This is what i have now

$query  = "SELECT url FROM userpic WHERE DP = '1'";

And i need something like this

$query  = "SELECT url FROM userpic WHERE DP = '1' & userid = '$usern'";

i am not sure if this is the correct way of going about it.

 

[revraz]

Replace & with AND and it would work fine.

[madspof]

okay thanks

[toplay]

Yes, use && or AND, but one & because it is a BITWISE operator.

 

http://dev.mysql.com/doc/refman/4.1/en/non-typed-operators.html