SELECT variable error

[akaballa123]

Hi I am trying to create a specifice sql statement and keep on receiving this error:


Parse error: syntax error, unexpected T_VARIABLE

$orgName = $row['orgName'];
           $content3 .= '<tr><td align="center">' . $orgName ;
           $trainingOrg = @mysql_query('SELECT trainingName FROM addtrainingtbl WHERE organization = '$orgName'');

It seems there is something wrong with my sql variable. Thanks!

 

[hvass]

Not sure this is a MySQL problem you might do better to post in the appropriate forum for the programming language -is it perl?
My guess is that the problem comes from
'$orgName''
and how this gets interpreted by the programming language
Try

$qry='SELECT trainingName FROM addtrainingtbl WHERE organization = '$orgName'';
print $qry;
$trainingOrg = @mysql_query($qry);

I think you will need to escape the quotes
\'$orgName\'

 

[vacunita]

Its a PHP issue. you can't have single quotes inside single quotes and expect it to work, try either back ticks or double quotes there.





----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[akaballa123]

Ye, I included the escape characters, and it worked. Thanks Guys!