SQL question

Hello!

What might be wrong here please? I am using mySQL and PHP, both status and konferensid is of the datatype int.

$result = mysql_query("SELECT * FROM deltagare WHERE 1=status AND $id=konferensid",$db);

Thanks in advance.

Klas

Hi Klas

You have the order backwards...try

$result = mysql_query("SELECT * FROM deltagare WHERE status=1 AND konferensid=$id",$db);

hth

Bastien

The order is totally irrelevant, it is just a comparison between two expressions.

Hello!

It is working now, the code I sent, there must have been some error with the variables(not the SQL statement)

Thanks for the response.

Klas