Hi
I've been playing about with php and mysql for about a week now I have a small database that's holding name's and phone numbers and I have a basic php Html interface that allows me to add and search records Works well and fast!
Problem is building a form that deletes records. Currently I get a successful report message ie No 1234 has been deleted put the record remains in the database.
I'm missing something simple I'm sure !
Code as follows...
Other thoughts are is this a permissions thing? Is it an issue with the way I start Mysqld ?
Thanks
Steve Abrahall
_______Html Code for remove.html
<body>
<form action=remove.php method=post>
<br>Use this form to remove records|<br> <Br>
<p>
Use Ph No as Ref
<p>
Phone: <input type=text name="phone" size=25 maxlength=25>
<br>
<input type="Submit" name="Delete" value="Delete Record">
<br> <br>
</form>
</body>
_____Php code for file remove.php
<?php
mysql_connect (localhost,bob,1234);
mysql_select_db (test);
mysql_query ("Delete FROM people where phone='$phone';
VALUES ('$phone')
");
print ($phone);
print ("<b>");
print ("Removed From Database we hope!.....");
?>
