DD and Mysql Error
Can anyone help with this error? 0){ while($rowc = mysql_fetch_array($resc)){ echo $rowc[3]; } } ?> $
My site address is our_packages.php
The code for the DD is below:
<tr>
<td colspan="5" bgcolor="#2a2a2a" height="19"><p>
<label for="parent"></label>
<span class="Herman4">Start By Determining Your Business Here:</span></p>
<p>
<label for="child"></label>
<label for="parent2"></label>
<select name="state" id="state" >
<?
$sqlc = "select * from tbl_state order by fld_sname";
$resc = mysql_query($sqlc);
$countc = mysql_num_rows($resc);
if($countc > 0){
while($row = mysql_fetch_array($resc)){
?>
<option value="<?=$row['1']?>">
<?=$row['1']?>
</option>
<?
}
}
?>
<?php
do {
?>
<option value="<?php echo $row_Parent['fld_id']?>"><?php echo $row_Parent['fld_sname']?></option>
<?php
} while ($row_Parent = mysql_fetch_assoc($Parent));
$rows = mysql_num_rows($Parent);
if($rows > 0) {
mysql_data_seek($Parent, 0);
$row_Parent = mysql_fetch_assoc($Parent);
}
?>
</select>
<select name="bname" id="bname" >
<?
$sqlc = "select * from tbl_bname order by fld_bname";
$resc = mysql_query($sqlc);
$countc = mysql_num_rows($resc);
if($countc > 0){
while($row = mysql_fetch_array($resc)){
?>
<option value="<?=$row['1']?>">
<?=$row['1']?>
</option>
<?
}
}
?>
<?php
do {
?>
<option value="<?php echo $row_Child['fld_id']?>"><?php echo $row_Child['fld_bname']?></option>
<?php
} while ($row_Child = mysql_fetch_assoc($Child));
$rows = mysql_num_rows($Child);
if($rows > 0) {
mysql_data_seek($Child, 0);
$row_Child = mysql_fetch_assoc($Child);
}
?>
</select>
<label for="target"></label>
<input type="button" value="Add To List" id="submit1" onclick="get()"/>
<input name="remove" id="remove" onclick="WA_RemoveSelectedFromList(MM_findObj('target'),'|WA|0|WA|',-1,'0','None Selected')" value="Remove" type="button" />
<span id="status"></span>
<label for="add">$</label>