$result1=mysql_query("SELECT * FROM members WHERE 1");
if (!$result1) {
echo "here 1";
exit;
}
if (mysql_num_rows($result1) == 0) {
echo "Here2";
exit;
}
while ($row = mysql_fetch_assoc($result1) or die("Here 3")) {
............
some code here
............
mysql_free_result($result1);
}

the page stop loading and it returns Here 3.

When i go in my database i check which users have been updated and all users exept the last one are updated.

heres the error i get on my page.

Warning: mysql_free_result(): 965 is not a valid MySQL result resource in /home/asdf/public_html/asdf.php on line 110

Help me please >_<

Thanks.

XeqtR,

Don't call mysql_free_result() inside your loop. This will free the mysql resource on the first iteration. It should be AFTER your while loop. Also, I don't recommend putting an "or die" clause on a while loop. Eventually all the records will be iterated and you're going to hit that die clause -- die clauses are intended for error detection.

But to answer your question, if you are calling mysql_free_result() inside your while loop, then you are sabotaging any subsequent iterations because it will fail.

What I don't understand is how it is properly updating ANY records beyond the first one.

K so i removed the die and the free result and now i have an infinite loop.

Unless there are an infinite number of entries in your db, the while should go through each row in turn and then evaluate false on the last one.