Posted by Paul Lautman on 10/26/06 18:11

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
>
>
> Could you give me a clou
> thanks for your time
>
> Fedor

Try:
$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'";

[Back to original message]