[Resolved] IF Statement

[NZ_Kiwi]

My table will have either 1 or 2... I want my script to either say yes if the value is one but nothing if it's two... currently it says yes either way... what is wrong???

<?php
$result = mysql_query ("SELECT * From results_comp_run where comp_run_id = $comp_run_id");
$row = mysql_fetch_array($result);
$table_exists = $row["table_exists"];
if ($table_exists = '1') {
echo YES;
}
?>

[kburger]

Oops. You're assigning it rather than comparing it.

if ($table_exists = '1')

instead of

if ($table_exists == '1')