Here's the code :
<?
session_start();
// Start DB Connection
$db = mysql_connect('localhost', '+++++, '+++++);
mysql_select_db('client',$db);
// Creating Var
$desNum = 0;
$desListNum = 0;
$typeNum = 0;
$typeListNum = 0;
// Input Info Into DB -- Initialized PointTotal
if($pt == "1") {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formQuestion) VALUES('bAnalyse".$analyse."','pointTotal','".$pointTotal."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
}
?>
<html>
<head>
<title>VisionClient » Formulaire » Nouveau</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../includes/style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="middle">
<table width="400" height="50" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5F5F5">
<tr>
<td align="center" valign="middle" class="formText1">validation étape.3 - analyse<?=$analyse?> - point #<?=$pt?></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?
// Input Info Into DB -- AnalysePoint
if($pt < $pointTotal) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formQuestion) VALUES('bAnalyse".$analyse."','pointTitle".$pt."','".$pointTitle."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
foreach ($pointList as $value) {
if($desListNum < $desNumber) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formValue) VALUES('bAnalyse".$analyse."','pointList".$pt."[".$desNum."]','".$value."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
$desNum++;
$desListNum++;
}
}
foreach ($pointType as $value) {
if($typeListNum < $desNumber) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formValue) VALUES('bAnalyse".$analyse."','pointList".$pt."[".$typeNum."]','".$value."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
$typeNum++;
$typeListNum++;
}
}
$pt++;
// End DB Connection
mysql_close();
?>
<script language="JavaScript">
// Redirection Delay
setTimeout("location.href='fstep3.php4?pt="<?=$pt?>"&analyse="<?=$analyse?>"&total="<?=$pointTotal?>"'",2000);
</script>
<?
}
// Input Info Into DB -- AnalysePoint
if($pt == $pointTotal) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formQuestion) VALUES('bAnalyse".$analyse."','pointTitle".$pt."','".$pointTitle."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
foreach ($pointList as $value) {
if($desListNum < $desNumber) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formValue) VALUES('bAnalyse".$analyse."','pointList".$pt."[".$desNum."]','".$value."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
$desNum++;
$desListNum++;
}
}
foreach ($pointType as $value) {
if($typeListNum < $desNumber) {
$sql = "INSERT INTO f".$clientRef." (formType,formName,formValue) VALUES('bAnalyse".$analyse."','pointList".$pt."[".$typeNum."]','".$value."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Validation des Données [analyse".$analyse."]");
$typeNum++;
$typeListNum++;
}
}
$pt=1;
$analyse++;
// End DB Connection
mysql_close();
?>
<script language="JavaScript">
// Redirection Delay
setTimeout("location.href='fstep3.php4?pt="<?=$pt?>"&analyse="<?=$analyse?>"&total="<?=$pointTotal?>"'",2000);
</script>
<?
}
?>
and here's the message error the browser give me :
line:23
char:44
error: expected ')'
code:0
url: blablabla
I don't understand ... please help
Steve