$query="select LOC_DATE_DEBUT,
STAR_TARIF from locations,tarifs,salles where salles.SAL_CODE=tarifs.SAL_CODE and locations.SAL_CODE=salles.SAL_CODE and tarifs.SAL_CODE=$SAL_CODE and TYPCLI_CODE in ( select Clients.TYPCLI_CODE from clients,typeclients,tarifs
where clients.TYPCLI_CODE=typeclients.TYPCLI_CODE and typeclients.TYPCLI_CODE=tarifs.TYPCLI_CODE and CLI_CODE=$CLI_CODE)";
$result=odbc_do($connect,$query);
while(odbc_fetch_into($result,$fields)){
if ($fields[0] == $LOC_DATE_DEBUT)
{
$nb = 1;
}
}
if ($nb == 0)
{
$query="insert into locations (LOC_NUM_DOSSIER,LOC_DATE_DEBUT,NB_JOURS,
LOC_PRIX_BASE,SAL_CODE,CLI_CODE) values('$VAR_MAX_NUM_DOSSIER','$LOC_DATE_DEBUT','$NB_JOURS',
'
$fields[1]','$SAL_CODE','$CLI_CODE')";
Partager