Help

[donnierivera]

Hi, could someone give me an idea on how to do this. On the first page I dinamicly generate check boxes by a field in the db. Example...
<input type='checkbox' name='$fac_cd[$i]' value='true'> $facSortDesc[$i]");

On the second page I want to make sure they checked at least one and if they checked more then one I want to do multiple updates... I can hard code it but it is very ugly and I don't want to have to maintain it. Well this is the hard code version... Thanks for any ideas...
<?php
/
//Connect to informix
$dbConnection=ifx_connect() or die("Connection to the Database failed");
//Query the database for facilities
$SELECT="SELECT fac_cd ";
$FROM= "FROM informix.events_fac "
$WHERE= "WHERE informix.evernts_fac=";
$builtQuery=$SELECT.$FROM;
$facilityQuery=ifx_query("$builtQuery", $dbConnection) or die("Query failed");
$rowsReturned=ifx_fetch_row($facilityQuery);
$z=0;
//Return the rows form Query
while (is_array($rowsReturned)) {
for(reset($rowsReturned); $fieldName=key($rowsReturned); next($rowsReturned)){
if ($fieldName==fac_cd) {
$fieldValue=$rowsReturned[$fieldName];
$fac_cd[$z]=trim($fieldValue);
}
}
$rowsReturned=ifx_fetch_row($facilityQuery);
$z++;
}
ifx_free_result($facilityQuery);
$dbConnection=ifx_close();
/
function IsDate($orig_data){
$data=explode("/","$orig_data");
$m=$data[0];
$d=$data[1];
$y=$data[2];
$res=checkdate($m,$d,$y);
if ($res==1) { return true;}
else { return false;}
}
if ($title=="") $titleCheck="false";
else $titleCheck="true";

if (IsDate($strtDate)==false) $strtDateCheck="false";
else $strtDateCheck="true";

if (IsDate($endDate)==false) $endDateCheck="false";
else $endDateCheck="true";

if ($desc=="") $descCheck="false";
else $descCheck="true";

$facilityCheck="false";
if ($AV==true) $facilityCheck="true";
if ($AC==true) $facilityCheck="true";
if ($BV==true) $facilityCheck="true";
if ($CS==true) $facilityCheck="true";
if ($CF==true) $facilityCheck="true";
if ($CC==true) $facilityCheck="true";
if ($CT==true) $facilityCheck="true";
if ($WC==true) $facilityCheck="true";
if ($DC==true) $facilityCheck="true";
if ($DW==true) $facilityCheck="true";
if ($DU==true) $facilityCheck="true";
if ($FC==true) $facilityCheck="true";
if ($FF==true) $facilityCheck="true";
if ($HQ==true) $facilityCheck="true";
if ($LF==true) $facilityCheck="true";
if ($PM==true) $facilityCheck="true";
if ($RC==true) $facilityCheck="true";
if ($SC==true) $facilityCheck="true";
if ($SF==true) $facilityCheck="true";
if ($YP==true) $facilityCheck="true";

if ($titleCheck=="false" or $strtDateCheck=="false" or $endDateCheck=="false" or $descCheck=="false" or $facilityCheck=="false") {
header("Location: http://localhost/index/updateEvents.php?title=$titleCheck&strtDate=$strtDateCheck&endDate=$endDateCheck&desc=$descCheck&fac=$facilityCheck");
exit;
}
//Connect to informix
$dbConnection=ifx_connect() or die("Connection to the Database failed");
//Query the database for facilities
$desc_id=ifx_create_blob(1,0,$desc);
$blobidarray[]=$desc_id;
if ($AV==true) {
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'AV', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($AC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'AC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($BV==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'BV', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($CS==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'CS', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($CF==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'CF', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($CC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'CC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($CT==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'CT', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($WC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'WC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($DC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'DC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($DW==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'DW', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($DU==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'DU', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($FC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'FC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($FF==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'FF', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($HQ==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'HQ', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($LF==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'LF', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($PM==true) {
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'PM', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($RC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'RC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($SC==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'SC', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($SF==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'SF', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
if ($YP==true){
$insertEvent="INSERT INTO events (evt_title, evt_strt_dtd, evt_end_dtd, fac_cd[$i], evt_txt)
VALUES('$title', '$strtDate', '$endDate', 'YP', ?)";
$insertNewEvents=ifx_query($insertEvent, $dbConnection, $blobidarray) or die("Query failed");
ifx_free_result($insertNewEvents);
}
$dbConnection=ifx_close();

?>