$sqlm ="SELECT * FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons'  AND orders_id NOT IN (SELECT orders_id FROM coupon_solde)";

$sqlm ="SELECT * FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons'  AND coupons_id NOT IN (SELECT orders_id FROM coupon_solde)";

echo"$Pcoupons<bR>";
		echo"<table>";
    	mysql_connect($serveur, $user, $passw) or die("Impossible de se connecter ˆ la base de donnŽes"); 
		mysql_select_db("$bd_base")or die("Impossible de se connecter ˆ la base de donnŽes");
		
		$sqlm ="SELECT orders_id,coupons_id FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons'";
		$reqm = mysql_query($sqlm) or die('Erreur SQL !<br>'.$sqlm.'<br>'.mysql_error());
		//echo"<form method='post' enctype='multipart/form-data'>";
		while($datam = mysql_fetch_assoc($reqm)) 
		{
		$orders_id= $datam['orders_id'];
		$coupons_id= $datam['coupons_id'];
        $sql ="SELECT value FROM orders_total WHERE sort_order='0' and orders_id='$orders_id'";
        $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
        while($data = mysql_fetch_assoc($req))
        {
        echo"<tr><td>";
        echo"<form method='post' enctype='multipart/form-data'>";
        echo $data['value'];
        $value=$data['value'];
        $orders_id=$datam['orders_id'];
        echo"</td><td>";
        echo"<input type='hidden' name='Pcoupons' value='$Pcoupons'>";
        echo"<input type='hidden' name='value' value='$value'>";
        echo"<input type='hidden' name='orders_id' value='$orders_id'>";
		echo"<input type='submit' name='miseajour' value='Mise à Jour'>";
		echo"</form>";	
		echo"</td></tr>";
        $i++;	
        }

$sqlm ="SELECT orders_id,coupons_id FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons'";

CREATE TABLE `discount_coupons_to_orders` (
  `coupons_id` varchar(32) NOT NULL default '',
  `orders_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`coupons_id`,`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `coupon_solde` (
  `id` int(11) NOT NULL auto_increment,
  `Pcoupons` varchar(255) NOT NULL default '',
  `orders_id` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL,
  `credit` varchar(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

SELECT * FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons'

comment sa
$sqlm ="SELECT * FROM discount_coupons_to_orders WHERE coupons_id='$Pcoupons' = NOT IN (SELECT orders_id FROM coupon_solde WHERE orders_id='$orders_id')";