Array Help

[iShaun]

Ok, i have a database setup like this:

 

Name              | Usergroup  | Value

================================

can:view:cat:1  |  1            |  1

-----------------------------------

can:view:cat:2  |  1            |  1

 

 

what i want to do is be able to do:

 

if($array['can:view:cat:1'] == '1')

{

 

return true;

 

}

 

can PHPFreaks help me?

 

[LooieENG]

<?php

$result = mysql_query("SELECT * FROM tablename WHERE Name = 'can:view:cat:1'");
$row = mysql_fetch_array($result);

if ($row['Usergroup'] == 1) {
     // do stuff
}

?>

 

Is that what you mean?

[iShaun]

That won't loop, it will only do it once, im looking for like:

 

foreach($permissions as $permission)
{

$this->permission[$permission['name']] = $permission['value']

}

 

but that doesn't work

[iShaun]

Bump?

[LooieENG]

Ah

 

<?php

$result = mysql_query("SELECT * FROM tablename ORDER BY Name");
$row = mysql_fetch_array($result);

for ($i = 1; $i < mysql_num_rows($result); $i++) {
     if ($row['Usergroup'] == 1) {
          // do stuff
     }
}
?>

[DarkWater]

Looie, that's the worst possible way to fetch results from a mysql database.  First of all, you only call mysql_fetch_assoc() once, second of all, you call mysql_num_rows() EVERY SINGLE TIME you run the loop.

[LooieENG]

Woops, yeah.

 

Always worked for me (when I do it right)

 

What's the better way, I'd be happy to know. (once you solve this guy's problem)

 

Thanks

[DarkWater]

Woops, yeah.

 

Always worked for me (when I do it right)

 

What's the better way, I'd be happy to know. (once you solve this guy's problem)

 

Thanks

 

<?php
//assume $result is a successful query resultset resource
while ($row = mysql_fetch_assoc($result)) {
   //use $row in here
}
?>