Delete/Updating Records.

cmasters

Ok, I know what I need to do for this, but am having problems writing the code, as in, I don't knwo quite where to begin. I need to be able to pull up a table of records(this part I can do) and choose to either update or delete each record from the table. here is the code I have thsu far:
(i know its a mess...)
Essentially when i click submit

if ($row = mysql_fetch_array($result))
{
echo("<form method=POST action='$PHP_SELF'>");
print("<table border=1><tr><th>Admin Option</th><th>Week</th><th>Gender</th><th>Camper
Last</th><th>Camper First</th><th>Parent First</th><th>Parent
Last</th><th>Address</th><th>Apart/Suit</th><th>City</th><th>State</th><th>Zip</th><th>Church</th><th>Email</th><th>CC
Name</th><th>CC Lastname</th><th>CC Type</th><th>Expire Date</th><th>CC
Number</th><th>Price</th></tr>");
do
{
print("<tr><td>");
echo("<select>
<option></option>
<option>Delete</option>
<option>Edit</option>
</select>");
print("</td><td>");
print $row["week"];
print("</td><td>");
print $row["gender"];
print ("</td><td>");
print $row["camperlast"];
print("</td><td>");
print $row["camperfirst"];
print("</td><td>");
print $row["parentfirst"];
print("</td><td>");
print $row["parentlast"];
print("</td><td>");
print $row["address"];
print("</td><td>");
print $row["apartment"];
print("</td><td>");
print $row["city"];
print("</td><td>");
print $row["state"];
print("</td><td>");
print $row["zip"];
print("</td><td>");
print $row["church"];
print("</td><td>");
print $row["email"];
print("</td><td>");
print $row["firstname"];
print("</td><td>");
print $row["lastname"];
print("</td><td>");
print $row["cardtype"];
print("</td><td>");
print $row["expiredate"];
print("</td><td>");
print $row["ccnumber"];
print("</td><td>");
include("price.php");
print $total;
}
while($row = mysql_fetch_array($result));
print("</td></tr></table>");
echo("<br><input type=submit name=submit value=Submit>");
}
else
{
print ("Sorry, no records were found");
}

[deleted]

Well, you will need a way to identify which item was clicked, and you'll need to know wether that item was clicked for 'delete' or 'update'.

If you want to delete/update each item seperately, you'll have to create a seperate HTML form for each item. Put a seperate FORM tag in the table for each item.
The form can contain two submit buttons with different names, and a text-field.
Most importantly it must contain a hidden field that contains the item's ID in the database.
When this form is submitted, you can look for the two buttons to find which was pressed, and you can process the record accordingly.

ezekiel

Like vincent said, it depends on what you really want to do.

I created something similar, it may seem a little redundant but it has its advantages as well:

1) Dynamically populate a table with db info. Each table row was a brief summary of the db entry.

2) Next to each row was an image submit button or link that passed the record id to a review page. If you use a button, like vincent said, each row must be its own form. If you use link you can code something like: <a href='review.php?record_id=$record_id> <img src='blah.gif'> </a>, this would pass your var to the next page.

3) The review page showed the all info regarding that entry (done thru a query like you did, kinda).

4) I provided a edit button that again passed the record id to another page (edit page). Also a delete option, which set off onto another series of fail-safes and such.

5) This edit page pulled all the data reqarding record into form fields where they could be edited.

6) After clicking submit, the new variables are passed to a review page to make sure these where the values I wanted to update BEFORE committing the changes to the database.

7) Finally, after committing the updates, a redirect back to the main listing.

I hope this was helpful.