Hi all,

I'm searching names from MySQL and printing it on a browser. Also, I've
provided checkbox for all the rows and a delete button for a page. I want to
delete the selected rows from MySQL when I click on the "Delete" button. How
do I do that?

Here is the code which I used to print the rows after fetching the same from
MySQL

while ($line = mysql_fetch_array($resultset, MYSQL_ASSOC)) {
echo "\t<tr>\n";
echo "<td><input type=checkbox name=index /></ td>";
foreach ($line as $col_value) {
echo "\t\t<td>&nbsp;$col_value</td>\n";
}
//echo "<td><input type=button name=vcancel value=Cancel /></td>";
echo "\t</tr>\n";
}

Balasubramanyam A wrote:

> Hi all,
>
> I'm searching names from MySQL and printing it on a browser. Also,
> I've provided checkbox for all the rows and a delete button for a
> page. I want to delete the selected rows from MySQL when I click on
> the "Delete" button. How do I do that?

You process the form that is (presumably) submitted when the user
hits "Delete". In your processing you collect the row-ids or something
else you can use in the <whereclause> : "DELETE FROM table WHERE
<whereclause>".


/Per Jessen, Zürich

On Jan 5, 2008 9:03 AM, Balasubramanyam A <knowledge.wealth@gmail.com> wrote:
> Hi all,

Hi!

[snip]

> while ($line = mysql_fetch_array($resultset, MYSQL_ASSOC)) {
[snip]

Just a side note: wouldn't it be easier to just use
mysql_fetch_assoc() ? It does the exact same thing, with less typing.


--
Daniel P. Brown
[Phone Numbers Go Here!]
[They're Hidden From View!]

If at first you don't succeed, stick to what you know best so that you
can make enough money to pay someone else to do it for you.

Balasubramanyam A wrote:
> Hi all,
>
> I'm searching names from MySQL and printing it on a browser. Also, I've
> provided checkbox for all the rows and a delete button for a page. I want to
> delete the selected rows from MySQL when I click on the "Delete" button. How
> do I do that?
>
> Here is the code which I used to print the rows after fetching the same from
> MySQL
>
> while ($line = mysql_fetch_array($resultset, MYSQL_ASSOC)) {
> echo "\t<tr>\n";
> echo "<td><input type=checkbox name=index /></ td>";

In the above line you need to have the row ID as the value of your check
box. Also, you should probably use and array in your form. See below
for example and explanation.

echo "<td><input type=checkbox name=delete[] value={$line['id']} /></ td>";


Ok, broken down...

nothing special about this, pretty standard
echo "<td><input type=checkbox

This, when submitted to PHP, will create an array in the POST/GET array
name=delete[]

This will assign the value of ID to the checkbox array
value={$line['id']}

etc...

Now, this is assuming that your id column is called ID and that you will
be wanting to delete more then one at a time.

on the process page, do a print_r($_POST)

You will see what you get

> foreach ($line as $col_value) {
> echo "\t\t<td>&nbsp;$col_value</td>\n";
> }
> //echo "<td><input type=button name=vcancel value=Cancel /></td>";
> echo "\t</tr>\n";
> }
>