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
Post a Comment