Code: Select all
$query = sprintf("SELECT products.ProductID, ProductName, Description, Price FROM products, product_prices GROUP BY products.ProductID HAVING ProductID REGEXP '%s'",$ID);Code: Select all
do{
$query = sprintf("SELECT * FROM product_prices WHERE ProductID = '%s' ORDER BY PriceOption, Price ASC",$product['ProductID']);
$PRCS = QUERY_DATA($query,$connection);
$price_option = mysql_result($PRCS,0,'PriceOption') ;
$price_list = mysql_fetch_row($PRCS);
while($product=mysql_fetch_assoc(%PRDCTS))Now while this doesnt workUnable to jump to row 0 on MySQL result index...
if i used
Code: Select all
$query = sprintf("SELECT category.CategoryName, cf.ProductID, prdct.ProductName, prdct.Description, cost.Price FROM categories AS category, category_reference AS cf, products AS prdct, product_prices AS cost WHERE cf.ProductID = prdct.ProductID AND cost.ProductID = prdct.ProductID AND category.ID = cf.Category AND cf.Category = %d GROUP BY cf.ProductID ",$category);Kendall