Posted by Jerry Stuckle on 10/28/06 00:23

Captain Paralytic wrote:
> fedor wrote:
>
>>I am trying to make a change to a php program,
>>Could you see the error
>>
>>$t = $_SESSION[f_or_temp_data][f_or_st_id];
>>$query = "select vinalux.fabric, size.size_height_max, price.size_key
>> from vinalux join (size, price)
>> where price.size_key = $t";
>>
>>I get the error
>>
>>Could Not Execute SQL statementYou have an error in your SQL syntax.
>>Check the manual that corresponds to your MySQL server version for the
>>right syntax to use near ' price.size_key = f2 order by vinalux.fabric,
>>size.size_wi
>>
>>If I change it to
>>where price.size_key = '$t' ";
>>The error stays the same
>>
>>
>>Could you give me a clou
>>thanks for your time
>>
>>Fedor
>
> Please don't cross post! You have already had your reply in another
> forum
>

Wrong. Cross-posting is good. Multi-posting is bad.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]