looking for simple delete record from db

[dougvcd]

looking for a simple script
that you login with email addy and shows your record then press button to delete record
cheers
Doug

[Tim Mousel]

This works great:
http://www.phpmyadmin.net/home_page/index.php

[dougvcd]

sorry i didnt make myself to clear
when peeps re on my site the details go in database so if they want to delete there details
they login with email addy then delete there details
hope this makes it a bit clearer
cheers
Doug
this is what i have so far
they login and get sent to this page

<?php



include("connectdb.php"); 



$rResult = mysql_query( 

   sprintf(        

   "SELECT * FROM register WHERE email = '%s' LIMIT 1",        

   mysql_real_escape_string($_POST['myemail'])    

   )

   );

   if(1 !== mysql_num_rows($rResult))

   {    

   header('Location: http://www.lostpetsplymouth.com/wrong.php');    

   exit;

   }



$aRecord = mysql_fetch_assoc($rResult);

 printf(    

   '

    

    <strong>Type:</strong>%s<br />    

    <strong>State:</strong>%s<br />    

    <strong>Area:</strong>%s<br />    

    <strong>Description:</strong>%s<br />        

     <strong>ID:</strong>%s<br /> 

    '

    ,

    $aRecord['type'],    

    $aRecord['state'],    

    $aRecord['area'],    

    $aRecord['desc'],        

    $aRecord['ID']

    

 );





?>

<p> This is your Record Details if you want to Delete press here<p>

</body>