[SOLVED] Unexpected '=' error with a database query

[magnetica]

Wasn't sure to post this in the mySql forum or here but gathered here as it's a Php error I am getting

 

Anyway so heres my if else statement

if(isset($_GET['yt_id'])){
	$yt_id = $_GET['yt_id'];
	mysql_query = "UPDATE videos SET thumbs_up = thumbs_up +1 WHERE yt_id == '$yt_id'";

			}

 

And heres the error

Parse error: syntax error, unexpected '=' in /home/a8129045/public_html/include/updatevote.php on line 13

 

Now obviously the mySql query is line 13. I know it's probably simply but can you help?

 

Thanks

[Mark Baker]

WHERE yt_id == '$yt_id'";

should be

WHERE yt_id = '$yt_id'";

SQL is not PHP

[magnetica]

Yea tried that but with the same error I even tried it with a static yt_id that I got from database.

Like so

 

WHERE yt_id = '12345'";

 

But still isn't working?

[PFMaBiSmAd]

mysql_query() is a function. You don't set it equal to a string that you want to query.

 

Please read the examples at this link - mysql_query

[magnetica]

I know it's probably simply but can you help?

 

Thats hilarious, should have known

[Mark Baker]

mysql_query() is a function. You don't set it equal to a string that you want to query.

D***! Why didn't I spot that?