[solved]dynamic pull down...

[dpabla]

IF any noob wants to know how to simply grab data from your mysql table and generate a pull down with the contents...here ya go

[code]
<?php

$result = mysql_query
("SELECT product_name,subcategory_id FROM products
WHERE subcategory_id = {$_GET['sub_id']}");

// printing the list box select command

echo "<div align=center><select name=collection value=''><option value=''>Browse Collection</option><br>";

// Array or records stored in variable named $collection

while($collection=mysql_fetch_array($result)){
$prodname = $collection["product_name"];

// Option values are added by looping through the array

echo "<option value='".$prodname."'>".$prodname."</option>";

// Closing of list box

}

echo "</select>";



?>

[/code]