PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
<?PHP
mysql_connect("localhost", "xxxx_xxxx", "xxxx") or die(mysql_error());
mysql_select_db("xxxx_xxx") or die(mysql_error());
$sql = "SELECT * FROM `ihsreg` ORDER BY `Bloom_Name` ASC";
if (!(@ $result = mysql_query($sql))) {
print "There was an error running your query:<p>\n". $sql . "<p>\n";
}
// You can remove this comment for you script but:
// When you have a ' in side of a string your printing with ' around it (or if you have a " inside of a print that you using " around it) you must excape it but putting a \ in front of it:
print '<select name="Pod_Name, Pollen_Name"
onchange="window.location=\'SEindex1.php?search.value=this.options[this.selectedIndex].text;"><br>\n';
print '<option value="#"> Choose One ';
while ($row = mysql_fetch_row($result)) {
$id = $row[0];
$Pod_Name = $row[4];
$Pollen_Name = $row[5];
$x= x ;
$cross = "$Pod_Name $x $Pollen_Name" ;
print "<option value=\"$id\"";
if ($_REQUEST["Pod_Name,Pollen_Name"] == $id) { print " selected"; }
print "> $cross <br>\n";
}
print '</select>';
?>