At 22:37 -0400 7/1/02, Matt Nigh wrote:
>hi, i'm trying to delete multiple records at once from a mysql db and can't
>seem to figure out how to do so.
>here's the code i've been trying to troubleshoot with:
>
>$result_insert = mysql_query("delete from $mysql_table where id = '8' AND
>where id = '18'");
Advertising
I assume that this never deletes any records, since no record can
have an id column whose value is 8 and 18 at the same time? :--)
Don't you mean "OR"?
>
>
>i've tried various things such as taking away the single quotes, replacing
>AND with a comma, etc.
>after i figure out how to delete multiple records, i need to figure out how
>to go about carrying data from checkboxes and finding a query to delete the
>records that were checked on the previous page:
>
>ex.
><input type=checkbox name=id value=1>
><input type=checkbox name=id value=2>
><input type=checkbox name=id value=3>
>etc.
>
>
>any help would be appreciated.
>
>thanks very much,
>
>
>Matt
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
