Help With editting and deleting form

Posted on 16th Feb 2014 07:03 pm by admin

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.png
This table prints the titles of entries from a table in a database.. The code that i use for this table is this :
Code: <!--Table For Deleting and Updating -->





<p align="center"><font color="#1569C7">DeleteOrEdit(</font><font color="red">Security Projects & Thoughts Section</font><font color="#1569C7">);</font></p>

<table align="center" border="2" bordercolor="green" cellspacing="0">

<!--First row with title delete and edit-->
<tr>
<td><font color="#F87217">Title:</td>
<td><font color="#F87217">Delete();</font></td>
<td><font color="#F87217">Edit();</font></td>
</tr>

<?php

$query = 'SELECT title FROM site_entries ORDER BY date_entered DESC';

if ($r = mysql_query($query)){

while ($row = mysql_fetch_array($r)){
print "<tr>
<td><font color="#8BB381">{$row['title']}</td>
<td><form method="post" name="sub_del"><input type="submit" value="Delete();"></form></td>
<td><form method="post" name="sub_edt"><input type="submit" value="Edit();"></form></td>
</tr> ";

}
}else{
die('<p>Could not retrive the data brcause:<b>' . mysql_error .'</b> The query was $query.</p>');

}


mysql_close();


?>

</table>
Its simple...till here...

Now i stack on how to make the script that will delete the registers of the database...I can think something with id column but i can't make it true...:s I want you to help me giving me ideas on how to make this or any other idea on how to create an delete/edit page...If you think that i start it with a wrong way please tell me

The table name is site_entries and its columns are id , title , entry , date_entered

Thanks in advance..!!

Your Answer:

Login to answer

Other forums

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Thought I has this figured out especially after all the help i received?
Cags, Salathe, Daniel helped me with this yesterday, but not sure i took it all in.
I am attempti

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

WM transfer order: confirm different batch than proposed by system
Hi folks,

following scenario: we have a full WM with mixed batch numbers allowed in stora

How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and