[cfaussie] Re: Query

[Brett Payne-Rhodes]

What result do you get if you run:
SELECT BRAND_ID, NAME
   FROM products
  WHERE products.MENU_SUBCAT_ID = #Flash.Param1#
Then look in the brands table and see if there are any brands with the 
returned brand_id's

You might like to dump the results back here if they're not too big...
Brett
B)
Bjorn Schultheiss wrote:
Im in mysql-front and I'm running that query in the sql-editor and
substituting #flash.param1# for 11
And I aint getting any results back, in products.MENU_SUBCAT_ID both entries
have 11 in that field
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brett
Payne-Rhodes
Sent: Saturday, 16 April 2005 9:54 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Query
Hi Bjorn,
If all you want is BrandName and ProductName then
SELECT products.NAME as ProdName, brands.NAME as BrandName
   FROM products, brands
  WHERE products.MENU_SUBCAT_ID = #Flash.Param1#
    AND brands.BRAND_ID = products.BRAND_ID
Should do what you want.
Regards,
Brett
B)
Bjorn Schultheiss wrote:
I know I already gave you guys praise, but that sql statement didn't work
for me
Heres want I want to achieve
Below are the tables, I stripped out most of the fields
CREATE TABLE products (
 PRODUCT_ID int(6),
 MENU_SUBCAT_ID tinyint(4),
 BRAND_ID int(4),
 NAME varchar(50),
 PRIMARY KEY  (PRODUCT_ID)
)
CREATE TABLE brands (
 BRAND_ID int(4),
 NAME varchar(50),
 PRIMARY KEY  (BRAND_ID)
)
My param I'm passing from Flash relates to products.MENU_SUBCAT_ID
SELECT products.NAME as ProdName, products.BRAND_ID, brands.NAME as
BrandName 
FROM products, brands 
WHERE products.BRAND_ID = brands.BRAND_ID 
AND products.MENU_SUBCAT_ID = #Flash.Param1#

I need a result like
BrandName, ProdName;
I-mate   , smartphone;
Guys this is killing me 

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

--
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
f: +61 (0)8 9371-0470
m: +61 (0)414 371 047
e: [EMAIL PROTECTED]
w: www.ehc.net.au
---
You are currently subscribed to cfaussie as: archive@mail-archive.com
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/