Page 1 of 1

HELP... PHP Code passing array to another form

Posted: Fri Dec 23, 2011 12:15 am
by athlhaz
hi can anyone help me.. i want to get the value of the array and when i click the view it will be pass to the next form. the problem is only get the last array sorry for my bad english here my code.

Code: Select all

                <?php
                    include('../Connection/mysql_connect.php');

                    $query = "SELECT * FROM tb_profileimage";
                    $result = @mysql_query($query);
                    $query1 = "SELECT * FROM tb_personalinformation";
                    $result1 = @mysql_query($query1);
                    $query2 = "SELECT * FROM tb_accountinformation";
                    $result2 = @mysql_query($query2);

                ?>

                <?php
                    while($row = mysql_fetch_array($result))
                    { 

                        if ($row[2] != '')
                        {              
                             if($row2 = mysql_fetch_array($result2))
                             {
                                if ($row1 = mysql_fetch_array($result1))
                                {
                                    echo "<li><table width = '1400px'><tr>";
                                    echo "<td width = '140px'><center><img width='50px' height='50px' src='../uploads/$row[2]' style='padding: 5px; margin-bottom: -9px;'/></center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row[1]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[3]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[2]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[11]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[10]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[9]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row1[13]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center>$row2[3]</center></td>";
                                    echo "<td width = '140px' style='padding: 5px; margin-bottom: -9px;'><center><a href = ../ViewEmployee/popupviewemployee.php>View</a></center></td>"; // this is the part where i can view the employee details
                                    echo "</tr></table></li>";
                                    $_SESSION['EmployeeNumber']=$row['Employee_No']; // this is the part where i store the array
                                }
                            }
                        }
?>

Re: HELP... PHP Code passing array to another form

Posted: Fri Dec 23, 2011 4:48 pm
by social_experiment
Have you tried using a while loop with the other two mysql_fetch_array() functions as well?