1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| global $g_num_rows,$g_numOptionsByList,$session_restrict,$res;
$db = new DB;
$db->Debug =false;
//echo "sql restrict : $restrict<br>";
//echo "sql session_restrict : $session_restrict<br>";
$query="select count(*) from VEHICULES $restrict";
$db->query($query);
$db->next_record();
$g_num_rows= $db->f("COUNT(*)");
// echo "num_rows : ".$g_num_rows;
if ($g_num_rows < $startRow + 500){
$borneSup=$g_num_rows;
} else {
$borneSup=$startRow + 500;
}
$db1 = new DB;
$db1->Debug =false;
$query1="select IDNV, CDNVMQ, CDNVMD, LDNVVE from VEHICULES ";
$query1.="$restrict ";
$db1->query($query1);
for($i=0;$i<$borneSup;$i++){
$db1->next_record();
if ($i > $startRow-1){
$db2 = new DB;
$db2->Debug =true;
$identifiant= $db1->f("IDNV");
//bon jusqu'ici
if ($HTTP_POST_VARS['choix[$i]']) {
$query2="update VEHICULES set IDNV2 ='". $valuecode."' where IDNV ='".$identifiant."'";
$db2->query($query2);
}
}
}
} |
Partager