Page 1 of 1

Help Needed/ PHP, MySql, Javascript

Posted: Tue Mar 22, 2011 1:00 pm
by Ppantel
Hi everyone, any help or comments would be greatly appreciated.

At the code below, I cannot understand why after the page reloads (using the onchange=\"reload2(this.form)\) my selection at the "organism name" dropdown goes back to "Select one" and is not sticking what I selected. However, I did it the exact same way as I did the proposed category" which works (and sticks). (also $CommonName prints the correct value). All that before submitting the form, just by refreshing the page with this "reload" function.

Any comment would be great!

Thanks!

:banghead:

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Report a species </title>

<SCRIPT language=JavaScript>
function reload(form){
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
self.location='editReport.php?ProposedCategory=' + val ;
}

function reload2(form)
{
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
var val2=form.OrganismName.options[form.OrganismName.options.selectedIndex].value;

self.location='editReport.php?ProposedCategory=' + val + '&CommonName=' + val2 ;
}
</script>
</head>

<body>

<?php $ProposedCategory=$_GET['ProposedCategory']; ?>
<?php $CommonName=$_GET['CommonName']; ?>

<h2>Submit a New Report</h2>
<form enctype="multipart/form-data" action="editReport.php" method="post">

<p>
<label>Organism Category:</label>
<?php

$q = "SELECT DISTINCT ProposedCategory FROM tbl_species WHERE ProposedCategory != '' ORDER BY ProposedCategory ASC";
$r = mysqli_query($dbc, $q);

echo "<select name='ProposedCategory' onchange=\"reload(this.form)\"><option value=''>Select one</option>";

while ($row = mysqli_fetch_array($r, MYSQLI_NUM)){
if ($ProposedCategory==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}

echo '</select>';

?>

<p>
<label>Organism Name:</label>
<?php
$q2 = "SELECT DISTINCT CommonName FROM tbl_species WHERE ProposedCategory = '$ProposedCategory' AND CommonName != '' ORDER BY CommonName ASC";
$r2 = mysqli_query($dbc, $q2);

echo "<select name='OrganismName' onchange=\"reload2(this.form)\"><option value=''>Select one</option>";

while ($row = mysqli_fetch_array($r2, MYSQLI_NUM)){
if ($CommonName==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}

echo '</select>';

?>

<p>
<label>Scientific Name:</label>
<input name="ScientificName" type="text" value="<?php if(isset($CommonName)) echo $CommonName; ?>"/>
</p>

</body>
</html>