Thank you so much for your reply
this is really helpful
On 1/26/10, shadow <shadow3dcaster@xxxxxxxxxxx> wrote:
>
>
>
>
>
> Hello Vichea,
>
> In your HTML you should have form fields with names indicating that they
> are an array by using square brackets [] after the name - something like
> this:
>
> <form method="get" action="<?php echo $_SERVER['PHP_SELF']; ?>">
> <input type="checkbox" name="id[]" value="a" /> a
> <input type="checkbox" name="id[]" value="b" /> b
> <input type="checkbox" name="id[]" value="c" /> c
> <input type="checkbox" name="id[]" value="d" /> d
> <input type="submit" name="submit" />
> </form>
>
> When the submit button is clicked it creates a URI query string something
> like this:
>
> /path/to/page.php?id[]=a&id[]=b&id[]=c&submit=Submit+Query
>
> Then in your PHP script you can treat $_GET['id'] as an array with such
> constructs as 'foreach' and the various array functions. But if you want to
> run the delete SQL command try something like this (remembering to eradicate
> SQL injection, empty arrays and non-array objects first):
>
> $ids = substr(implode(',', $_GET['id']), 0, -1);
> $query = mysql_query("DELETE FROM table_name WHERE id IN ($ids)") or
> die(mysql_error());
>
> That should do it. I hope this helps.
>
> -- Shadow Caster
>
> --- In php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>,
> Sovichea SOU <svch_sou@...> wrote:
> >
> > Hi,
> >
> > I want to delete multi records where id=5653, 56581,and 56587.
> >
> >
> http://localhost/news/index.php?cID=56534&cID=56581&cID=56587&submit=Verify
> >
> > how to split cID from the url?
> > how to delete those records?
> >
> >
> > Many thanks
> >
> > Vichea
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
--
Thanks & Regards
Vijayalakshmi
[Non-text portions of this message have been removed]
