<body>
<table>
<? echo("<td width='18%' height='35'><input type ='text' name='no_dossier' size='06' onChange= " .requete($no_dossier) ." value='$no_dossier'></td>");?>
<td width="30%" height="35">
<?
<?
function requete($no_dossier)
{
global $DB_SERVER, $DB_LOGIN, $DB_PASSWORD, $DB;
$host="192.168.2.28";
$user="root";
$password="";
$link = mysql_connect($DB_SERVER, $DB_LOGIN, $DB_PASSWORD) or die ("Connexion impossible a la table docket"); // connexion a la BD
mysql_select_db($DB,$link);
$req = "SELECT dock_uin, dock_no, clino FROM docket WHERE dockno = '$no_dossier'"; // requete qui recupere les numeros de dossiers
//$req = stripSlashes($req) ; // enleve les symboles superflus dans la requete de la ligne precedente
$result =mysql_query($req, $link); // execution de la requete et stockage des resultat dans la variable $result.
echo "resultat = $result requete = $req DB = $DB";
$row = mysql_fetch_object($result);
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
$row_array = mysql_fetch_row($result);
$uin = $row_array[0];
$no_dossier=$row_array[1];
$nom_client= $row_array[2];
}
echo " resultat = " . $result;
}
?>
</table>
</body>
i only have this message :
Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/data/valider/docket/ship.php on line 1082
Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/data/valider/docket/ship.php on line 1084
