php inserting problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

php inserting problem

Post 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]
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: php inserting problem

Post 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.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: php inserting problem

Post 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.
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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', ";
}
?
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: php inserting problem

Post 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:
andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

Re: php inserting problem

Post 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]
andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

Re: php inserting problem

Post 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
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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!
andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

Re: php inserting problem

Post by andrade1 »

counted all of them 116. How do I echo the query?
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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!
andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

Re: php inserting problem

Post 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]
User avatar
andym01480
Forum Contributor
Posts: 390
Joined: Wed Apr 19, 2006 5:01 pm

Re: php inserting problem

Post 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
andrade1
Forum Newbie
Posts: 14
Joined: Fri Apr 18, 2008 9:16 am

Re: php inserting problem

Post 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.
Post Reply