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

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'";

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...