[SOLVED] Dependant drop down populated by sql

[Kathy]

Hi all!

I am REALLY having trouble with this, I have made a drop down, populated it from a database table called categories and a field called Category, I would now like to populate another drop down from a database table called clients and a field called coName, based on the choice one makes in the categories drop down. I do not know how I would go about connecting the two drop downs?

I have searched everywhere! Would appreciate any help! Thanks!

Here is what I've done so far:

$link = mysql_connect("host","link","pass");
mysql_select_db("dbname", $link);

$query = "select Category FROM categories"; 
$results = mysql_query($query, $link) or die("Error performing query"); 

if(mysql_num_rows($results) > 0){ 
echo("<select name=\"Category\">"); 
while($row = mysql_fetch_object($results)){ 
echo("<option value=\"$row->record_id\">$row->Category</option>"); 
} 
echo("</select>"); 
}/code]

[trq]

So, now you've posted this question in PHP Help, Javascript help and here. What makes you believe it belongs here of all places?