execute sql query

gistfile1.aw

// execute sql query //
$query = sprintf( 'SELECT p.productid, p.prodcode AS "Handle", p.prodname AS "Title", p.proddesc AS "Body (HTML)", p.upc AS "Vendor", p.upc AS "Type", p.upc AS "Tags", p.upc AS "Option1 Name", p.upc AS "Option1 Value", p.upc AS "Option2 Name", p.upc AS "Option2 Value", p.upc AS "Option3 Name", p.upc AS "Option3 Value", p.prodcode AS "Variant SKU", p.upc AS "Variant Grams", p.upc AS "Variant Inventory Tracker", p.upc AS "Variant Inventory Qty", p.upc AS "Variant Inventory Policy", p.upc AS "Variant Fulfillment Service", p.prodprice AS "Variant Price", p.upc AS "Variant Requires Shipping", p.upc AS "Variant Taxable", p.upc AS "Image Src", i.imagefile AS "Image Src" FROM isc_products p, isc_product_images i WHERE prodcatids = "37" AND p.productid=i.imageprodid' );
$result = mysql_query( $query, $conn ) or die( mysql_error( $conn ) );