PHP MySQL Alter and Delete Script
Posted 09 September 2006 - 01:40 PM
I'm newbie programmer in php. I'm working with a Purchasing System using a php and MySQL. I have created a delete script in a said System but it could only delete 1 record...Please give some suggestions or ideas on How do I delete a record one by one and give some scripts in altering a record..tnx a lot..
Posted 10 September 2006 - 09:50 AM
You state that you have been able to delete a record. So you know how to do this. Just repeat it (with a different WHERE clause of course) for the other records you want to delete.
About altering: you can ALTER a database or ALTER a table, but what do you mean by ALTERing a row?
Posted 10 September 2006 - 02:52 PM
Item Qty Delete
Widget 25 (x)
Wotsit 1 ( )
Gizmo 10 (x)
Define each c/box with a name ending with "" and with a value = the id of the listed item
echo "<input type='checkbox' name='delitem' value='$id'>";
When the form is submitted you want to create a query like
DELETE FROM item WHERE id IN (1,3)
which will delete the 2 items shown above.
<?php $items = join (',' , $_POST['delitem']); mysql_query ("DELETE FROM item WHERE id IN ($items)"); echo "Selected items deleted"; ?>
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users