Posted by strawberry on 10/26/06 18:14

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

Maybe it should be price.size_key = 'f2' order by vinalux.fabric...

[Back to original message]