[thelist] MySQL/PHP deleting a record w/radio buttons

Martin Kuplens-Ewart martin at takingitglobal.org
Fri Feb 28 10:45:22 CST 2003


>I have a simple MySQL database, with 4 fields;
>$idnum
>$title
>$poem
>$pubdate
>
>I'd like to be able to show idnum, title, and pubdate, (along
>with a radio
>button) for all poems in the database.
>
>The user will select a radio button for appropriate peom, then
>simply hit a 'delete' button, which of course will delete it
>from the database.


>So, can anyone point me to any tutorials/scripts/tips/etc that
>might help?

<input type="radio" name="idnum" value="<?=$myarray[idnum]?>">

Submit your form.... Then

mysql_query("DELETE FROM $db.$table WHERE idnum = '$idnum'");

Then you can do a textbook

header("Location: /original/listing.html");





More information about the thelist mailing list