Quote:
Originally Posted by harmor19
Well he wanted to set all his user styleid to "11" and that was the only way I knew how.
|
If you really wanted to loop through each user individually (don't make sense), then you should have at least have limited the update query to the current userid:
PHP Code:
<?php
require_once('./global.php');
$getusers = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user ");
while($user = $db->fetch_array($getusers))
{
$db->query_write("UPDATE " . TABLE_PREFIX . "user
SET styleid = 11 WHERE userid = " . $user['userid']);
}
?>