Loop and MySQL

[Lamez]

I want to make a loop to run my script for all my users in the DB, but how?

 

I have never made a loop, ever.

Also when it pulls out the user will it be able to define it as $user?

[ratcateme]

$result=mysql_query('SELECT * FROM users');
while($row=mysql_fetch_array($result)){
//do something
}

 

Scott.

[Lamez]

how would I define $user?

 

My code has $user in it to define where to pull info from the DB, and where to update it.

[ratcateme]

i am assuming there is a row in your table called user or something similar make some code like this

<?php
$result=mysql_query('SELECT * FROM users');
while($row=mysql_fetch_array($result)){
$user=$row['user'];
//code to use $user
}
?>

 

Scott.

[Lamez]

man I am retarded, that is is oblivious.

 

Thank you Scott!