[SOLVED] Parse error: syntax error, unexpected T_VARIABLE

[Thomisback]

I know it has already been asked a lot of times & of course I googled this error first but could not figure out the answer.

 

The line which gives me the error is:

$rOCrime = mysql_query('SELECT wapenexpert,leader,chauffeur,auto,wapen FROM $oc WHERE gamename='$prefix' AND id = '.intval($_GET['id']));

 

If anyone knows how to fix this, please let me know!

 

Thank you,

 

~ Thomisback

[budimir]

This is the problem in your query

... FROM $oc WHERE....

 

It needs to say

 ... FROM tablename WHERE....

[ToonMariner]

You are having a couple of problems with your quotes....

try this...

<?php
$qry = "SELECT wapenexpert,leader,chauffeur,auto,wapen FROM " . $oc . " WHERE gamename='" . $prefix . "' AND id = " . intval($_GET['id']);
$rOCrime = mysql_query($qry);
?>

 

Much easier to read what you are trying to do

This method you can echo out your query to check errors in your mysql admin app...

 

[Thomisback]

You are having a couple of problems with your quotes....

try this...

<?php
$qry = "SELECT wapenexpert,leader,chauffeur,auto,wapen FROM " . $oc . " WHERE gamename='" . $prefix . "' AND id = " . intval($_GET['id']);
$rOCrime = mysql_query($qry);
?>

 

Much easier to read what you are trying to do

This method you can echo out your query to check errors in your mysql admin app...

 

 

Thanks a lot, that worked!

 

Sadly I have got another error in this file now, it is a similar one to the one above, I will try to figure it out.

<?php
mysql_query("UPDATE " . $oc . " SET wapen = '.$iWapen.' WHERE gamename='" . $prefix . "' AND id = " . intval($_GET['id']);
?>

 

But I get:

Parse error: syntax error, unexpected ';'

 

I don't see what's wrong with my code... I think I missed out (several) "s?

[Thomisback]

Got it working:

mysql_query("UPDATE " . $oc . " SET wapen = '.$iWapen.' WHERE gamename='" . $prefix . "' AND id = " . intval($_GET['id']));