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

[Rik Thomas <rikt@xxxxxxxxxxxxxxxx>]

On Fri, 23 Nov 2001, Brian Feliciano wrote:

> i have this SELECT query that it doesn't show any result..
> it is very inconsistent, it works with other fields but it doesn't with
> others...
> and the sad part is, it doesn't give any error msgs.
> 
> i don't if my other database is growing rapidly(i have more than 400 tables)
> causes this.
> 
> i'll give you the genearated sql statement:
> 
> >>>>>>>>>>>>>>>>>>>>>>>>.
> 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
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> 

wow nasty long query, you would be best served e-mailing an appropriate 
list, like the Mysql list.

-- 
Rik Thomas 
rikt@xxxxxxxxxxxxxxxx http://SmartBackups.com
Is your Website Smart? Automated Website backups.  Free 30Day trial!
http://www.cobalt-hosting.com  15 minute setup! $6.95 and up.
Ph: 888.845.6856 Fx: 302.672.7315 ICQ: 879956