link via button not working

Discussion in 'PHP' started by zed420, Feb 9, 2009.

  1. #1
    Hi all
    I hope someone can help me, I’m trying to open another page by using checkboxes and JavaScript on a Button. JavaScript is fine it opens up a new page but I can NOT seem to take the checked link, it keeps on opening the last record even thou I’m checking different record. How the hell do I do it? Thanks in advance.
    Page 1
    $query = "SELECT * FROM employee  ORDER BY last_name";
    $result = mysql_query($query)or die(mysql_error());
    ?>
    <div class="medText">
    <b>list of Employees</b>
    <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#BFB5F9">
    <TR bgcolor="#D7D6D2">
    <td align=center><b>ID</b></TD>
    <td align=center><b>Date Reg </b></TD>
    <td  align=center><b>Last name</b></TD>
    <td align=center><b>First name</b></TD>
    <td align=center><b>Address</b></TD>
    <td  align=center><b>Town/City</b></TD>
    <td  align=center><b>Home Tel</b></TD>
    <td  align=center><b>Mobile Tel</b></TD>
    <td align=center><b>Status</b></TD>
    <td align=center></TD>
    </tr>
    <?
    while ($row = mysql_fetch_array($result))  {
        extract($row);
    		echo "<tr class=\"td\">
    <td>	" . $row['employee_id'] . "</a></td>
            <td>" . $row['date_registered'] . "</td>		
    		<td>" . $row['last_name'] ."</td>		
          	<td>" . $row['first_name'] ."</td>
            <td>" . $row['address'] . "</td>		
            <td>" . $row['town_city'] . "</td>		
            <td>" . $row['home_no'] . "</td>		
            <td>" . $row['mobile_no'] . "</td>
            <td>" . $row['status'] . "</td>		
          <td>" ?>
    <input type="checkbox" name="<?=$row[employee_id]?>" id="<?=$row[employee_id]?>" value="<?=$row[employee_id]?>"/>
          <? "</TD>
          </tr>";
    	}	
    ?>
    </TABLE>
    <br><center>
    <? echo" <input type=\"submit\" name=\"view\" id=\"view\" value=\"View Details\" onclick=\"open_win('employee_con2.php?employee_id=$employee_id');\" />" ?>
    </center>
    </div>  
    PHP:
    Page2
    $employee_id = $_GET['employee_id'];
    $query = "SELECT * FROM employee WHERE employee_id = '$employee_id'";
       $result = mysql_query($query)or die(mysql_error());
     	while ($row = mysql_fetch_array($result))  {
        extract($row);
    ?>
    <p></p>
    <center><div id="display"> 
    <?php echo $adminname ?>
    Your New Employee record has been inserted into the databes Successfully. Please check below for details.
    <p></p>
    <TABLE BORDER="0" WIDTH="100%" bgcolor="#CFFEFD"> 
      <TR class="td" align="left"> 
        <TH WIDTH="36%">Employee ID</TH> 
        <TD WIDTH="64%"><?php echo $employee_id ?></TD> 
      </TR> 
      <TR class="td" align="left"> 
        <TH WIDTH="36%" >Employment required As</TH> 
        <TD WIDTH="64%"><?php echo $employment_required ?></TD> 
      </TR> 
      <TR class="td" align="left"> 
        <TH WIDTH="36%" >Registration Date</TH> 
        <TD WIDTH="64%"><?php echo $date_registered ?></TD> 
      </TR>
    </table>
    <?
    }
    ?>
    PHP:
    Zed
     
    zed420, Feb 9, 2009 IP