[RESOLVED] simple question

[IceRegent]

this may be a simple easy answer, but I am trying to perform an update on one column in an entire table. I am trying to do this:

<?php
session_start();
include 'db_config.php';
mysql_select_db(iceregen_MStudio);
$query = "UPDATE users SET online='OFFLINE' WHERE UserID='*'";
?> 

But, it doesnt work. What is the proper syntax to update every record for that specific column?

Thanks;
Ice

[devinemke]

just leave out the WHERE clause

[IceRegent]

I tired that before I posted, and it did not work, and that is why I need help. I assumed that that would work, and tried that at first, but when it didnt work, I tried it with a where clause using a wild card, but apparently I got that wrong too. I must have some simple syntax wrong.

Ice

[IceRegent]

Uhm, ok, so now I feel foolish. The reason the original attempt didnt work? I didnt actually run the query, just defined it. After I saw this, I placed it in, and changed the syntax back to leaving off the 'where' clause, it worked. Duh.

Thanks;
Ice

[benbox]

Yup, it just needs to be: -

$query = "UPDATE users SET online='OFFLINE'";