从数据库中删除选定的行

Question

I would like to delete a row from mysql database. The row I would like to delete is the 'selected item' in the combobox.

My code so far:

    $sql = "SELECT data_id FROM projects";
    $result = mysql_query($sql);

    echo "<select name='data_id '>";
    echo "<option selected>Please select...</option>";
    while ($row = mysql_fetch_array($result)) 
    {
        echo "<option value='" . $row['data_id '] . "'>" . $row['data_id'] . "</option>";
    }
    echo "</select>";

    ?>
    <tr><td><input type="submit" name="delete" value="Delete" id="delete"></td></tr></tr></table>
    <?php
     //delete selected item from projects table...
    ?>

The combobox is showing all the items from my projects table. When I select an item, then click on 'delete' I would like to delete that item from the table.

Any help will be appreciated.

Answer 1

Your logic should be:

At top of script before html, check for POST values from form if they exist, use the variables to delete the appropriate database value use header('location') back to the same page to reload the page (so value is removed from form below)

where you have your select box, make that a form, action= same page, method = post

tomorrow I will post example code if you have not worked it out by then