[RESOLVED] CVheckbox problem

[spire_bt]

Hi to all ...
I have a problem with this code

include_once ("/var/www/db_details.php");

$connection = mysql_connect ( $host, $user, $password ) or die ( 'Error connecting' . mysql_error () );
mysql_select_db ( $database, $connection ) or die ( "Error conecting to database" );


$query = mysql_query ( "SELECT email,id FROM o2o_testusers" );


while ( $row = mysql_fetch_array ( $query ) ) {


	echo $row[email];

if (isset ( $_REQUEST ['dk'] )) {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `dk` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}else {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `dk` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}
if (isset ( $_REQUEST ['se'] )) {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `se` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}else {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `se` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}
if (isset ( $_REQUEST ['uk'] )) {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `uk` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}else {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `uk` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}
if (isset ( $_REQUEST ['es'] )) {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `es` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}else {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `es` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}
if (isset ( $_REQUEST ['de'] )) {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `de` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}else {
	$query = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `de` = '0' WHERE `o2o_testusers`.`id` = $row[id]") ;
	}

when i start this it only lists one user from the DB not all

have any sugestions

p.s. if need i will send the rest of the code

[djjjozsi]

Hello,
This problem is some kind of an overwrite!

Inside the while loop, use another variable to store the UPDATE $query's.

And change your coding technique:
replace

$_REQUEST ['es']

into: (if your'e using a form with POST )

$_POST['es']

And in this line email is an undefined index, use ' (apostrofe)

echo $row[email]; 

Hello, jjozsi.

[spire_bt]

didn't got your answer quite good
you want me to store the UPDATE query in variable instead of putting it i a WHILE

how will then be executed for all the users that I am printing with $row[email]

by the way

echo$row[email]

don't need apostrophes it prints like it shroud

thx for your reply I appreciate it no matter is it helpful or not 😉

[Weedpacket]

spire_bt wrote:

don't need apostrophes it prints like it shroud

It's still wrong; see here for details: you're generating errors and potentially introducing bugs just for the sake of saving two keystrokes.

[djjjozsi]

<?php
	$query = mysql_query ( "SELECT email,id FROM o2o_testusers" );

while ( $row = mysql_fetch_array ( $query ) ) {


	echo $row[email];
	$query2 = mysql_query("UPDATE `martin_server`.`o2o_testusers` SET `dk` = '1' WHERE `o2o_testusers`.`id` = $row[id]") ;
	

IF YOU USE $query FOR THE MYSQL link,
in the while loop
you overwrite the main $query value!
I've just suggested that use another variable name for the UPDATE variables.

		}
?>