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,

If are wanting to delete a row from the name given in the form you can do the following in your SQL

Where $_POST['name'] is the input field in your form.
If the user inputs a name that the db cannot find it will not delete any thing.