check database and delete

Hello
i have a text box and a button on my webpage and want to get the text box to find the username i type into it from the database and when it does it will then go to thankyounumber and delete any text that is under the thankyounumber field as you can see i have no idea how.

[php]<?php
include(“config.php”);
$username1 = $_GET[“username”];
$newnumber = $_GET[“thankyounumber”];
$newnumber = “”;
$query = "UPDATE ".$DBprefix.“signup SET thankyounumber=’$newnumber’ where username=’$username1’”;
$result = mysql_query($query);
?>

New Page 1 [/php]
Sponsor our Newsletter | Privacy Policy | Terms of Service