Parse error help.

d00dle

This is all that is around the line. The line with the error is the next to the last one.

{
				$randnumber = rand(1,2);
				if($sugt2 == $randnumber) { 
				mysql_query("INSERT INTO `auraed` (`boardid`,`topicid`,`messageid`) VALUES ('$board','$topic','$message')");
                $sugaura = mysql_query("SELECT `aura` FROM `users` WHERE `userid` = ".$ub["userid"].");
						$newaura = ".$sugaura." + 3;
				mysql_query("UPDATE `users` SET `aura` = ".$newaura." WHERE `userid` = ".$ub["userid"].");
		}

njm

The syntax highlighting should give you a clue 😃 You're missing a closing " on the line above,

hth, njm:

AstroTeg

If you take a look at the syntax highlighting colors, you'll notice line four is red instead of blue. This indicates a possible problem with your string delimiters (referring to quotes and single quotes). If you have a syntax highlighting PHP editor, it will probably show you similar results.

If you check out line 4, you'll see at the very end you have ."); Here you have the . and " but there's no more string. You can just drop the ." part.

Line 5 has similar issues. You have $newaura = ".$suguara." + 3 which doesn't make a lot of sense. You're attempting to take the result set (which is what $suguara is) and wrap periods around it, and then add 3 to the string. I'd recommend pulling this line out and look up the various mysql() commands needed to retrieve data from a result set.

AstroTeg

Originally posted by njm
The syntax highlighting should give you a clue 😃 You're missing a closing " on the line above,

hth, njm:

You beat me to the post!

Is line 5 even correct? If it is, I haven't seen result sets accessed like that before...

njm

You beat me to the post!

Yeah, but only by a few seconds 🙂
Line 5 looks OK to me?

regards, njm

AstroTeg

Really? Even though $sugaura is a result set?

I mean, if $sugaura was a string or a number, there's no problems with that line. But PHP will allow you to directly access the result set like that instead of using mysql_fetch_array/row/object() ?

If so, then I have learned something new today...

njm

Um, well from a SQL structure point of view it looked OK...😉 I guess I didn't really look at the variable.
Now I do it makes the line above look odd as well (your earlier post mentioned it, maybe that's why I managed to reply quicker 🙂 )

regards, njm