Insert<select>

[peppeto]

Hi,
<select name="names" size=1>
<?php
echo"<option selected value=''>Chose shop </option>";
$shops = mysql_query("SELECT FROM tblshops");
while($row = mysql_fetch_array($shops))
{
$shop_id = $row["shop_id"];
$shop_name = $row["shop_name"];
$areas = mysql_query("SELECT FROM tblareas");
while($row2 = mysql_fetch_array($areas))
{
$area_id = $row2["area_id"];
$area_name= $row2["area_name"];
echo("<OPTION VALUE='$shop_id,$area_id'>$shop_name, $area_name</option>");
}
}

     ?> 
    </select> 

I dont understand how to INSERT in PHP $shop_id in colom shop_FK en $area_id in area_FK
I tryed with "substr" and "strpos" but it doesen't works
somebody any idea?
thanx

[sarahk]

for simplicity lets rework your query so you only need one while loop.

sql = "SELECT shop_id, area_id, shop_name, area_name
FROM tblshops, tblareas
where tblshops.area_id = tblareas.area_id
order by shop_name, area_name

$areas = mysql_query(sql);

now loop through and build your select which looks fine.

Does this fix the problem or you having problems reading them back in again?