PHP mysql if else -


i'm trying write if else statement dependent on value of mysql field.

basically, in awards table, if id_project prj000 want $tempid , $tempprojectname different values.

right code runs results on page following "else" code block, makes me think i've set "if" wrong. advice?

<?php $query  = "select * `awards` "; $query  .= "where `active` = '1' "; $query  .= "order `date` desc "; $query  .= "limit $idstart, 10 ";  $result = mysql_query($query);  while($row = mysql_fetch_array($result)){     $query2  = "select * `projects` ";     $query2  .= "where `id_fm` = '".$row["id_project"]."' , `active` = '1' ";     $result2 = mysql_query($query2);      while($row2 = mysql_fetch_array($result2)){     if($row["id_project"] == "prj000"){         $tempid = "#";         $tempprojectname = "general";     }     else {         $tempid = $row2["id_x"];         $tempprojectname = $row2["title"];     }     }     ?> 

i misunderstood code , made mistake in last answer, replacing updated code

<?php $query  = "select * `awards` "; $query  .= "where `active` = '1' "; $query  .= "order `date` desc "; $query  .= "limit $idstart, 10 ";  $result = mysql_query($query); while($row = mysql_fetch_array($result)){ $projectid = $row["id_project"]; //set variable here , use later     $query2  = "select * `projects` ";     $query2  .= "where `id_fm` = '$projectid' , `active` = '1' ";     $result2 = mysql_query($query2);      while($row2 = mysql_fetch_array($result2)){     if($projectid == "prj000"){         $tempid = "#";         $tempprojectname = "general";     }     else {         $tempid = $row2["id_x"];         $tempprojectname = $row2["title"];     } } ?> 

Comments