Hello,
i am making a database, i have 5 tables:
USER:
userid (PK)
password
name
PROYECT:
projectid (PK)
userid (FK)
COUNTRY:
countryid (PK)
projectid (FK)
STATE:
stateid (PK)
countryid (FK)
CITY:
cityid (PK)
stateid (FK)
i have a php web, i have 4 drop down menu, the first one has to show me the proyects, dependeding on the project i have choosen,
the second drop down menu has to show me the countries that have been assigned to that project, depending on the country i have choosen,
the third drop down menu has to show me the states assigned to that country, depending on the state i have choosen
the third drop down menu has to show me the cities assigned to that state.
if you know how i can do this or you have a manual please provide it to me, THANKS!!!!!!
require('conn.php');
sql="SELECT proyectid FROM proyect";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$id=$row["id"];
$menu=$row["menu"];
$options.="<OPTION VALUE=\"$id\">".$menu;
}
?>
<SELECT NAME=menu>
<OPTION VALUE=0>Choose
</SELECT>