check box's and arrays

ghornet

Hello I have been working on this problem all day and am now throwing in the towel and giving a general distress call out to all you killer php coders

I have an array of check boxs

echo "<tr><td width=50%><font face=verdana size=2>" . $info->fname. " " . $info->lname . " </td><td width=50%><font face=verdana size=2><input type=checkbox name=name[] value=$info->username</td><td><a href=mailto:" . $info->email .">" .$info->email . "</a></td></tr>";

I have a text box with the variable $personal.

I would like to insert into the personal row of the students table the variable $personal only to the students with check boxs next to them

Any help? do I need to be more clear? thank you very much

Anon

you can set a variable like $checked which can take two possible values.
yes or no.
in the later page if checked is yes do that...

now you have more than one checkboxes.
So you have to set a variable like that
$checked$i which can be checked1, checked2,...

in the later page...
for ($i=0; $i<$%that; i++) {
check if it is yes...
}

Anon

the array will only contain the selected checkboxes so just do:

for ($i=0;$i<count($name);$i++)
{
//arrays in queries don't work dunno y
$name = $name[$i];
update students set peronal='$personal' where username='$name'
}

This will only do the selected values as simple as that.

ghornet

So I put this is to my code and it still does not work, the value $c is not incrementing, when I print out $name[1] it will print out the correct name and if I comment out the line echo $name = $name[$c]; $c will then increment. What is up with that (:

if(!empty($name))
{
for ($c=0;$c<count($name);$c++)
{

echo $c;
echo $name = $name[$c];

$sql = "update students set personal='$personal' where username='$name'";
echo $sql;
$update = mysql_query("$sql",$db);
}
}

Anon

The only thing I see that is wrong is the following line:

$update = mysql_query("$sql",$db);

it should be:
$update = mysql_query($sql,$db);

And also $db should be the link identifier.
(It looks like a database name var, could be wrong🙂)
By the way usually this is not nessesary. If you don't specify the link identifier it will use the last opened connection.
I suggest you use pconnect but i'm drifiting here. 🙂

The update is probably failing here.

The rest of the code looks ok. So if it's still not working show me the form and the code and i c if i can help.

Greetings