Autopopulate from Select box from database
Posted
by
Chris Spalton
on Stack Overflow
See other posts from Stack Overflow
or by Chris Spalton
Published on 2012-10-01T15:25:14Z
Indexed on
2012/10/01
15:37 UTC
Read the original article
Hit count: 147
hope you can help, please forgive any poor coding or anytihng, I'm new to this and just hacking my way through to get things to work.
That said, on one of my projects I have this code, which successfully populates the dropdown from a database when the page is loaded:
<select name="Region" id="Region">
<option value="">-- Select Region --</option>
<?php
$region=$POST['Region'];
if ($region); {
$regionquery = "SELECT DISTINCT REGION FROM Sales_Execs ";
$regionresult = mysql_query($regionquery);
while($row = mysql_fetch_array($regionresult)) {
echo "<option value=\"".$row['REGION']."\">".$row['REGION']."</option>\n ";
}
}
?>
<script type="text/javascript">
document.getElementById('Region').value = <?php echo json_encode(trim($_POST['Region']));?>;
</script>
</select>
On my next project that I'm working on now, I need to do the same thing, so I copied the above code amended, and placed in my new project:
<select name="Sales_Exec" id="Sales_Exec">
<option value="">-- Select SE --</option>
<?php
$salesexec=$POST['Sales_Exec'];
if ($salesexec);
{
$salesexecquery = "SELECT DISTINCT Assigned FROM Data ";
$salesexecresult = mysql_query($salesexecquery);
while($row = mysql_fetch_array($salesexecresult))
{
echo "<option value=\"".$row['ASSIGNED']."\">".$row['ASSIGNED']."</option>\n ";
}
}
?>
<script type="text/javascript">
document.getElementById('Sales_Exec').value = <?php echo json_encode(trim($_POST['Sales_Exec']));?>;
</script>
</select>
This second chunk of code doesn't work... and I can't work out why as it seems I've copied it all and amended all the neccersary parts, can anyone spot what is wrong?
Thankyou!
© Stack Overflow or respective owner