1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| <?php
$REFC='sdsdsdsd';
$IDOT='1';
$mabasededonnee='querytest';
$connection = mysql_connect('localhost','root','');
if ( ! $connection ) die ('connection impossible');
mysql_select_db($mabasededonnee) or die ('pas de connection');
$requete_result=mysql_query("SELECT * from ma_table",$connection);
mysql_query("UPDATE MA_TABLE SET ref_client = '".$REFC."' WHERE IDot = ".$IDOT,$connection);
$numLigne = mysql_num_rows($requete_result);
for ($i=0; $i < $numLigne; $i++) {
$ligne = mysql_fetch_array($requete_result);
echo $ligne['ref_client']."<BR>";
}
mysql_close($connection);
?> |