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/
