Checkboxes check based on database record

[phprock]

I don't why this code does not work for me..

$user=2;

$result=mysql_query("SELECT user_test FROM user_test WHERE user='$user'",$bd);

$mytest=mysql_fetch_array($result);

$result2=mysql_query("SELECT  * From   test ",$db);

while($row=@mysql_fetch_array($result2)){

if(in_array($row[test_id],$mytest)){
$sel="checked";
}else{
$sel="";
}
echo"<input type=checkbox name=mtest[] value=$row[test_id] 
 $sel>$row[test_name]
}

[olaf]

Hallo,

i test the value of a checkbox like this:

<input type="checkbox" value="yes"<?php if ($row['value'] == "yes") { echo " selected"; } ?>>

[sidney]

whole($row=@mysql_fetch_array($result2)){

shouldnt that be

while

[phprock]

SOrry it was typo mistake..

But sitll does not work.. it chcecked every things..

[sidney]

can you post the errors your getting

[phprock]

There is no error.
It does not do what it suppose to do..

$mytest return 1,3,5

It should check only these fields(1,3,5) not others..

not it checked every fields..

[sidney]

error_reporting(E_ALL);

add the above to debug script it will report all errors and warnings
remove when finished script

try somthing more like below ive used different field names so you will have to edit it

 $user=4;
require_once("connect.php");
$result=mysql_query("SELECT test2 FROM test WHERE id='$user'");
while($test=mysql_fetch_array($result)){
$mytest[]=$test[test2];
}
$result2=mysql_query("SELECT  * From   test ");
while($row=@mysql_fetch_array($result2))
{
if(in_array($row[id],$mytest)){
$sel="checked";
}else{
$sel="";
}
echo"<input type=checkbox name=mtest[] value=$row[id] 
 $sel>$row[name]<br>";

}
?>

[bubblenut]

I think a little debuging code might help here 😉 try putting a couple of print_rs about like in the code below.

$user=2;

$result=mysql_query("SELECT user_test FROM user_test WHERE user='$user'",$bd);

$mytest=mysql_fetch_array($result);
echo("==>tag1: <br />\n");
print_r($mytest);

$result2=mysql_query("SELECT  * From   test ",$db);

while($row=@mysql_fetch_array($result2)){
  echo("<br />\n==>tag2: <br />\n");
  print_r($row);

if(in_array($row[test_id],$mytest)){
$sel="checked";
}else{
$sel="";
}
echo"<input type=checkbox name=mtest[] value=$row[test_id] 
 $sel>$row[test_name]
}

I think it might be more helpfull for you to look at the results and see where it's going wrong yourself. If however I've got things wrong and this doesn't help at all then go on the members page and pick someone to slap 😉
HTH
Bubble

[phprock]

Thanks.. it works now

once i changed

$mytest=mysql_fetch_array($result);

to
while($row=mysql_fetch_array($result)){
$mytest[]=$row["user_test"];
}

But why ..it the first one does not work..

Both are array   isn't it  ?

[olaf]

$result2 does not exist...