hey guys, im new to this php and my sql stuff..i need help here.. i can delete/update stuff from the from into the database..but it is only for a specific name..but what i want is to delete/update stuff for any given name...this are the codes..thanks...

:::::THIS IS MY FORM:::::

<form action="delete.php" method="post">
Name: <input type="text" name="name"/>
Age: <input type="text" name="age" />
Hp : <input type="text" name="handphone" />
Email : <input type="text" name="email" />
Admin : <input type="text" name="admin" />
<input type='submit' name='remove' value='Delete' />
</form>
</body>
</html>


:::::THIS IS MY PHP CODES:::::

<?php

$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("studentreg", $con);

mysql_query ( "DELETE FROM particulars WHERE name='sam' ");
echo "name deleted!!";
mysql_close($con)

?>

hi,
i didn't understand your requirment properlly, anyway check following code may help you

$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("studentreg", $con);
$name=$_REQUEST["name"];
mysql_query ( "DELETE FROM particulars WHERE name='$name' ");
echo "name deleted!!";
mysql_close($con)

__________________
surendran
(Anything is Possible)
http://www.suren.info
http://ssuren.spaces.msn.com