in_array() help?

[drummer101]

<?php
while($row = mysql_fetch_array($user_id))
     if(in_array(19, $row)){
          echo "ADMIN<br>";
     } else {
  echo "NOT<br>";
     }
} else {
     echo "You have entered an invalid username/password combination";
}
?>

$row is a sql select statement that will return a quantity of results > 2

 

right now the php codeblock returns, "ADMIN NOT NOT". I can't figure out how to get the loop to stop when it returns true. and continue looping until END or TRUE.

[laffin]

look at this line

mysql_fetch_array($user_id)

 

mysql_fetch_array requires a mysql resource, not a string/value

u obtain a mysql resource with mysql_query

[drummer101]

okay I've changed fetch_array to query, however, the code snippet now returns blank, instead of any results =\

[laffin]

<?php
$res=mysql_query("SELECT * FROM users where username='$user' AND pass='$pass'");

if($row = mysql_fetch_array($user_id))
     if(in_array(19, $row)){
          echo "ADMIN<br>";
     } else {
  echo "NOT<br>";
     }
} else {
     echo "You have entered an invalid username/password combination";
}
?>

 

[drummer101]

One more question. Ran into a problem case checking. It appears that all of the results from $user_id aren't being returned, only the last one is.

 

user_id's are matched to group ID's, so you might have

 

User  Group ID

5        6

5        8

5        10

6        6

7        8

7        10

 

How would I go about assigning all the group ID's of user 5 to an array?

something like $this->sql->group_ids or am I way off base on that?

[sasa]

try

...
$admin = 'NOT<br>';
while ($row = mysql_fetch_array($user_id)) if(in_array(19, $row)) $admin = "ADMIN<br>";
echo $admin;
} else {
     echo "You have entered an invalid username/password combination";
}

[drummer101]

Thanks so much sasa, I only have problem left to solve now, and thats how to get the loop to stop when it returns TRUE and execute until the entire array has been read if in_array returns false.

 

Any tips?

[drummer101]

would

<?php
while($row = mysql_fetch_array($user_id))
     if(in_array(19, $row)){
          echo "ADMIN<br>";
          break;
     } else {
  echo "NOT<br>";
     }
} else {
     echo "You have entered an invalid username/password combination";
}
?>

Work?

[drummer101]

No edit button, arghhh But yes it does work.

 

ninja edit: no mark topic as solved?