ok it's like this:
my code is getting everyone from DB giving them check boxes and writes the result in the DB only problem is that the result for one person is same for every user
<?php
$query = mysql_query ( "SELECT email,id FROM o2o_testusers" );
while ($row = mysql_fetch_array ( $query )){
//$Q = $row[email].",";
//foreach ($Q as $email){
//for ($i = 0; $i< sizeof($row);$i++){
if (isset ( $_REQUEST ['dk'] )) {
$query1 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `dk` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
}else {
$query1 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `dk` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
}
if (isset ( $_REQUEST ['se'] )) {
$query2 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `se` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
}else {
$query2 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `se` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
}
if (isset ( $_REQUEST ['uk'] )) {
$query3 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `uk` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
}else {
$query3 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `uk` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
}
if (isset ( $_REQUEST ['es'] )) {
$query4 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `es` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
}else {
$query4 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `es` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
}
if (isset ( $_REQUEST ['de'] )) {
$query5 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `de` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
}else {
$query5 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `de` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
}
$checked = "checked";
$unchecked = "";
$query_dk = mysql_query("SELECT dk FROM `o2o_testusers` WHERE `o2o_testusers`.`id` = $row[id]");
$row_dk = mysql_fetch_array ( $query_dk );
if ($row_dk[0] == 1){
$y_dk= $checked;
}else {
$y_dk = $unchecked;
}
$query_se = mysql_query("SELECT se FROM `o2o_testusers` WHERE `o2o_testusers`.`id` = $row[id]");
$row_se = mysql_fetch_array ( $query_se );
if ($row_se[0] == 1){
$y_se = $checked;
}else {
$y_se = $unchecked;
}
$query_uk = mysql_query("SELECT uk FROM `o2o_testusers` WHERE `o2o_testusers`.`id` = $row[id]");
$row_uk = mysql_fetch_array ( $query_uk );
if ($row_uk[0] == 1){
$y_uk = $checked;
}else {
$y_uk = $unchecked;
}
$query_es = mysql_query("SELECT es FROM `o2o_testusers` WHERE `o2o_testusers`.`id` = $row[id]");
$row_es = mysql_fetch_array ( $query_es );
if ($row_es[0] == 1){
$y_es = $checked;
}else {
$y_es = $unchecked;
}
$query_de = mysql_query("SELECT de FROM `o2o_testusers` WHERE `o2o_testusers`.`id` = $row[id]");
$row_de = mysql_fetch_array ( $query_de );
if ($row_de[0] == 1){
$y_de = $checked;
}else {
$y_de = $unchecked;
}
?>
<table width="60%" height="10" cellspacing="0" align="center">
<tr onMouseOver="background-color:#99CCFF"
OnMouseOut="this.className=''"
style="font-family: Arial, Helvetica, sans-serif; font-size: 18; color: grey">
<td align="left" width="40%" height="10"><?=$row [0];?></td>
<td align="right">
<input type="checkbox" align="right" name="dk" value="dk" <?echo $y_dk;?>>DK
<input type="checkbox" align="right" name="se" value="se" <?echo $y_se;?>>SE
<input type="checkbox" align="right" name="uk" value="uk" <?echo $y_uk;?>>UK
<input type="checkbox" align="right" name="es" value="es" <?echo $y_es;?>>ES
<input type="checkbox" align="right" name="de" value="de" <?echo $y_de;?>>DE
</td>
<td align="right" width="20%"><a
href="insert_leads.php?mail_mode=delete&id=<?=$row [1]?>"
title="remove"
onclick="return confirm('Are you sure? Do you want to delete it?')">remove</a>
</td>
</tr>
</table>
<?php
}
//}
?>
tried with "foreach and for" but i am out of ideas
