Working with values from a drop-down box
Posted: Tue Apr 29, 2003 7:43 pm
Hello.
I have a drop-down box on my form. To populate it, I use the foreach() commnd, like so:
This works perfectly (as someone I know would say "Runs like a champ"
), but the problem is in newsproccess.php, the action script:
As you can see, I am "echoing" out the query, but the all I get is title=''. No value. How can I make this so it works?
Thanks!
I have a drop-down box on my form. To populate it, I use the foreach() commnd, like so:
Code: Select all
//connected to db earlier...
$sql = "SELECT title FROM news";
$result = mysql_query ($sql, $db);
echo "<FORM ACTION="newsprocess.php" method=POST>";
echo "<select name="title">";
while ($row=mysql_fetch_assoc($result))
{
foreach ($row as $key=>$val) {
echo "<option value="$key=$val">$val</option>"; }}
echo "</select>";
echo "<br>";
echo "<INPUT TYPE=SUBMIT name=delete>";
echo "</FORM>";Code: Select all
$sql="DELETE FROM news WHERE title='$val'";
$result=mysql_query ($sql, $db);
echo "Deleted! <br>";
echo "Please wait one second...";
echo $sql;
$sql="";
$result="";Thanks!