Easy Script

[Space Cowboy]

This might sound a realy stupid question but i cant get my head around it! Im tryin to set ALL the values for the colum logedin to 0, im ussing the bellow script but it not working, can some one point me in the right direction, thanks!

<?php

include 'config.php';
$do = mysql_query("UPDATE Finnal_Users SET Logedin = 0 WHERE username='username' LIMIT 1") or die(mysql_error());
mysql_close($l);
?>

[Man1c M0g]

Try this:

<?php
include 'config.php';
$do = mysql_query("UPDATE Finnal_Users SET Logedin = 0 WHERE Logedin > 0") or die(mysql_error());
mysql_close($l);
?>

That'll set all Logedin rows to '0', whatever the username.

[ParaSnake]

@Cowboy:Your Script got wrong because of LIMIT = 1,this makes the script run only one
Try to use Mog`s solution,its right

[Space Cowboy]

Thanks again guys works perfectly!