Re: [cobalt-users] mysql not giving any result

[william ross <will@xxxxxxxxxxx>]

At 12:11 am +0800 23/11/01, Brian Feliciano wrote:
>  >>>>>>>>>>>>>>>>>>>>>>>>.
> SELECT products.id,products.itemname,products.fullpic, products.ourprice,
> products.otherprice, products.description,
> products.ingredients,products.featspecs, products.export, products.lent,
> products.width, products.height, dim_unit.abbr, products.weight,
> wt_unit.abbr, manufacturer.name, products.datemanuf, products.country,
> products.order_inst FROM products, dim_unit, wt_unit, manufacturer WHERE
> products.id='11' AND dim_unit.id=products.dimunit AND
> wt_unit.id=products.wtunit AND manufacturer.id=products.manufacturer
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

I can't see any SQL problems here, but I think products.lent might be a typo?

will