The trick here is to use the right HTML field name and PHP syntax to receive
the information.  For your checkboxes in HTML, name them like this:

<input type="checkbox" name="del[]" value="1">Favorite 1</input>
<input type="checkbox" name="del[]" value="2">Favorite 2</input>


Then, in your PHP code, first check to see if there is more than one value:

if (is_array($_POST["del"]))
{ // works only if id is all integers.
  $in_list = implode(", ", $_POST["del"]);
  $query = "delete from table where id in ($in_list)";
} else
  $query = "delete from table where id = {$_POST['del']}";

That should work, no javascript necessary.

  -- Rob



"John Dillon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
m...
I want to create a page where the user will have a list of its favorites and
by ticking a box opposite the item will be able to delete it by clicking the
submit button.  I want to make this dynamic so that the php works out the
one to delete based on the value of the tickbox (I'm thinking), having first

- done a query to retrieve the favorites of the user
- listed the favorites on the browser and set the tick boxes with a value
corresponding to the ID of the favorite...thus knowing which one to delete.

I was wondering what's the best approach - the one above or to mix in some
javascript?  Any examples out there?  I know it's a popular idea.  Maybe
there's a better approach than tickboxes.

John




http://www.cantor.com
CONFIDENTIAL: This e-mail, including its contents and attachments, if any,
are confidential. If you are not the named recipient please notify the
sender and immediately delete it. You may not disseminate, distribute, or
forward this e-mail message or disclose its contents to anybody else.
Copyright and any other intellectual property rights in its contents are the
sole property of Cantor Fitzgerald.
     E-mail transmission cannot be guaranteed to be secure or error-free.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message which arise as a result of e-mail
transmission.  If verification is required please request a hard-copy
version.
     Although we routinely screen for viruses, addressees should check this
e-mail and any attachments for viruses. We make no representation or
warranty as to the absence of viruses in this e-mail or any attachments.
Please note that to ensure regulatory compliance and for the protection of
our customers and business, we may monitor and read e-mails sent to and from
our server(s).

For further important information, please read the  Important Legal
Information and Legal Statement at
http://www.cantor.com/legal_information.html



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to