CodingForums.com - View Single Post - PHP -MYSQL Aprox price Calc help

Apostle4 · 01-22-2013, 07:36 PM

Thanks for the reply but when i use your code it fails as per below:
***********************
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\index.php on line 134

***********************

line 134 is the following:

PHP Code:


			
while($row = mysql_fetch_array($result))

If I remove the items in bold in your code:

PHP Code:


			
SELECT type, MIN(price) AS minprice, MAX(price) AS maxprice FROM bob GROUP BY type WHERE type='$drop' AND subtype='$drop_2' AND ssubtype='$drop_3'

it sort of works but seems to display only the first two values of the requested data:
Aprox Lowest Price Aprox Highest Price
$40.00 $50.00

is there something i'm missing ?

01-22-2013, 07:36 PM	PM User \| #3
Apostle4 New Coder Join Date: Jan 2013 Posts: 10 Thanks: 1 Thanked 0 Times in 0 Posts	Thanks for the reply but when i use your code it fails as per below: ********************* Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\index.php on line 134 ********************* line 134 is the following: PHP Code: `while($row = mysql_fetch_array($result))` If I remove the items in bold in your code: PHP Code: `SELECT type, MIN(price) AS minprice, MAX(price) AS maxprice FROM bob GROUP BY type WHERE type='$drop' AND subtype='$drop_2' AND ssubtype='$drop_3'` it sort of works but seems to display only the first two values of the requested data: Aprox Lowest Price Aprox Highest Price $40.00 $50.00 is there something i'm missing ? Last edited by Apostle4; 01-22-2013 at 10:20 PM..