Update whole dtabase

[Mike4x4s]

i got this code im trying to make it update the online field for all my members to n:

$query = 'UPDATE b_users SET online"'n'" WHERE username="*'"'; 

[MadMike]

I'm pretty sure you can take out the WHERE username="*'" if you want to effect all users.

[Mike4x4s]

not working

<?
include "db_connect.php";
$query = 'UPDATE b_users SET online"n"'; 
?>

[silentcollision]

$query = "UPDATE b_users SET online='n'"; 

?

Off Topic:

I think we might have TicTac v2 here.

[Mike4x4s]

didnt sstill not working

[Mike4x4s]

anyone?

[spikeZ]

when you say it doesnt work, what do you mean? Do you get any errors or does it just not update the database?

If you are setting your entire users database to online then silentcollisions code would haev worked. what does the code look like now?

[megamoose]

not working

<?
include "db_connect.php";
$query = 'UPDATE b_users SET online"n"'; 
?>

All you're doing is setting a variables value. You're not actually doing anything with $query as far as I can see, unless you have some other code you're not telling us.

Also online"n" should probably be `online` = "n"

Mark

[r937]

UPDATE b_users SET online = 'n'

[Mike4x4s]

not working, it jsut dosnt update the database.

[megamoose]

not working, it jsut dosnt update the database.

Mike did you read my last reply? You don't appear to be doing anything to the database, your just setting the $query variable. You need to execute the $query somehow.

Mark

[Dan Grossman]

include('db_connect.php');
$query = "UPDATE b_users SET online = 'n'";
mysql_query($query) or die(mysql_error()); 

[Mike4x4s]

that code worked thanks.

[silentcollision]

You weren't executing the query?

You might want to look up basic PHP structure and tutorials before asking questions.

[tbakerisageek]

Off Topic:

I think we might have TicTac v2 here.

No, he hasn't asked about barcodes yet.

[spikeZ]

Eyes are watching.....