[Resolved] Does PHP/MYSQL allow me to do a "Choose"?

[szym9341]

I have a table that contains 4 columns.

(1) item_id
(2) item_description
(3) color
(4) price

I would like to choose all of the items where "color = brown", then choose the one item with the lowest price and return its item_id .

$getitems = @mysql_query("SELECT * FROM items
                          WHERE color = brown");
??

please help...

[adi]

Use something like:

$getitems = @mysql_query("SELECT MIN(price) FROM items 
                          WHERE color = brown"); 

--------------------------------------------------------------------------------

[szym9341]

I tried.. but I must be doing something wrong... any ideas? (this time I am searching where a certain style id)

$getitems = @mysql_query("SELECT MIN(our_price) FROM items
                          WHERE style_id = $style_id");
$our_price = mysql_fetch_array($getitems);
$low_price = $our_price["our_price"];
echo "$low_price";

[szym9341]

any ideas anyone??

[planetsim]

$getitems = mysql_query("SELECT MIN(our_price) AS minprice FROM items 
                          WHERE style_id = $style_id"); 
$our_price = mysql_fetch_array($getitems); 
$low_price = $our_price["minprice"]; 
echo "$low_price";

Try that and dont use the @ it supresses errors it should only be used when its for commercial use whn distributing.

[szym9341]

It worked!!! Thanks so much!!