CODEWITHSUNDEEP
phpmysql
Gabriel Ceniza
Gabriel Ceniza

Reputation: 1

Multiple While Loop Replaces the first Data with the 2nd Data

i have a problem with my code below..

I want to display the data that is not associated with the ID of my $jid but i think i have a problem with my loop. the First data displayed is removed and replaced with the last result...

heres the code. can somebody help me out on this

$check_exist_query = mysql_query("SELECT * FROM physical_abilities_assignment where job_title_id = $jid");

while($check_exist_row = mysql_fetch_array($check_exist_query)){
$list = "";
 $physical_title_id = $check_exist_row['2'];


if(empty($physical_title_id)){

    $display_abilities_query = "SELECT * FROM physical_abilities";
}else{

    $display_abilities_query = "SELECT * FROM physical_abilities WHERE id != $physical_title_id";
}

$display_abilities_result = mysql_query($display_abilities_query);

while($display_abilities_row = mysql_fetch_array($display_abilities_result)){

$abilities_name = $display_abilities_row[2];
  $abilities_id = $display_abilities_row[0];

$list .= "<tr>
                    <td $bgcolor align=center><input type=\"checkbox\" ".$check." name=\"job_title[]\" value=".$title_id." id=\"".$title_id."\"></td>
                    <td $bgcolor style=\"padding-left:5px;\">".$abilities_name."</td>
                    <td $bgcolor align=center><a onClick=\"return confirm('Are you sure you want to delete this entry?');\" href=?do=delete&id=". $row[0] ."><img src=\"images/delete-icon.png\" border=0 ></a>&nbsp;&nbsp;&nbsp;<a href=\"physical-abilities.php?id=$row[0]\"><img src=\"images/edit-icon.png\" title=\"Edit This\" border=0/></a></td>
       </tr>";

}

Upvotes: 0

Views: 146

Answers (1)

user1190992
user1190992

Reputation: 669

$list = "";
$check_exist_query = mysql_query("SELECT * FROM physical_abilities_assignment where job_title_id = $jid");

while($check_exist_row = mysql_fetch_array($check_exist_query)){

 $physical_title_id = $check_exist_row['2'];


if(empty($physical_title_id)){

    $display_abilities_query = "SELECT * FROM physical_abilities";
}else{

    $display_abilities_query = "SELECT * FROM physical_abilities WHERE id != $physical_title_id";
}

$display_abilities_result = mysql_query($display_abilities_query);

while($display_abilities_row = mysql_fetch_array($display_abilities_result)){

$abilities_name = $display_abilities_row[2];
  $abilities_id = $display_abilities_row[0];

$list .= "<tr>
                    <td $bgcolor align=center><input type=\"checkbox\" ".$check." name=\"job_title[]\" value=".$title_id." id=\"".$title_id."\"></td>
                    <td $bgcolor style=\"padding-left:5px;\">".$abilities_name."</td>
                    <td $bgcolor align=center><a onClick=\"return confirm('Are you sure you want to delete this entry?');\" href=?do=delete&id=". $row[0] ."><img src=\"images/delete-icon.png\" border=0 ></a>&nbsp;&nbsp;&nbsp;<a href=\"physical-abilities.php?id=$row[0]\"><img src=\"images/edit-icon.png\" title=\"Edit This\" border=0/></a></td>
       </tr>";
}

echo $list;

Try this.

Upvotes: 1

Related Questions