I thought this would be simple and there would be advice / tutorials
everywhere for this, but now that I'm working on it, I can't find any
reference except for ASP or Javascript code. PHP/MySQL - 3 form select
menus: Project, Categories, Subcategories. When a Project is selected, the
Categories list is populated based on Project selected, then Subcategories
list is populated based on Category selected. I see this all over the Net,
but through 10 books, there isn't anything specific. I think I get lost
with some of PHP structure since I've been using DW - I end up editing most
of it in order to follow it, but DW works pretty good for getting initial
testing done. I just can't seem to find further guidance on this. So far I
have:
<form enctype="multip art/form-data" action="add_fil e.php" method="post">
<table>
<tr>
<td width="23%" rowspan="2" valign="top"><p ><strong>Projec t:<br />
</strong>
<select name="project">
<?php
do {
?>
<option value="<?php echo
$row_projects['projCode']?>"><?php echo $row_projects['projCode']?></option>
<?php
} while ($row_projects = mysql_fetch_ass oc($projects));
$rows = mysql_num_rows( $projects);
if($rows 0) {
mysql_data_seek ($projects, 0);
$row_projects = mysql_fetch_ass oc($projects);
}
?>
</select>
</p>
<p><strong>
Category:
<select name="category" id="category">
<option>Selec t a category...</option>
<option value="<?php echo $row_categories['catName']?>"><?php
echo $row_categories['catName']?></option>
<?php
do {
?>
<?php
} while ($row_categorie s = mysql_fetch_ass oc($categories) );
$rows = mysql_num_rows( $categories);
if($rows 0) {
mysql_data_seek ($categories, 0);
$row_categories = mysql_fetch_ass oc($categories) ;
}
?>
</select>
</strong></p>
<p>
</p></td>
<td width="26%" valign="top"><p ><strong>Subcat egory:</strong>
<select name="subcatego ry" id="subcategory ">
<option>Selec t a subcategory...</option>
<?php
if (isset('categor y'))
{
if ($row_subcat['catID']==$row_categori es['catID'])
{
do
{?>
<option value="<?php echo $row_subcat['subcatName']; ?>"></option>
<?php
}
while ($row_subcat = mysql_fetch_ass oc($subcat));
$rows = mysql_num_rows( $subcat);
if($rows 0)
{
mysql_data_seek ($subcat, 0);
$row_subcat = mysql_fetch_ass oc($subcat);
}
}
}
}
?>
</select>
Thanks for any help with this.
Chris
everywhere for this, but now that I'm working on it, I can't find any
reference except for ASP or Javascript code. PHP/MySQL - 3 form select
menus: Project, Categories, Subcategories. When a Project is selected, the
Categories list is populated based on Project selected, then Subcategories
list is populated based on Category selected. I see this all over the Net,
but through 10 books, there isn't anything specific. I think I get lost
with some of PHP structure since I've been using DW - I end up editing most
of it in order to follow it, but DW works pretty good for getting initial
testing done. I just can't seem to find further guidance on this. So far I
have:
<form enctype="multip art/form-data" action="add_fil e.php" method="post">
<table>
<tr>
<td width="23%" rowspan="2" valign="top"><p ><strong>Projec t:<br />
</strong>
<select name="project">
<?php
do {
?>
<option value="<?php echo
$row_projects['projCode']?>"><?php echo $row_projects['projCode']?></option>
<?php
} while ($row_projects = mysql_fetch_ass oc($projects));
$rows = mysql_num_rows( $projects);
if($rows 0) {
mysql_data_seek ($projects, 0);
$row_projects = mysql_fetch_ass oc($projects);
}
?>
</select>
</p>
<p><strong>
Category:
<select name="category" id="category">
<option>Selec t a category...</option>
<option value="<?php echo $row_categories['catName']?>"><?php
echo $row_categories['catName']?></option>
<?php
do {
?>
<?php
} while ($row_categorie s = mysql_fetch_ass oc($categories) );
$rows = mysql_num_rows( $categories);
if($rows 0) {
mysql_data_seek ($categories, 0);
$row_categories = mysql_fetch_ass oc($categories) ;
}
?>
</select>
</strong></p>
<p>
</p></td>
<td width="26%" valign="top"><p ><strong>Subcat egory:</strong>
<select name="subcatego ry" id="subcategory ">
<option>Selec t a subcategory...</option>
<?php
if (isset('categor y'))
{
if ($row_subcat['catID']==$row_categori es['catID'])
{
do
{?>
<option value="<?php echo $row_subcat['subcatName']; ?>"></option>
<?php
}
while ($row_subcat = mysql_fetch_ass oc($subcat));
$rows = mysql_num_rows( $subcat);
if($rows 0)
{
mysql_data_seek ($subcat, 0);
$row_subcat = mysql_fetch_ass oc($subcat);
}
}
}
}
?>
</select>
Thanks for any help with this.
Chris
Comment