[Resolved] how to delete multiple records using checkboxes

rikmoncur

Hello, this is my first post here, I hope someone can help...
I found the following snippet (after searching for days!) which I managed to get working successfully on one server.
Using a dynamically generated checkbox list, I can delete multiple records from my database.
Although, in the code, there seems to be an exta bit ( the $del= ) - the code still works if that's removed so it's just mysql_query($sql,$dbh);

This is the snippet:

Use this for your checkboxes
<input type="Checkbox" name="deleterecord[]" value="$id">
the [] specifies it to be an array.

Process as follows:

while (list($k,$v) = each($deleterecord)) {
	$sql="delete from table WHERE id=$v";
	$del=mysql_query($sql,$dbh);
}

The problem is, when I tried the same code on another server, it doesn't work! The tech support suggested using global variable (I think I understand that?) but it still doesn't work.
Any suggestions or pointers would be most helpful.

thorpe

try changing this line to;

while (list($k,$v) = each($_GET['deleterecord']))

rikmoncur

Thanx - that's one of the million variations I tried until 3 in the morning when I started to go cross-eyed!

What's perplexing is that the array is getting parsed ok.
To check, I can echo the keys and values to the page.
It seems to get as far as:

$sql="delete from table WHERE id=$v";

then it quietly stops.
I wonder if there's a bit of sql error reporting code I could add there to see what's happening?

I've got another script to delete just one record from the db and it works ok, I had wondered if there was some kind of permissions setting or table locking going on?

thorpe

put this in your script and lets see if we can get an error happening.

$del=mysql_query($sql,$dbh) or die(mysql_error());

maybe even turn error reporting up. put this at the top of your script.

error_reporting = E_ALL;

rikmoncur

After a quick check at php.net I used error_reporting (E_ALL);
but it's not trapping any errors. Thanx for the tip tho!

The or die(mysql_error() I had used before but it's just giving me: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.

Only there isn't a " on line one, there's just the require_once('Connections/meno.php'); that Dreamweaver (gotta start somewhere...) uses.

I keep telling myself this is fun!

UPDATE: now I'm getting 'No Database Selected' aha! Something's happening. It's after 6.00pm here so I suspect my ISP's tech support has gone home, unless someone's working late and fiddling with something on the server.

At least something's changing - being faced with a blank look from IE is no way to spend an evening.

SUCCESS!!! WOOHOO!

Thanx thorpe, your error code did help a bit!
On one server it was only necessary to put delete from table but on my other server it had to be delete from database.table
that's why I got the error 'No Database Selected'.

Don't ya just luv it? 😕