why doesn't this work ?

Anon

on my first page i have a script that generates checkboxes with the info from a table(db), every row gets one checkbox. Every row also has an unique id(0,1,2,3,...) and this relates to the name of the checkbox

example :

if that box is checked that row 1 should be deleted.

I did this :

$sql = " SELECT max(id) AS top FROM gastenboek " ;
$output = mysql_query($sql) ;
$high = mysql_fetch_array($output) ;

$kwerie = " DELETE FROM gastenboek WHERE id='x' " ;
for($i=0;$i<=$high[top];$i++){
if($check[$i]=="on"){
$kwerie=$kwerie . "AND id='$i'" ;
$del = "1" ;

mysql_query($kwerie) or die("error ici") ;

}

but it doesn't work =(
its like the $check[1] isn't the same as check[$i] when $i=1
according to me thats strange

can anyone help ?

thx

cvincent

Insert this into the top of your code:

print("<pre>");
print_r($check);
// if the form method=post
print_r($HTTP_POST_VARS);
// if the form method=get
print_r($HTTP_GET_VARS);
print("</pre>");

just to see if you are getting your input correctly. Also, you might want to change the if statement to if(isset($check[$i])) and see if that works.

-Chris

Anon

i've changed the if statement, no change =(
could it be that my script sees the $check[1] from my input as a var. with the name $check[1] instead of the array with the name $check and index [1] ?

cvincent

if you look at these lines:

$kwerie = " DELETE FROM gastenboek WHERE id='x' " ;
$kwerie=$kwerie . "AND id='$i'" ;

you will notice that if there is more than 1 checkbox, the query will look like

"DELETE FROM gastenboek WHERE id='x' AND id='1'AND id='2'AND id='3'"

The actual query syntax is wrong. There is no space before the AND. You need to make that happen. If you insert the spaces, I still dont think it will work because it checks row by row: what I mean is its going to check one row and will only delete that row if the id of that row equals x,1,2, and 3 at the same time...which will never happen. I suggest you execute one query for each id to be deleted.