hi, this is the beginning of my php lesson and i might need some guide here

I have created a simple MySQL database, with fields;
$idnum
$name
$address
$date

I'd like to be able to show idnum, title, and pubdate, (along with a radio
button) for all record in the database into a table.

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.

currently i am having a hard time with what I need to DO them.
Anyone who can help?

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

Thanks

for the first part
http://www.php-mysql-tutorial.com/php-mysql-select.php

but i still blur with it could you give a more specific example?
thanks

using that one you can list all the rows from a mysql table into a html table .
after you have done that ... you can go forward and make the second part ... the delete one...

one step at a time,

plus this a place to learn and not to get full scripts for you're aplications

something like this

PHP Code:

<?
mysql_connect("host","username","password");
mysql_select_db("dbname");
if (isset($_POST["delete"])) {
    mysql_query ("delete from atable where idnum = ".$_POST["idnum"]);
    
} else {
$res=mysql_query("SELECT * FROM atable");
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
while ($rec=mysql_fetch_array($res)) {
 echo "<input type='radio' name = 'idnum' value='".$rec["idnum"]."'> ".$rec["idnum"]." ".$rec["name"]." ".$rec["address"].$rec["date"]."<br />";    
}
echo "<input type = 'submit' name='delete' value='delete'>";
echo "</form>";

}
mysql_close();       
?>