help for my configurator

[Anon]

I have a working code in order to show items from db combo box. my code is :

<?php

$connection = mysql_connect("localhost","nobody","");
$db = mysql_select_db("price");
$result = mysql_query("SELECT * FROM pricelist where Field1 like 'INTEL%' OR Field1 like 'DURON%' OR Field1 like 'AMD%' OR Field1 like 'CPU COOLER%' OR Field1 like 'COOLER%' ");

if (mysql_num_rows($result)) {
print '<SELECT NAME="MultiSel" SIZE=1>';
print "\n";
while ($row = mysql_fetch_object($result)) {
print "<OPTION>$row->Field1\n";
}
print "</SELECT>\n";
} else {
print "No Values!\n";
}

?>

well,but in order to make it configurator i will have to show the price in list box agains every
item. here comes the problem.. i dont have an idea how can i take the price from db and put it on the
right place against every right item. please,if you could help me ,let me know how to.

thank you,
Iva

[matto]

perhaps this is the way:

...
print "<OPTION>$row->Field1 $row->Pricefield</OPTION>\n";
...

(assuming the price is stored in a field named Pricefield)