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!