Page 1 of 2

php inserting problem

Posted: Fri Apr 18, 2008 10:35 am
by andrade1
I have created a form that has a numerous amount of checkboxes and a few text fields. Whenever I try to submit the form I receive my die statements and the tables aren't updated. How can I fix these problems?

Code: Select all

 
 
[color=#0000FF]<html>
<body>
 
<?php
 
// connection string
 
 
$con = mysql_connect("localhost", "ferf", "sfdsdf") or die("could not connect to server");
mysql_select_db("dafdaf", $con) or die('Sorry, could not connect to database');
 
$caseid = $_GET['id'];
 
 
// checks to see if the values have been set for all text fields
 
//delcare all posts as variables
 
$DRCVD = $_POST['DRCVD'];
$OCONT = $_POST['OCONT'];
$CONTENTS= $_POST['CONTENTS'];
$DEADLINE = $_POST['DEADLINE'];
$GIVENTO = $_POST['GIVENTO'];
$STATUS= $_POST['STATUS'];
$OUTCOME= $_POST['OUTCOME'];
$NOTES= $_POST['NOTES'];
 
 
if(isset ($_POST['DRCVD']) && isset($_POST['OCONT']) && isset($_POST['CONTENTS']) && isset($_POST['DEADLINE']) && isset($_POST['GIVENTO']) && isset($_POST['STATUS']) && isset($_POST['OUTCOME']) && isset($_POST['NOTES']))
{ 
// sql insert query for the variables into the cases table
$query = "INSERT INTO cases(DRCVD, OCONT, CONTENTS, DEADLINE, GIVENTO,STATUS,OUTCOME, NOTES ) VALUES ('$DRCVD', '$OCONT', '$CONTENTS', '$DEADLINE', '$GIVENTO', '$STATUS', '$OUTCOME', '$NOTES')";
// sql query either processes or fails and outputs an error message
mysql_query($query) or die ('Error, insert into query failed');
}
 
 
 
 
// original department checkboxes
 
$query = "INSERT into origdepart VALUES (";
 
if($ACINTEG == "1")
{
$query = $query . "ACINTEG = 1, ";
} else
{
$query = $query . "ACINTEG = 0, ";
}
 
if($CIVENG == "1")
{
$query = $query . "CIVENG = 1, ";
} else
{
$query = $query . "CIVENG = 0, ";
}
 
if($ENRMGT == "1")
{
$query = $query . "ENRMGT = 1, ";
} else
{
$query = $query . "ENRMGT = 0, ";
}
 
if($IA == "1")
{
$query = $query . "IA = 1, ";
} else
{
$query = $query . "IA = 0, ";
}
 
if($OFFCAMP == "1")
{
$query = $query . "OFFCAMP = 1, ";
} else
{
$query = $query . "OFFCAMP = 0, ";
}
 
if($PUBREL == "1")
{
$query = $query . "PUBREL = 1, ";
} else
{
$query = $query . "PUBREL = 0, ";
}
 
if($UCS == "1")
{
$query = $query . "UCS = 1, ";
} else
{
$query = $query . "UCS = 0, ";
}
 
if($ADSVC == "1")
{
$query = $query . "ADSVC = 1, ";
} else
{
$query = $query . "ADSVC = 0, ";
}
 
if($CLUBS == "1")
{
$query = $query . "CLUBS = 1, ";
} else
{
$query = $query . "CLUBS = 0, ";
}
 
if($ENGR == "1")
{
$query = $query . "ENGR = 1, ";
} else
{
$query = $query . "ENGR = 0, ";
}
 
if($IACUC == "1")
{
$query = $query . "IACUC = 1, ";
} else
{
$query = $query . "IACUC = 0, ";
}
 
if($OIA == "1")
{
$query = $query . "OIA = 1, ";
} else
{
$query = $query . "OIA = 0, ";
}
 
if($RETRVR == "1")
{
$query = $query . "RETRVR = 1, ";
} else
{
$query = $query . "RETRVR = 0, ";
}
 
if($UHS == "1")
{
$query = $query . "UHS = 1, ";
} else
{
$query = $query . "UHS = 0, ";
}
 
if($AFSTDS == "1")
{
$query = $query . "AFSTDS = 1, ";
} else
{
$query = $query . "AFSTDSG = 0, ";
}
 
if($COMMONS == "1")
{
$query = $query . "COMMONS = 1, ";
} else
{
$query = $query . "COMMONS = 0, ";
}
 
if($ERICSCH == "1")
{
$query = $query . "ERICSCH = 1, ";
} else
{
$query = $query . "ERICSCH = 0, ";
}
 
if($IS == "1")
{
$query = $query . "IS= 1, ";
} else
{
$query = $query . "IS = 0, ";
}
 
if($OIR == "1")
{
$query = $query . "OIR = 1, ";
} else
{
$query = $query . "OIR = 0, ";
}
 
if($R_PARK == "1")
{
$query = $query . "R_PARK = 1, ";
} else
{
$query = $query . "R_PARK = 0, ";
}
 
if($UMFNDN == "1")
{
$query = $query . "UMFNDN = 1, ";
} else
{
$query = $query . "UMFNDN = 0, ";
}
 
if($ALREL == "1")
{
$query = $query . "ALREL = 1, ";
} else
{
$query = $query . "ALREL = 0, ";
}
 
if($CONTED == "1")
{
$query = $query . "CONTED = 1, ";
} else
{
$query = $query . "CONTED = 0, ";
}
 
if($ESH == "1")
{
$query = $query . "ESH = 1, ";
} else
{
$query = $query . "ESH = 0, ";
}
 
if($IES == "1")
{
$query = $query . "IES = 1, ";
} else
{
$query = $query . "IES = 0, ";
}
 
if($OIT == "1")
{
$query = $query . "OIT = 1, ";
} else
{
$query = $query . "OIT = 0, ";
}
 
if($SGA == "1")
{
$query = $query . "SGA = 1, ";
} else
{
$query = $query . "SGA = 0, ";
}
 
if($UPWBD == "1")
{
$query = $query . "UPWBD = 1, ";
} else
{
$query = $query . "UPWBD = 0, ";
}
 
if($AMERSTD == "1")
{
$query = $query . "AMERSTD = 1, ";
} else
{
$query = $query . "AMERSTD = 0, ";
}
 
if($CSEE == "1")
{
$query = $query . "CSEE = 1, ";
} else
{
$query = $query . "CSEE = 0, ";
}
 
if($FACSEN == "1")
{
$query = $query . "FACSEN = 1, ";
} else
{
$query = $query . "FACSEN= 0, ";
}
 
if($IRB == "1")
{
$query = $query . "IRB = 1, ";
} else
{
$query = $query . "IRB= 0, ";
}
 
if($ORL == "1")
{
$query = $query . "ORL = 1, ";
} else
{
$query = $query . "ORL = 0, ";
}
 
if($SHRVR == "1")
{
$query = $query . "SHRVR = 1, ";
} else
{
$query = $query . "SHRVR = 0, ";
}
 
if($USM == "1")
{
$query = $query . "USM = 1, ";
} else
{
$query = $query . "USM = 0, ";
}
 
if($ANCSTD == "1")
{
$query = $query . "ANCSTD = 1, ";
} else
{
$query = $query . "ANCSTD= 0, ";
}
 
if($CSST == "1")
{
$query = $query . "CSST = 1, ";
} else
{
$query = $query . "CSST = 0, ";
}
 
if($FINSERV == "1")
{
$query = $query . "FINSERV = 1, ";
} else
{
$query = $query . "FINSERV = 0, ";
}
 
if($IRC == "1")
{
$query = $query . "IRC = 1, ";
} else
{
$query = $query . "IRC = 0, ";
}
 
if($OSP == "1")
{
$query = $query . "OSP = 1, ";
} else
{
$query = $query . "OSP = 0, ";
}
 
if($SOCWRK == "1")
{
$query = $query . "SOCWRK = 1, ";
} else
{
$query = $query . "SOCWRK = 0, ";
}
 
if($VART == "1")
{
$query = $query . "VART = 1, ";
} else
{
$query = $query . "VART= 0, ";
}
 
if($ASCRV == "1")
{
$query = $query . "ASCRV= 1, ";
} else
{
$query = $query . "ASCRV = 0, ";
}
 
if($CWIT == "1")
{
$query = $query . "CWIT = 1, ";
} else
{
$query = $query . "CWIT = 0, ";
}
 
if($GALLRY == "1")
{
$query = $query . "GALLRY = 1, ";
} else
{
$query = $query . "GALLRY = 0, ";
}
 
if($JCET == "1")
{
$query = $query . "JCET = 1, ";
} else
{
$query = $query . "JCET = 0, ";
}
 
if($OTD == "1")
{
$query = $query . "OTD = 1, ";
} else
{
$query = $query . "OTD = 0, ";
}
 
if($SOCY == "1")
{
$query = $query . "SOCY = 1, ";
} else
{
$query = $query . "SOCY = 0, ";
}
 
if($VPA_F == "1")
{
$query = $query . "VPA_F = 1, ";
} else
{
$query = $query . "VPA_F = 0, ";
}
 
if($ATHL == "1")
{
$query = $query . "ATHL = 1, ";
} else
{
$query = $query . "ATHL = 0, ";
}
 
if($DANCE == "1")
{
$query = $query . "DANCE = 1, ";
} else
{
$query = $query . "DANCE = 0, ";
}
 
if($GEOG == "1")
{
$query = $query . "GEOG = 1, ";
} else
{
$query = $query . "GEOG = 0, ";
}
 
if($LIBRY == "1")
{
$query = $query . "LIBRY = 1, ";
} else
{
$query = $query . "LIBRY = 0, ";
}
 
if($PHIL == "1")
{
$query = $query . "PHIL = 1, ";
} else
{
$query = $query . "PHIL = 0, ";
}
 
if($SJP == "1")
{
$query = $query . "SJP = 1, ";
} else
{
$query = $query . "SJP= 0, ";
}
 
if($VPACAFF == "1")
{
$query = $query . "VPACAFF = 1, ";
} else
{
$query = $query . "VPACAFF = 0, ";
}
 
if($BIO == "1")
{
$query = $query . "BIO = 1, ";
} else
{
$query = $query . "BIO = 0, ";
}
 
if($DEANAHSS == "1")
{
$query = $query . "DEANAHSS = 1, ";
} else
{
$query = $query . "DEANAHSS = 0, ";
}
 
if($GEST == "1")
{
$query = $query . "GEST = 1, ";
} else
{
$query = $query . "GEST = 0, ";
}
 
 
if($LRC == "1")
{
$query = $query . "LRC = 1, ";
} else
{
$query = $query . "LRC = 0, ";
}
 
 
if($PHYS == "1")
{
$query = $query . "PHYS = 1, ";
} else
{
$query = $query . "PHYS = 0, ";
}
 
if($STUAFF == "1")
{
$query = $query . "STUAFF = 1, ";
} else
{
$query = $query . "STUAFF = 0, ";
}
 
if($VPFACAF == "1")
{
$query = $query . "VPFACAF = 1, ";
} else
{
$query = $query . "VPFACAF = 0, ";
}
 
if($BKSTR == "1")
{
$query = $query . "BKSTR = 1, ";
} else
{
$query = $query . "BKSTR = 0, ";
}
 
 
if($DEANCOEIT == "1")
{
$query = $query . "DEANCOEIT = 1, ";
} else
{
$query = $query . "DEANCOEIT = 0, ";
}
 
if($GRAD == "1")
{
$query = $query . "GRAD = 1, ";
} else
{
$query = $query . "GRAD = 0, ";
}
 
 
 
if($MAS == "1")
{
$query = $query . "MAS = 1, ";
} else
{
$query = $query . "MAS = 0, ";
}
 
if($POLTSCI == "1")
{
$query = $query . "POLTSCI = 1, ";
} else
{
$query = $query . "POLTSCI = 0, ";
}
 
 
if($STULIFE == "1")
{
$query = $query . "STULIFE = 1, ";
} else
{
$query = $query . "STULIFE = 0, ";
}
 
 
if($VPIA == "1")
{
$query = $query . "VPIA = 1, ";
} else
{
$query = $query . "VPIA = 0, ";
}
 
if($CAREER == "1")
{
$query = $query . "CAREER = 1, ";
} else
{
$query = $query . "CAREER = 0, ";
}
 
if($DEANUE == "1")
{
$query = $query . "DEANUE = 1, ";
} else
{
$query = $query . "DEANUE = 0, ";
}
 
if($GSA == "1")
{
$query = $query . "GSA = 1, ";
} else
{
$query = $query . "GSA = 0, ";
}
 
 
if($MATH == "1")
{
$query = $query . "MATH = 1, ";
} else
{
$query = $query . "MATH = 0, ";
}
 
 
if($POLICE == "1")
{
$query = $query . "POLICE = 1, ";
} else
{
$query = $query . "POLICE = 0, ";
}
 
if($STUSIPSRV == "1")
{
$query = $query . "STUSIPSRV = 1, ";
} else
{
$query = $query . "STUSIPSRV = 0, ";
}
 
if($VPIT == "1")
{
$query = $query . "VPIT = 1, ";
} else
{
$query = $query . "VPIT = 0, ";
}
 
if($CASPR == "1")
{
$query = $query . "CASPR = 1, ";
} else
{
$query = $query . "CASPR = 0, ";
}
 
 
if($DEANCNMS == "1")
{
$query = $query . "DEANCNMS = 1, ";
} else
{
$query = $query . "DEANCNMS = 0, ";
}
 
if($GUESTSRV == "1")
{
$query = $query . "GUESTSRV= 1, ";
} else
{
$query = $query . "GUESTSRV = 0, ";
}
 
if($MECHENG == "1")
{
$query = $query . "MECHENG = 1, ";
} else
{
$query = $query . "MECHENG = 0, ";
}
 
if($PPLNT == "1")
{
$query = $query . "PPLNT = 1, ";
} else
{
$query = $query . "PPLNT = 0, ";
}
 
if($TECHCTR == "1")
{
$query = $query . "TECHCTR = 1, ";
} else
{
$query = $query . "TECHCTR = 0, ";
}
 
 
if($VPRDGS == "1")
{
$query = $query . "VPRDGS = 1, ";
} else
{
$query = $query . "VPRDGS = 0, ";
}
 
if($CAST == "1")
{
$query = $query . "CAST = 1, ";
} else
{
$query = $query . "CAST = 0, ";
}
 
if($DPET_CPS == "1")
{
$query = $query . "DPET_CPS = 1, ";
} else
{
$query = $query . "DPET_CPS = 0, ";
}
 
if($HIST == "1")
{
$query = $query . "HIST = 1, ";
} else
{
$query = $query . "HIST = 0, ";
}
 
if($MIPAR == "1")
{
$query = $query . "MIPAR = 1, ";
} else
{
$query = $query . "MIPAR = 0, ";
}
 
 
if($PRES == "1")
{
$query = $query . "PRES = 1, ";
} else
{
$query = $query . "PRES = 0, ";
}
 
if($TEI == "1")
{
$query = $query . "TEI = 1, ";
} else
{
$query = $query . "TEI = 0, ";
}
 
if($WMCTR == "1")
{
$query = $query . "WMCTR = 1, ";
} else
{
$query = $query . "WMCTR = 0, ";
}
 
if($CUERE == "1")
{
$query = $query . "CUERE = 1, ";
} else
{
$query = $query . "CUERE = 0, ";
}
 
if($ECON == "1")
{
$query = $query . "ECON= 1, ";
} else
{
$query = $query . "ECON = 0, ";
}
 
 
if($HLTHSCI == "1")
{
$query = $query . "HLTHSCI = 1, ";
} else
{
$query = $query . "HLTHSCI = 0, ";
}
 
 
if($MLL == "1")
{
$query = $query . "MLL = 1, ";
} else
{
$query = $query . "MLL = 0, ";
}
 
if($PROC == "1")
{
$query = $query . "PROC = 1, ";
} else
{
$query = $query . "PROC = 0, ";
}
 
if($TELECOMM == "1")
{
$query = $query . "TELECOMM = 1, ";
} else
{
$query = $query . "TELECOMM = 0, ";
}
 
if($WMSTD == "1")
{
$query = $query . "WMSTD = 1, ";
} else
{
$query = $query . "WMSTD = 0, ";
}
 
 
if($CHEM == "1")
{
$query = $query . "CHEM = 1, ";
} else
{
$query = $query . "CHEM = 0, ";
}
 
if($EDUC == "1")
{
$query = $query . "EDUC = 1, ";
} else
{
$query = $query . "EDUC = 0, ";
}
 
if($HNRSCOL == "1")
{
$query = $query . "HNRSCOL = 1, ";
} else
{
$query = $query . "HNRSCOL = 0, ";
}
 
if($MUSIC == "1")
{
$query = $query . "MUSIC = 1, ";
} else
{
$query = $query . "MUSIC = 0, ";
}
 
if($PROV == "1")
{
$query = $query . "PROV = 1, ";
} else
{
$query = $query . "PROV = 0, ";
}
 
 
if($THTR == "1")
{
$query = $query . "THTR = 1, ";
} else
{
$query = $query . "THTR = 0, ";
}
 
if($CHEMENG == "1")
{
$query = $query . "CHEMENG = 1, ";
} else
{
$query = $query . "CHEMENG = 0, ";
}
 
if($EHS == "1")
{
$query = $query . "EHS = 1, ";
} else
{
$query = $query . "EHS = 0, ";
}
 
if($HREL == "1")
{
$query = $query . "HREL = 1, ";
} else
{
$query = $query . "HREL = 0, ";
}
 
if($MYRHOF == "1")
{
$query = $query . "MYRHOF = 1, ";
} else
{
$query = $query . "MYRHOF = 0, ";
}
 
 
if($PSYC == "1")
{
$query = $query . "PSYC = 1, ";
} else
{
$query = $query . "PSYC = 0, ";
}
 
 
 
if($TRANSIT == "1")
{
$query = $query . "TRANSIT= 1, ";
} else
{
$query = $query . "TRANSIT = 0, ";
}
 
if($CHPDM == "1")
{
$query = $query . "CHPDM = 1, ";
} else
{
$query = $query . "CHPDM = 0, ";
}
 
if($ENGL == "1")
{
$query = $query . "ENGL = 1, ";
} else
{
$query = $query . "ENGL = 0, ";
}
 
if($HRES == "1")
{
$query = $query . "HRES = 1, ";
} else
{
$query = $query . "HRES = 0, ";
}
 
 
if($OAG == "1")
{
$query = $query . "OAG = 1, ";
} else
{
$query = $query . "OAG = 0, ";
}
 
 
if($PUBPOL == "1")
{
$query = $query . "PUBPOL = 1, ";
} else
{
$query = $query . "PUBPOL = 0, ";
}
 
 
if($TRNCTRS == "1")
{
$query = $query . "TRNCTRS = 1, ";
} else
{
$query = $query . "TRNCTRS = 0, ";
}
 
 
 
//responsible offices
 
$query = "INSERT into respoff VALUES (";
 
if($DEANAHSS2 == "1")
{
$query = $query . "DEANAHSS2 = 1, ";
} else
{
$query = $query . "DEANAHSS2 = 0, ";
}
 
if($PRES2 == "1")
{
$query = $query . "PRES2 = 1, ";
} else
{
$query = $query . "PRES2 = 0, ";
}
 
 
 
if($VPIT2 == "1")
{
$query = $query . "VPIT2 = 1, ";
} else
{
$query = $query . "VPIT2 = 0, ";
}
 
if($DEANCNMS2 == "1")
{
$query = $query . "DEANCNMS2 = 1, ";
} else
{
$query = $query . "DEANCNMS2 = 0, ";
}
 
if($PROV2 == "1")
{
$query = $query . "PROV2 = 1, ";
} else
{
$query = $query . "PROV2 = 0, ";
}
 
if($VPRDGS2 == "1")
{
$query = $query . "VPRDGS2 = 1, ";
} else
{
$query = $query . "VPRDGS2 = 0, ";
}
 
if($DEANCOEIT2== "1")
{
$query = $query . "DEANCOEIT2 = 1, ";
} else
{
$query = $query . "DEANCOEIT2 = 0, ";
}
 
if($VPA_F2 == "1")
{
$query = $query . "VPA_F2 = 1, ";
} else
{
$query = $query . "VPA_F2 = 0, ";
}
 
 
if($VPSA == "1")
{
$query = $query . "VPSA = 1, ";
} else
{
$query = $query . "VPSA= 0, ";
}
 
if($DEANERK == "1")
{
$query = $query . "DEANERK = 1, ";
} else
{
$query = $query . "DEANERK = 0, ";
}
 
if($VPDUE == "1")
{
$query = $query . "VPDUE = 1, ";
} else
{
$query = $query . "VPDUE = 0, ";
}
 
if($DEANUE == "1")
{
$query = $query . "DEANUE = 1, ";
} else
{
$query = $query . "DEANUE = 0, ";
}
 
 
if($VPIA2 == "1")
{
$query = $query . "VPIA2 = 1, ";
} else
{
$query = $query . "VPIA2 = 0, ";
}
 
 
 
 
// requests
 
$query = "INSERT into request VALUES (";
 
if($ADVISE == "1")
{
$query = $query . "ADVISE = 1, ";
} else
{
$query = $query . "ADVISE = 0, ";
}
 
 
if($DRAFT == "1")
{
$query = $query . "DRAFT = 1, ";
} else
{
$query = $query . "DRAFT = 0, ";
}
 
if($MEDIATE == "1")
{
$query = $query . "MEDIATE = 1, ";
} else
{
$query = $query . "MEDIATE = 0, ";
}
 
 
if($REPORT == "1")
{
$query = $query . "REPORT = 1, ";
} else
{
$query = $query . "REPORT = 0, ";
}
 
if($CONTACT == "1")
{
$query = $query . "CONTACT = 1, ";
} else
{
$query = $query . "CONTACT = 0, ";
}
 
 
if($NEGOTIATE == "1")
{
$query = $query . "NEGOTIATE = 1, ";
} else
{
$query = $query . "NEGOTIATE = 0, ";
}
 
if($REVIEW == "1")
{
$query = $query . "REVIEW = 1, ";
} else
{
$query = $query . "REVIEW = 0, ";
}
 
 
if($RESEARCH == "1")
{
$query = $query . "RESEARCH = 1, ";
} else
{
$query = $query . "RESEARCH = 0, ";
}
 
 
if($INVESTIGATE == "1")
{
$query = $query . "INVESTIGATE = 1, ";
} else
{
$query = $query . "INVESTIGATE = 0, ";
}
 
 
if($COORDINATE == "1")
{
$query = $query . "COORDINATE = 1, ";
} else
{
$query = $query . "COORDINATE = 0, ";
}
 
 
if($MEETING_ATTEND == "1")
{
$query = $query . "MEETING_ATTEND = 1, ";
} else
{
$query = $query . "MEETING_ATTEND = 0, ";
}
 
 
if($PRESENTATION == "1")
{
$query = $query . "PRESENTATION = 1, ";
} else
{
$query = $query . "PRESENTATION = 0, ";
}
 
 
 
 
// completed
 
$query = "INSERT into cases VALUES (";
 
if($COMPLETED == "1")
{
$query = $query . "COMPLETED = 1, ";
} else
{
$query = $query . "COMPLETED = 0, ";
}
 
 
 
 
// referred to
 
 
$query = "INSERT into cases VALUES (";
 
if($OAG3 == "1")
{
$query = $query . "OAG3 = 1, ";
} else
{
$query = $query . "OAG3 = 0, ";
}
 
if($WTP2 == "1")
{
$query = $query . "WTP2 = 1, ";
} else
{
$query = $query . "WTP2 = 0, ";
}
 
 
if($OTHER2 == "1")
{
$query = $query . "OTHER2 = 1, ";
} else
{
$query = $query . "OTHER2 = 0, ";
}
 
 
 
?>
</body>
</html>
 
 
[/color]

Re: php inserting problem

Posted: Fri Apr 18, 2008 10:43 am
by andym01480

Code: Select all

$query = "INSERT into origdepart VALUES (";
is the problem

it needs to be

Code: Select all

$query = "INSERT into origdepart (blah, blah, blah) VALUES (";
where the blahs are the field names

echo the queries before using them
use or DIE(mysql_error()); to give you a clue of what is wrong

Re: php inserting problem

Posted: Fri Apr 18, 2008 10:48 am
by aceconcepts
However, if you are not using an AUTO_INCREMENT data type in origdepart then you would not need to specify any table fields.

origdepart (blah, blah, blah) basically means you are only inserting data into those specific fields.

Re: php inserting problem

Posted: Fri Apr 18, 2008 10:55 am
by onion2k
aceconcepts wrote:However, if you are not using an AUTO_INCREMENT data type in origdepart then you would not need to specify any table fields.

origdepart (blah, blah, blah) basically means you are only inserting data into those specific fields.
Always specify the fields in an INSERT statement. If you don't then MySQL assumes that the values go into the fields in the order they appear. If your database schema changes in the future, say you add a new column, then all your SQL will break. If you specify the columns it won't.

Re: php inserting problem

Posted: Fri Apr 18, 2008 10:57 am
by andym01480
Thanks onion2k

Also the following kind of change would need to be made to all the if statements...

Code: Select all

if($ACINTEG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
?

Re: php inserting problem

Posted: Fri Apr 18, 2008 10:59 am
by aceconcepts
This is a good point. I only pointed out that fields do not need to be specified and so in turn this may not be where the "inserting" problem lies.

But yes I agree, it is good practice to specify all fields :wink:

Re: php inserting problem

Posted: Fri Apr 18, 2008 11:41 am
by andrade1
fixed every checkbox, added error statements, and fixed the insert statements. It still doesn't update the database.

Code: Select all

 
 
[color=#0040FF]<html>
<body>
 
<?php
 
// connection string
 
 
$con = mysql_connect("adgag", "dagg", "afdaggfg") or die("could not connect to server");
mysql_select_db("adgfg", $con) or die('Sorry, could not connect to database');
 
$caseid = $_GET['id'];
 
 
// checks to see if the values have been set for all text fields
 
//delcare all posts as variables
 
$DRCVD = $_POST['DRCVD'];
$OCONT = $_POST['OCONT'];
$CONTENTS= $_POST['CONTENTS'];
$DEADLINE = $_POST['DEADLINE'];
$GIVENTO = $_POST['GIVENTO'];
$STATUS= $_POST['STATUS'];
$OUTCOME= $_POST['OUTCOME'];
$NOTES= $_POST['NOTES'];
 
 
if(isset ($_POST['DRCVD']) && isset($_POST['OCONT']) && isset($_POST['CONTENTS']) && isset($_POST['DEADLINE']) && isset($_POST['GIVENTO']) && isset($_POST['STATUS']) && isset($_POST['OUTCOME']) && isset($_POST['NOTES']))
{ 
// sql insert query for the variables into the cases table
$query = "INSERT INTO cases(DRCVD, OCONT, CONTENTS, DEADLINE, GIVENTO,STATUS,OUTCOME, NOTES ) VALUES ('$DRCVD', '$OCONT', '$CONTENTS', '$DEADLINE', '$GIVENTO', '$STATUS', '$OUTCOME', '$NOTES')";
// sql query either processes or fails and outputs an error message
mysql_query($query) or die ('mysql_error');
}
 
 
 
 
// original department checkboxes
 
$query = "INSERT into origdepart (ACINTEG, CIVENG, ENRMGT, IA, OFFCAMP, PUBREL, UCS, ADSVC, CLUBS, ENGR, IACUC, OIA, RETRVR, UHS, AFSTDS, COMMONS, ERICSCH, IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWBD, AMERSTD, CSEE, FACSEN, IRB, ORL, SHRVR, USM, ANCSTD, CSST, FINSERV, IRC, OSP, SOCWRK, VART, ASCRV, CWIT, GALLRY, JCET, OTD, SOCY, VPA_F, ATHL, DANCE, GEOG, LIBRY, PHIL, SJP, VPACAFF, BIO, DEANAHSS, GEST, LRC, PHYS, STUAFF, VPFACAF, BKSTR, DEANCOEIT, GRAD, MAS, POLTSCI, STULIFE, VPIA, CAREER, DEANUE, GSA, MATH, POLICE, STUSIPSRV, VPIT, CASPR, DEANCNMS, GUESTSRV, MECHENG, PPLNT, TECHCTR, VPRDGS, CAST, DPET_CPS, HIST, MIPAR, PRES, TEI, WMCTR, CUERE, ECON, HLTHSCI, MLL, PROC, TELECOMM, WMSTD, CHEM, EDUC, HNRSCOL, MUSIC, PROV, THTR, CHEMENG, EHS, HREL, MYRHOF, PSYC, TRANSIT, CHPDM, ENGL, HRES, OAG, PUBPOL, TRNCTRS)  VALUES (";
 
if($ACINTEG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CIVENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ENRMGT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($IA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OFFCAMP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PUBREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($UCS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ADSVC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CLUBS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ENGR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($IACUC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OIA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($RETRVR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($UHS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($AFSTDS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($COMMONS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ERICSCH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($IS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($OIR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($R_PARK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($UMFNDN == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($ALREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($CONTED == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ESH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($IES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SGA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($UPWBD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($AMERSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CSEE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($FACSEN == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($IRB == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ORL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($SHRVR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($USM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ANCSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CSST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($FINSERV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($IRC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OSP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($SOCWRK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VART == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ASCRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CWIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GALLRY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($JCET == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($SOCY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPA_F == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ATHL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DANCE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GEOG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($LIBRY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PHIL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($SJP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPACAFF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($BIO == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANAHSS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GEST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($LRC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($PHYS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($STUAFF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPFACAF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($BKSTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($DEANCOEIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GRAD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if($MAS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($POLTSCI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($STULIFE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPIA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CAREER == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GSA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($MATH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($POLICE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($STUSIPSRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CASPR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($DEANCNMS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($GUESTSRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MECHENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PPLNT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($TECHCTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($VPRDGS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CAST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DPET_CPS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($HIST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MIPAR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($PRES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($TEI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($WMCTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CUERE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ECON == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($HLTHSCI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($MLL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PROC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($TELECOMM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($WMSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($CHEM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($EDUC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($HNRSCOL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MUSIC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PROV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($THTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CHEMENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($EHS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($HREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MYRHOF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($PSYC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if($TRANSIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CHPDM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($ENGL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($HRES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($OAG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($PUBPOL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($TRNCTRS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
//responsible offices
 
$query = "INSERT into respoff (DEANAHSS2, PRES2, VPIT2, DEANCNMS2, PROV2, VPRDGS2, DEANCOEIT2, VPA_F2, VPSA, DEANERK, VPDUE, DEANUE, VPIA2) VALUES (";
 
if($DEANAHSS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PRES2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if($VPIT2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANCNMS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($PROV2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPRDGS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANCOEIT2== "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPA_F2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($VPSA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANERK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($VPDUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($DEANUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($VPIA2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
 
// requests
 
$query = "INSERT into request (ADVISE, DRAFT, MEDIATE, REPORT, CONTACT, NEGOTIATE, REVIEW, RESEARCH, INVESTIGATE, COORDINATE, MEETING_ATTEND, PRESENTATION) VALUES (";
 
if($ADVISE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($DRAFT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MEDIATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($REPORT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($CONTACT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($NEGOTIATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($REVIEW == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($RESEARCH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($INVESTIGATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($COORDINATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($MEETING_ATTEND == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if($PRESENTATION == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
mysql_query($query) or die ('mysql_error');
 
 
// completed
 
$query = "INSERT into cases (COMPLETED) VALUES (";
 
if($COMPLETED == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
mysql_query($query) or die ('mysql_error');
 
// referred to
 
 
$query = "INSERT into cases (OAG3, WTP2, OTHER2) VALUES (";
 
if($OAG3 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($WTP2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($OTHER2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
mysql_query($query) or die ('mysql_error');
 
?>
</body>
</html>
 
[/color]

Re: php inserting problem

Posted: Fri Apr 18, 2008 11:46 am
by andrade1
The error that I receive is:


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWB

Re: php inserting problem

Posted: Fri Apr 18, 2008 11:54 am
by andym01480
EDIT: Sorry missed your post there, give me a mo.

Code: Select all

die (mysql_error());
and count the fields and the corresponding entries to check they are the same number - an awful lot! Haven't got the energy!!!!

Then post what is produced from the error

Re: php inserting problem

Posted: Fri Apr 18, 2008 12:05 pm
by andym01480
Echo the query and post it - count the number of fields in the first set of brackets and then the number of values in teh second - I bet they don't match.

Then we can talk about coding it more neatly and efficiently! Why so many fields in the db table? - that's huge!

Re: php inserting problem

Posted: Fri Apr 18, 2008 12:21 pm
by andrade1
counted all of them 116. How do I echo the query?

Re: php inserting problem

Posted: Fri Apr 18, 2008 1:08 pm
by andym01480
Line 999 after all those if statements it might be good to actually do the query!

Code: Select all

echo $query; //while debugging 
mysql_query($query) or die (' Origdept query'.mysql_error());
Line 1114

Code: Select all

echo $query; //while debugging 
mysql_query($query) or die (' respoff query'.mysql_error());
Post the browser o/p!

Re: php inserting problem

Posted: Fri Apr 18, 2008 2:25 pm
by andrade1
The browser output is:


Parse error: parse error, unexpected T_IS_EQUAL, expecting ',' or ')' on line 45

which is:

if(isset($ACINTEG == "1"))

and all the brackets appear to be there

Code: Select all

 
 
[color=#0000FF]<html>
<body>
 
<?php
 
// connection string
 
 
$con = mysql_connect("agagg", "agagg", "aadgg") or die("could not connect to server");
mysql_select_db("aggag", $con) or die('Sorry, could not connect to database');
 
$caseid = $_GET['id'];
 
 
// checks to see if the values have been set for all text fields
 
//delcare all posts as variables
 
$DRCVD = $_POST['DRCVD'];
$OCONT = $_POST['OCONT'];
$CONTENTS= $_POST['CONTENTS'];
$DEADLINE = $_POST['DEADLINE'];
$GIVENTO = $_POST['GIVENTO'];
$STATUS= $_POST['STATUS'];
$OUTCOME= $_POST['OUTCOME'];
$NOTES= $_POST['NOTES'];
 
 
if(isset ($_POST['DRCVD']) && isset($_POST['OCONT']) && isset($_POST['CONTENTS']) && isset($_POST['DEADLINE']) && isset($_POST['GIVENTO']) && isset($_POST['STATUS']) && isset($_POST['OUTCOME']) && isset($_POST['NOTES']))
{ 
// sql insert query for the variables into the cases table
$query = "INSERT INTO cases(DRCVD, OCONT, CONTENTS, DEADLINE, GIVENTO,STATUS,OUTCOME, NOTES ) VALUES ('$DRCVD', '$OCONT', '$CONTENTS', '$DEADLINE', '$GIVENTO', '$STATUS', '$OUTCOME', '$NOTES')";
// sql query either processes or fails and outputs an error message
echo $cases; 
mysql_query($query) or die ('origdepat query'.mysql_error());
}
 
 
 
 
// original department checkboxes
 
$query = "INSERT into origdepart (ACINTEG, CIVENG, ENRMGT, IA, OFFCAMP, PUBREL, UCS, ADSVC, CLUBS, ENGR, IACUC, OIA, RETRVR, UHS, AFSTDS, COMMONS, ERICSCH, IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWBD, AMERSTD, CSEE, FACSEN, IRB, ORL, SHRVR, USM, ANCSTD, CSST, FINSERV, IRC, OSP, SOCWRK, VART, ASCRV, CWIT, GALLRY, JCET, OTD, SOCY, VPA_F, ATHL, DANCE, GEOG, LIBRY, PHIL, SJP, VPACAFF, BIO, DEANAHSS, GEST, LRC, PHYS, STUAFF, VPFACAF, BKSTR, DEANCOEIT, GRAD, MAS, POLTSCI, STULIFE, VPIA, CAREER, DEANUE, GSA, MATH, POLICE, STUSIPSRV, VPIT, CASPR, DEANCNMS, GUESTSRV, MECHENG, PPLNT, TECHCTR, VPRDGS, CAST, DPET_CPS, HIST, MIPAR, PRES, TEI, WMCTR, CUERE, ECON, HLTHSCI, MLL, PROC, TELECOMM, WMSTD, CHEM, EDUC, HNRSCOL, MUSIC, PROV, THTR, CHEMENG, EHS, HREL, MYRHOF, PSYC, TRANSIT, CHPDM, ENGL, HRES, OAG, PUBPOL, TRNCTRS)  VALUES (";
 
if(isset($ACINTEG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CIVENG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ENRMGT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($IA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OFFCAMP == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PUBREL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($UCS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ADSVC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CLUBS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ENGR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($IACUC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OIA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($RETRVR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($UHS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($AFSTDS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($COMMONS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ERICSCH == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($IS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($OIR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($R_PARK == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($UMFNDN == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($ALREL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($CONTED == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ESH == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($IES == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OIT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if(isset($SGA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($UPWBD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($AMERSTD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CSEE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($FACSEN == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($IRB == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ORL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($SHRVR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($USM == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ANCSTD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset(CSST == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset(FINSERV == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($IRC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OSP == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($SOCWRK == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VART == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ASCRV == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CWIT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GALLRY == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($JCET == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OTD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($SOCY == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPA_F == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ATHL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DANCE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GEOG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($LIBRY == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PHIL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($SJP == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPACAFF == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($BIO == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANAHSS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GEST == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($LRC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($PHYS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($STUAFF == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPFACAF == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($BKSTR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($DEANCOEIT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GRAD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if(isset($MAS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($POLTSCI == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($STULIFE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPIA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CAREER == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANUE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GSA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($MATH == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($POLICE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if($STUSIPSRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPIT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CASPR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($DEANCNMS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($GUESTSRV == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MECHENG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PPLNT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($TECHCTR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($VPRDGS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CAST == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DPET_CPS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($HIST == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MIPAR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($PRES == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($TEI == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($WMCTR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CUERE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ECON == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($HLTHSCI == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($MLL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PROC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($TELECOMM == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($WMSTD == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($CHEM == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($EDUC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($HNRSCOL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MUSIC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PROV == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($THTR == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CHEMENG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($EHS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($HREL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MYRHOF == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($PSYC == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if(isset($TRANSIT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CHPDM == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($ENGL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($HRES == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($OAG == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($PUBPOL == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($TRNCTRS == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
$result = mysql_query($query);
echo $query; 
mysql_query($query) or die ('origdepart query'.mysql_error());
 
//responsible offices
 
$query = "INSERT into respoff (DEANAHSS2, PRES2, VPIT2, DEANCNMS2, PROV2, VPRDGS2, DEANCOEIT2, VPA_F2, VPSA, DEANERK, VPDUE, DEANUE, VPIA2) VALUES (";
 
if(isset($DEANAHSS2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PRES2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
 
if(isset($VPIT2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANCNMS2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($PROV2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPRDGS2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANCOEIT2== "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPA_F2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($VPSA == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANERK == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($VPDUE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($DEANUE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($VPIA2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
$result = mysql_query($query);
echo $query; 
mysql_query($query) or die ('respoff query'.mysql_error());
 
 
// requests
 
$query = "INSERT into request (ADVISE, DRAFT, MEDIATE, REPORT, CONTACT, NEGOTIATE, REVIEW, RESEARCH, INVESTIGATE, COORDINATE, MEETING_ATTEND, PRESENTATION) VALUES (";
 
if(isset($ADVISE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($DRAFT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MEDIATE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($REPORT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($CONTACT == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($NEGOTIATE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($REVIEW == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($RESEARCH == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($INVESTIGATE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($COORDINATE == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($MEETING_ATTEND == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
 
if(isset($PRESENTATION == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
$result = mysql_query($query);
echo $query; 
mysql_query($query) or die ('request query'.mysql_error());
 
 
// completed
 
$query = "INSERT into cases (COMPLETED) VALUES (";
 
if(isset($COMPLETED == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
$result = mysql_query($query);
echo $query; 
mysql_query($query) or die ('cases query'.mysql_error());
 
// referred to
 
 
$query = "INSERT into cases (OAG3, WTP2, OTHER2) VALUES (";
 
if(isset($OAG3 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($WTP2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
if(isset($OTHER2 == "1"))
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
 
$result = mysql_query($query);
echo $query; 
mysql_query($query) or die ('cases query'.mysql_error());
 
?>
</body>
</html>
 
 
 
[/color]

Re: php inserting problem

Posted: Fri Apr 18, 2008 2:38 pm
by andym01480
Take a look at my post #5

Your if statements are wrong! Make them like the one I showed!
Your trying to check two things in one wrongly.
Before you go through hundreds of wrong if statements...
Where are those variables coming from? If they are form input we can tidy the whole thing up into a few lines of code. Let me know and I will point you in the right direction

Re: php inserting problem

Posted: Fri Apr 18, 2008 3:13 pm
by andrade1
I got this as an output after I put the if statements back:

INSERT into origdepart (ACINTEG, CIVENG, ENRMGT, IA, OFFCAMP, PUBREL, UCS, ADSVC, CLUBS, ENGR, IACUC, OIA, RETRVR, UHS, AFSTDS, COMMONS, ERICSCH, IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWBD, AMERSTD, CSEE, FACSEN, IRB, ORL, SHRVR, USM, ANCSTD, CSST, FINSERV, IRC, OSP, SOCWRK, VART, ASCRV, CWIT, GALLRY, JCET, OTD, SOCY, VPA_F, ATHL, DANCE, GEOG, LIBRY, PHIL, SJP, VPACAFF, BIO, DEANAHSS, GEST, LRC, PHYS, STUAFF, VPFACAF, BKSTR, DEANCOEIT, GRAD, MAS, POLTSCI, STULIFE, VPIA, CAREER, DEANUE, GSA, MATH, POLICE, STUSIPSRV, VPIT, CASPR, DEANCNMS, GUESTSRV, MECHENG, PPLNT, TECHCTR, VPRDGS, CAST, DPET_CPS, HIST, MIPAR, PRES, TEI, WMCTR, CUERE, ECON, HLTHSCI, MLL, PROC, TELECOMM, WMSTD, CHEM, EDUC, HNRSCOL, MUSIC, PROV, THTR, CHEMENG, EHS, HREL, MYRHOF, PSYC, TRANSIT, CHPDM, ENGL, HRES, OAG, PUBPOL, TRNCTRS) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', origdepart queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWB

The variables come from an html form and if they are checked they go into a table and if they are not checked I don't care where they go.