multiple sql

Anon

I have generated a list of tick boxes from the database to show accounts that aren't authorised yet.

When I run the sql query:

$numrows =count($authorised);

for ($x=0;$x<$numrows;$x++){
$sql = "update users set authorised='$authorised[$x]' where ID= '$ID[$x]'";
$result = mysql_query($sql);

}

Say I pass two items to the query, this is what the sql does:
update users set authorised='' where ID= ''
update users set authorised='1' where ID= '2'

As you can see the first one is blank. Any suggestions?

Anon

Looks like element 0 of $authorized is empty.
How did you generate the $authorized var?

Anon

It is passed over from the form:

++$x;
echo "<input type=\"hidden\" name=\"ID[$x]\" value=\"" . $auth["ID"] . "\">\n";

echo "<TD><input type=\"checkbox\" name=\"authorised[$x]\" value=\"1\"></TD>\n";

The var is giving each one a number (HTML GENERATED BELOW)

Anon

So you start with authorized[1] and you wonder why authorized[0] is empty?

Anon

OK well when I set it to 1, it only passes one result over.

bearing in mind im fairly new to all this, could you pass a bit of help on correctly getting the array working?

Anon

An array's first element is element [0].

You are probably filling your array beginning with element [1] somewhere in your program and then...

You are trying to read the array, but you are starting with element [0] which you never put any data into.

Not a great explanation but I hope it helps.

Happy Coding. 🙂