<?
mysql_connect('sql.free.fr','*****','7*******');
mysql_select_db('******');
$init = mysql_query("DELETE FROM a_ban_active");
$init2 = mysql_query("ALTER TABLE a_ban_active AUTO_INCREMENT=0");
$active = mysql_query("SELECT ban_id, user_id FROM a_ban WHERE ban_credits>0");
while($insert = mysql_fetch_assoc($active))
{
mysql_query("INSERT INTO a_ban_active VALUES('',$insert['user_id'],$insert['ban_id'])");
}
mysql_close();
?>

T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/sdc/0/8/yuu.sw/echange/frames/frame_ban_1.php on line 29

mysql_query("INSERT INTO a_ban_active VALUES('',$insert['user_id'],$insert['ban_id'])");

mysql_query('INSERT INTO a_ban_active VALUES("",'.$insert['user_id'].','.$insert['ban_id'].')"');

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/sdc/0/8/yuu.sw/echange/frames/frame_ban_1.php on line 29

$sql="INSERT INTO a_ban_active VALUES('',".$insert['user_id'].",".$insert['ban_id'].")";
mysql_query($sql);

while ($insert = mysql_fetch_assoc($active)) {
$userid=$insert['user_id'];
$banid=$insert['ban_id'];

 $sql="INSERT INTO a_ban_active VALUES('',"$userid","banid")"; 
mysql_query($sql);
}

<?php

$cct = mysql_connect("localhost", "root", "");
mysql_select_db("try", $cct);

class __Req_Sql {
	var $insert;
	var $sql = array();
	var $init = array();

	function sql() {
		$this->init[] = "SELECT ban_id, user_id FROM a_ban WHERE ban_credits='3'";
		$this->init[] = "INSERT INTO a_ban_active VALUES ('', ".$this->insert["user_id"].", ".$this->insert["ban_id"].");";
		
		foreach ($this->init as $this->sql) {
			while ($this->insert = mysql_fetch_array(mysql_query($this->sql[0]))) {
				mysql_query($this->sql[1]);
			}
		}
	}
}

$req = new __Req_Sql;

if ($req->sql()){
	echo "Success";
}
else {
	echo "Unable";
}

mysql_close(); 

?>

$transfert = "INSERT INTO `a_ban_active`(`a_user_id`, `a_ban_id`) SELECT ban_id, user_id FROM a_ban WHERE ban_credits > 0";

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/sdc/0/8/yuu.sw/echange/frames/frame_ban_1.php on line 8

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/sdc/0/8/yuu.sw/echange/frames/frame_ban_1.php on line 39

Warning: mt_rand() expects parameter 2 to be long, string given in /var/www/sdc/0/8/yuu.sw/echange/frames/frame_ban_1.php on line 42

$resultats = mysql_fetch_assoc($envoie);

$compter2 = mysql_num_rows($compter1);

$rand = mt_rand(0,'$compter2');

<?
mysql_connect('sql.free.fr','xxx','xxx');
mysql_select_db('yuu_sw');
$select = "SELECT ban_id, user_id, ban_fond, ban_color, ban_color2, ban_credits, ban_affichage FROM a_ban WHERE ban_id='$frame_id'";
$envoi = mysql_query($select);
$resultats = mysql_fetch_assoc($envoie);

$id1 = $resultats['ban_id'];
$id2 = $resultats['user_id'];
$fond = $resultats['ban_fond'];
$color = $resultats['ban_color'];
$color2 = $resultats['ban_color2'];
$credits1 = $resultats['ban_credits'];
$affiche = $resultats['ban_affichage'];

mysql_close();
?>

<?
mysql_connect('sql.free.fr','xxx','xxx');
mysql_select_db('yuu_sw');
$init = mysql_query("DELETE FROM a_ban_active");
$init2 = mysql_query("ALTER TABLE a_ban_active AUTO_INCREMENT=0");
$active = mysql_query("SELECT ban_id, user_id FROM a_ban WHERE ban_credits>0");
while($insert = mysql_fetch_assoc($active))
{
$sql="INSERT INTO a_ban_active VALUES('',".$insert['user_id'].",".$insert['ban_id'].")"; 
mysql_query($sql); 
}
mysql_close();
?>

<?
mysql_connect('sql.free.fr','xxx','xxx');
mysql_select_db('yuu_sw');
$compter1 = mysql_query("SELECT FROM a_ban_active");
$compter2 = mysql_num_rows($compter1);

$nombre = '$compter2';
$rand = mt_rand(0,'$compter2');

$select_active = mysql_query("SELECT ban_id FROM a_ban_active WHERE active_id='$rand'");
$resultat_active = mysql_fetch_assoc($select_active);
$ban_id_active = '$resultat_active';

$emp = mysql_fetch_assoc(mysql_query("SELECT ban_id, ban_emp, ban_lien, ban_credits, ban_affiche FROM a_ban WHERE ban_id='$ban_id_active'"));

$id3 = $emp['ban_id'];
$ban_emp = $emp['ban_emp'];
$ban_lien = $emp['ban_lien'];
$credits2 = $emp['ban_credits'];
$affiche = $emp['ban_affiche'];

mysql_close();
?>
<?
$new_credits1 = $credits1+1;
$new_credits2 = $credits2-1;
$new_affichage = $affichage+1;
$new_affiche = $affiche+1;

mysql_connect('sql.free.fr','xxx','xxx');
mysql_select_db('yuu_sw');
mysql_query("UPDATE a_ban SET ban_credits='$new_credits1' WHERE ban_id='$id1'");
mysql_query("UPDATE a_ban SET ban_credits='$new_credits2' WHERE ban_id='$id3'");
mysql_query("UPDATE a_ban SET ban_affiche='$new_affiche' WHERE ban_id='$id3'");
mysql_query("UPDATE a_ban SET ban_affichage='$new_affichage' WHERE ban_id='$id1'");

mysql_close();
?>