using mysql to populate dropdown

Anon

I am getting an error with this code and I am not sure why, anyone have ideas? I'm new to this PHP thing.

<body>
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "root", "database");
mysql_select_db("litreview",$db);
$sql = "INSERT INTO books (Author,Title,Publisher,Subject,Level,OrderNum,Strat) VALUES ('$Author','$Title','$Publisher','$Subject','$Level','$OrderNum','$Strat')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";

} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
Author:<input type="Text" name="Author"><br>
Title:<input type="Text" name="Title"><br>
Publisher:<input type="Text" name="Publisher"><br>
Subject:<input type="Text" name="Subject"><br>
Level:<select name="Level">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select><br>
Order Number:<input type="Text" name="OrderNum"><br>
<select name="Strat">
<?php
mysql_query(SELECT * FROM readstrat);
while ($myrow = mysql_fetch_array($result))
{
printf("<option value='$myrow[Strat]'>$myrow[Strat]</option>");
}
?>
</select>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
} // end if
?>
</body>

Anon

This could be an error:

mysql_query(SELECT * FROM readstrat);

should be:

mysql_query("SELECT * FROM readstrat");

Next time, please tell us what the error is. That way we can look at the code and have an idea of what could have happened and we'd resolve your problem faster.

Diego

Anon

I am getting the following error... everthing shows up on the page but the dropdown is not populated and directly after it I get this error:

Warning/Library/WebServer/Website/sql/sqltest2.php19

Thanks for all the Help.

The new code I am using is :

<body>
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "root", "database");
mysql_select_db("litreview",$db);
$sql = "INSERT INTO books (Author,Title,Publisher,Subject,Level,OrderNum,ReadStrat1) VALUES ('$Author','$Title','$Publisher','$Subject','$Level','$OrderNum','$ReadStrat1')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";

} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
Author:<input type="Text" name="Author"><br>
Title:<input type="Text" name="Title"><br>
Publisher:<input type="Text" name="Publisher"><br>
Subject:<input type="Text" name="Subject"><br>
Level:<select name="Level">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select><br>
Order Number:<input type="Text" name="OrderNum"><br>
<select name="ReadStrat1">
<?php
mysql_query("SELECT * FROM strats");
while ($myrow = mysql_fetch_array($result))
{
printf("<option value='$myrow[ID]'>$myrow[strats]</option>");
}
?>
</select>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
} // end if
?>
</body>

Anon

The mysql_query results are not set into a var (that you are trying to call in the while loop as $result). Try this code:

$result = mysql_query("SELECT * FROM strats");
while ($myrow = mysql_fetch_array($result))
{
printf("<option value='$myrow['ID']'>$myrow['strats']</option>");
}

I've also added singlequotes when calling the $myrow-array.

Hope that helps!

Vasse

Anon

I tried that new code and now get a new error.... any ideas on what could cause this:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /Library/WebServer/Website/sql/sqltest3.php on line 22

Thanks....

vasse

Oops, my bad 🙂

$result = mysql_query("SELECT * FROM strats");
while ($myrow = mysql_fetch_array($result))
{
print "<option value='" . $myrow['ID'] . "'>" . $myrow['strats'] . "</option>";
}

This should work fine though 🙂

Vasse

Anon

If that is your complete code then the else statement has no DB connect. SO the SQL statement at the end can't be run.

Go back to $myrow["ID"] to get rid of the second error.

HTH

Anon

Thanks guys..... I finally got this thing to work, can't believe I didn't see the if/else connect thing. Thanks.