Query problem

[Monk3h]

		mysql_query("update players set message=$message where ownerid = '1'");

 

When i print out the $message is prints what it should.

 

When i change the query to update message to = message it updates all feilds as it should.

 

But when i want to do it to all feilds where the ID = 1 it wont let me.

 

Yes, there are feilds where there ownerid is 1, so thats not the probelm.

 

any ideas?

[.josh]

mysql_query("update players set message='$message' where ownerid = '1'");

[Monk3h]

that didnt work.. :/

 

ownerid is an INT with a char limit of 14, if that helps? =/

[revraz]

mysql_query("update players set message='$message' where ownerid = 1");

 

If you use mysql_error after the query, it will tell you where your error is.

[Monk3h]

Nope, that didnt work ether.. :/

[revraz]

 

If you use mysql_error after the query, it will tell you where your error is.

[Monk3h]

When i add mysql_error below the SQL query i get.

 

Parse error: syntax error, unexpected T_PRINT in /home/monk3h/public_html/projectalpha/overview.php on line 65

 

When i remove it the error disapears.

[.josh]

mysql_query("update players set message='$message' where ownerid = 1") or die(mysql_error());

[Monk3h]

if ($step == 'message'){

mysql_query("update players set message=$message where ownerid = $stat[id]");
mysql_error
Print "<br><br><br>Message Successfully Uptaded.<br><br><b>New Message:</b> $message";  // Line 65
}

[Monk3h]

Unknown column 'ownerid' in 'where clause'

 

 

That column does exist, it is spelt exactly the same and it is in my alphaground table.

 

I dont see what the problem is. :/

[Monk3h]

Is there a longer way of doing what im trying to do?

 

Select from maybie?

 

 

Then n SQL update?

 

Im unsure on the syntax.

[imdead]

 					  mysql_query("update `players` set `message`='$message' where `ownerid` = '$stat[id]'");