I should have been more exact in my original reply. The second query
isn't necessary. Try this:
File: login.php
# if $employee_1, query db workgroups table to check if $emp_login_id
belongs to any groups
$sql_2 = "SELECT * FROM workgroups WHERE emp_id='$emp_login_id'";
$result_2 = @mysql_query
:
> Array ( [0] => 222 [1] => 333 ). For some reason, it seems to be skipping
> the first record.
>
> O From Now 'Till Then,
> \->Reginald Alex Mullin
> /\ 212-894-1690
>
> -Original Message-
> From: Mullin, Reginald
> Sent: Monday, March 18,
>Reginald Alex Mullin
/\ 212-894-1690
> -Original Message-
> From: Mark Heintz PHP Mailing Lists [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 18, 2002 1:26 PM
> To: Mullin, Reginald
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Cre
You have to call mysql_fetch_array for each record in your result set...
$emp_login_wkgrp_id = array ();
$emp_login_grp_id = array ();
$emp_login_role_id = array ();
$i = 0;
while($employee_2 = mysql_fetch_array($result_2)){
$emp_login_wkgrp_id[$i] = $employee_2["wkgrp_id"];
$emp_login_grp_i
4 matches
Mail list logo
