Help Would This Work !

[Anon]

Hi,

I have a number of drop down lists that need to be populated from one table based on the ID field. The query I am thinking of using is:

SELECT ID, Detail, Price FROM tbl_Product_List WHERE ID = 'varID1', varID2'
ORDER BY ID ASC

The variables would be gathered from parameters defined in a list like:

$varID1 = 'CASES'
$varID2 = 'SOFTWARE'

Then as part of the HTML for the select box where the tag name=" " appears I would just call the $varID# in its place.

Does this seem right to you guys or am I missing something.

MAny thanks

Ozzie

[Anon]

Im not great at SQL atall but i think this bit will probably give you errors im not sure but it doesnt look right?

WHERE ID = 'varID1', varID2'

Do you want to return items where ID = varID1 or varID2 ?

[Anon]

ITs a case that I have about 1700 products in one table, there are three columns in the table ID, Details, Price. In the ID Cloumn I may have 40 items that fall under the ID of CASES i need to populate one drop down list with JUST CASES, there will be sround 15 - 20 drop down boxes in a form where a customer can select certain items and have quote built for them dynamically online. I have everthing else sorted out but I can not work out how to do get the data into the drop downs.

Ozzie

[Anon]

Dear Fusion;

Really, I couldn't get your question.

What are the values of ID? What are CASES and SOFTWARE?

Is it the category of the products or ..?

Can explain more so that we can help you?

Solomon

[Anon]

ID is the ID Column in the database which holds the values of 'CASE' and 'SOFTWARE' I need to have drop down one populated with data only connected with CASES and one drop down populated with data connected with 'SOFTWARE'

Each drop down will need to have a display option populated from the DETAILS field in the database and a value option filled from the PRICE field.

Hope that this make more sense

Ozzie

[Anon]

//make your drop down menu
<select name= ........... >

//select the required items
$result_ar = mysql_query('SELECT * FROM items WHERE ID="case"');

while($row_ar = mysql_fetch_array($result_ar)) // LOOP THROUGH SELECTED ITEMS
{

      echo"<option value=\"{$row_ar['com_name']} - £{$row_ar['com_price']}\">{$row_ar['com_name']} - £{$row_ar['com_price']}</option>";

} // END LOOP
// end drop down
</select>

// hope this is helpful

[Anon]

I will try this, thanks alan

[Anon]

<select name=whatever>
$query = "select * from table where ID like 'CASES';
$result = mysql_query($query);
$record = mysql_fetch_object($result1)
echo "<option value= $record->ID>$record->OtherFieldName.....</option";
}
echo "</select>";

do the same for Software...........

solomon