Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Error message "error in your SQL syntax."

SQL innerHTML syntax

  • Please log in to reply
3 replies to this topic

#1 thesquirrel16

thesquirrel16

    CC Newcomer

  • Just Joined
  • PipPip
  • 12 posts

Posted 22 April 2007 - 01:59 AM

Hi, I have no idea what this error means, but I received it after putting in the variables near the top and the php code for the submit button:

the error 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 ' , , , , , , , , , , , , , , , , , , , , , )' at line 1

and my code is:


<?php
$title = $_POST["txttitle"];
$host = $_POST["txthost"];
$place = $_POST["txtplace"];
$startyr = $_POST[substr("date_start" ,0 , 4)];
$startmm = $_POST[substr("date_start" , 5 , 2)];
$startday = $_POST[substr("date_start" , 8 , 2)];
$endyr = $_POST[substr("date_end" , 0 , 4)];
$endmm = $_POST[substr("date_end" , 5 , 2)];
$endday = $_POST[substr("date_end" , 8 , 2)];
$description = $_POST["txtdescription"];
$st_timeap = $_POST["startap"];
$st_timehr = $_POST["txthour"];
$st_timemin = $_POST["txtmin"];
$end_timeap = $_POST["endap"];
$end_timehr = $_POST["txtendhr"];
$end_timemin = $_POST["txtendmin"];
$weblink = $_POST["txtweblink"];
$cost = $_POST["txtcost"];
$category = $_POST["category"];
//sif (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

</script>
<script language="JavaScript" src="overlib_mini.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Event Form</title>
<style type="text/css">

.ds_box {
background-color: #FFF;
border: 1px solid #000;
position: absolute;
z-index: 32767;
}

.ds_tbl {
background-color: #FFF;
}

.ds_head {
background-color: #333;
color: #FFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 13px;
font-weight: bold;
text-align: center;
letter-spacing: 2px;
}

.ds_subhead {
background-color: #CCC;
color: #000;
font-size: 12px;
font-weight: bold;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
width: 32px;
}

.ds_cell {
background-color: #EEE;
color: #000;
font-size: 13px;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
padding: 5px;
cursor: pointer;
}

.ds_cell:hover {
background-color: #F3F3F3;
} /* This hover code won't work for IE */

body {
background-color: #FFFFFF;
margin-top: 10px;
}
.style2 {
font-size: 36px;
color: #000000;
}
body,td,th {
color: #ECE9D8;
}
.style4 {color: #400040}
.style7 {color: #FFFFFF; font-size: 46px;}
.style11 {
color: #400040;
font-family: "Times New Roman", Times, serif;
font-size: 14;
font-weight: bold;
}
.style13 {color: #400040; font-size: 14px; }
.style15 {color: #400040; font-size: 14; }
.style26 {color: #400040; font-size: 14; font-weight: bold; }
.style27 {color: #F3F3F3}
.style28 {
color: #000000;
font-size: 12px;
}
.style29 {color: #F15E51}
</style>
</head>
<body>

<table class="ds_box" cellpadding="0" cellspacing="0" id="ds_conclass" style="display: none;">
<tr><td id="ds_calclass">
</td></tr>
</table>

<script type="text/javascript">
// <!-- <![CDATA[

// Project: Dynamic Date Selector (DtTvB) - 2006-03-16
// Script featured on JavaScript Kit- JavaScript Kit- Comprehensive JavaScript, DHTML, CSS tutorials and over 400+ free JavaScripts!
// Code begin...
// Set the initial date.
var ds_i_date = new Date();
ds_c_month = ds_i_date.getMonth() + 1;
ds_c_year = ds_i_date.getFullYear();

// Get Element By Id
function ds_getel(id) {
return document.getElementById(id);
}

// Get the left and the top of the element.
function ds_getleft(el) {
var tmp = el.offsetLeft;
el = el.offsetParent
while(el) {
tmp += el.offsetLeft;
el = el.offsetParent;
}
return tmp;
}
function ds_gettop(el) {
var tmp = el.offsetTop;
el = el.offsetParent
while(el) {
tmp += el.offsetTop;
el = el.offsetParent;
}
return tmp;
}

// Output Element
var ds_oe = ds_getel('ds_calclass');
// Container
var ds_ce = ds_getel('ds_conclass');

// Output Buffering
var ds_ob = '';
function ds_ob_clean() {
ds_ob = '';
}
function ds_ob_flush() {
ds_oe.innerHTML = ds_ob;
ds_ob_clean();
}
function ds_echo(t) {
ds_ob += t;
}

var ds_element; // Text Element...

var ds_monthnames = [
'January', 'February', 'March', 'April', 'May', 'June',
'July', 'August', 'September', 'October', 'November', 'December'
]; // You can translate it for your language.

var ds_daynames = [
'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'
]; // You can translate it for your language.

// Calendar template
function ds_template_main_above(t) {
return '<table cellpadding="3" cellspacing="1" class="ds_tbl">'
+ '<tr>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_py();"><<</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();"><</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_hi();" colspan="3">[Close]</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_nm();">></td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">>></td>'
+ '</tr>'
+ '<tr>'
+ '<td colspan="7" class="ds_head">' + t + '</td>'
+ '</tr>'
+ '<tr>';
}

function ds_template_day_row(t) {
return '<td class="ds_subhead">' + t + '</td>';
// Define width in CSS, XHTML 1.0 Strict doesn't have width property for it.
}

function ds_template_new_week() {
return '</tr><tr>';
}

function ds_template_blank_cell(colspan) {
return '<td colspan="' + colspan + '"></td>'
}

function ds_template_day(d, m, y) {
return '<td class="ds_cell" onclick="ds_onclick(' + d + ',' + m + ',' + y + ')">' + d + '</td>';
// Define width the day row.
}

function ds_template_main_below() {
return '</tr>'
+ '</table>';
}

// This one draws calendar...
function ds_draw_calendar(m, y) {
// First clean the output buffer.
ds_ob_clean();
// Here we go, do the header
ds_echo (ds_template_main_above(ds_monthnames[m - 1] + ' ' + y));
for (i = 0; i < 7; i ++) {
ds_echo (ds_template_day_row(ds_daynames[i]));
}
// Make a date object.
var ds_dc_date = new Date();
ds_dc_date.setMonth(m - 1);
ds_dc_date.setFullYear(y);
ds_dc_date.setDate(1);
if (m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10 || m == 12) {
days = 31;
} else if (m == 4 || m == 6 || m == 9 || m == 11) {
days = 30;
} else {
days = (y % 4 == 0) ? 29 : 28;
}
var first_day = ds_dc_date.getDay();
var first_loop = 1;
// Start the first week
ds_echo (ds_template_new_week());
// If sunday is not the first day of the month, make a blank cell...
if (first_day != 0) {
ds_echo (ds_template_blank_cell(first_day));
}
var j = first_day;
for (i = 0; i < days; i ++) {
// Today is sunday, make a new week.
// If this sunday is the first day of the month,
// we've made a new row for you already.
if (j == 0 && !first_loop) {
// New week!!
ds_echo (ds_template_new_week());
}
// Make a row of that day!
ds_echo (ds_template_day(i + 1, m, y));
// This is not first loop anymore...
first_loop = 0;
// What is the next day?
j ++;
j %= 7;
}
// Do the footer
ds_echo (ds_template_main_below());
// And let's display..
ds_ob_flush();
// Scroll it into view.
ds_ce.scrollIntoView();
}

// A function to show the calendar.
// When user click on the date, it will set the content of t.
function ds_sh(t) {
// Set the element to set...
ds_element = t;
// Make a new date, and set the current month and year.
var ds_sh_date = new Date();
ds_c_month = ds_sh_date.getMonth() + 1;
ds_c_year = ds_sh_date.getFullYear();
// Draw the calendar
ds_draw_calendar(ds_c_month, ds_c_year);
// To change the position properly, we must show it first.
ds_ce.style.display = '';
// Move the calendar container!
the_left = ds_getleft(t);
the_top = ds_gettop(t) + t.offsetHeight;
ds_ce.style.left = the_left + 'px';
ds_ce.style.top = the_top + 'px';
// Scroll it into view.
ds_ce.scrollIntoView();
}

// Hide the calendar.
function ds_hi() {
ds_ce.style.display = 'none';
}

// Moves to the next month...
function ds_nm() {
// Increase the current month.
ds_c_month ++;
// We have passed December, let's go to the next year.
// Increase the current year, and set the current month to January.
if (ds_c_month > 12) {
ds_c_month = 1;
ds_c_year++;
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the previous month...
function ds_pm() {
ds_c_month = ds_c_month - 1; // Can't use dash-dash here, it will make the page invalid.
// We have passed January, let's go back to the previous year.
// Decrease the current year, and set the current month to December.
if (ds_c_month < 1) {
ds_c_month = 12;
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the next year...
function ds_ny() {
// Increase the current year.
ds_c_year++;
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the previous year...
function ds_py() {
// Decrease the current year.
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Format the date to output.
function ds_format_date(d, m, y) {
// 2 digits month.
m2 = '00' + m;
m2 = m2.substr(m2.length - 2);
// 2 digits day.
d2 = '00' + d;
d2 = d2.substr(d2.length - 2);
// YYYY-MM-DD
return y + '-' + m2 + '-' + d2;
}

// When the user clicks the day.
function ds_onclick(d, m, y) {
// Hide the calendar.
ds_hi();
// Set the value of it, if we can.
if (typeof(ds_element.value) != 'undefined') {
ds_element.value = ds_format_date(d, m, y);
// Maybe we want to set the HTML in it.
} else if (typeof(ds_element.innerHTML) != 'undefined') {
ds_element.innerHTML = ds_format_date(d, m, y);
// I don't know how should we display it, just alert it to user.
} else {
alert (ds_format_date(d, m, y));
}
}

// And here is the end.

// ]]> -->
</script>
</head>

<body>
<p> </p>
<table width="949" border="0" cellpadding="0" cellspacing="0" bordercolor="#400040" bgcolor="#762022">
<!--DWLayoutTable-->
<tr>
<td width="141" height="87"> </td>
<td width="490" valign="top" class="style7">Aggie Corner
<hr /></td>
<td width="121"> </td>
<td width="52"> </td>
<td width="145" rowspan="2" valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="55"> </td>
<td colspan="2" rowspan="4" valign="top"><table border="2" bordercolor="#762022" bordercolordark="#762022" bordercolorlight="#762022" width="100%" cellpadding="0" cellspacing="0" bgcolor="#F3F3F3">
<!--DWLayoutTable-->
<tr>
<td height="43" colspan="2" valign="top"><span class="style2">Upcoming Event Form </span></td>
<td width="74"></td>
</tr>
<tr>
<td width="47" height="845"> </td>
<td width="480" valign="top" bgcolor="#F3F3F3"> <label><br />
</label>
<p align="right" class="style4">
<label><span class="style11">Title:
<input name="txttitle" type="text" size="60" />
</span></label>
</p>
<p align="right" class="style11">
<label>Host: </label>
<input name="txthost" type="text" size="60" />
</p>
<p align="right" class="style11">
<label>Place:</label>
<input name="txtplace" type="text" size="60" />
</p>
<p align="right" class="style11">Start Date:
<input name="date_start" style="cursor: text" onclick="ds_sh(this);" size="60" readonly="readonly" />
</p>
<p align="right" class="style11">End Date:
<input name="date_end" style="cursor: text" onclick="ds_sh(this);" size="60" readonly="readonly" />
</p>
<p class="style11">
<label><span class="style27">-----</span>Description
<textarea name="txtdescription"></textarea>
</label>
<p class="style11">
<label>Start Time:
Hr:
<input name="txthour" type="text" size="2" />
</label>
<label>Min:
<input name="txtmin" type="text" size="2" />
</label>
<label>Am/Pm
<select name="startap" size="">
<option>Am</option>
<option>Pm</option>
</select>
</label>
<p class="style11">
<label><span class="style27">_</span>End Time:
Hr:
<input name="txtendhr" type="text" size="2" />
</label>
<label>Min:
<input name="txtendmin" type="text" size="2" />
</label>
<label>Am/Pm
<select name="endap" size="">
<option>Am</option>
<option>Pm</option>
</select>
</label>
<p class="style11">
<label></label>
<label><span class="style27">------_</span>Catagory:
<select name="category">
<option value="0">Select Category (click)</option>
<option value="1">Athletic event</option>
<option value="2">Entertainment</option>
<option value="3">Fund Raiser</option>
<option value="4">Garage Sale</option>
<option value="5">Just for fun</option>
<option value="6">Lecture</option>
<option value="7">Organization Meeting</option>
<option value="8">Performances</option>
<option value="9">Recreational</option>
<option value="10">Sales Promotion</option>
<option value="11">Student athletics</option>
<option value="12">Trips</option>
<option value="13">Tutoring</option>
<option value="14">Volunteer work</option>
<option value="15">Other</option>
</select>
</label>
</p>
<p class="style4">
<span class="style11">
<label>
<div align="right">
</label>
</span>
<span class="style26">
<label></label>
</span>
<span class="style26">
<label></label>
</span>
<span class="style4"><strong>
<label></label>
</strong>
<label></label>
</span>
<label><div align="right" class="style11">Weblink::
<input name="txtweblink" type="text" size="60" height="" />
</div>
</label>
<p class="style11">
<label>
<div align="left"><span class="style27">----------_Cost</span><span class="style11">Cost:</span>
<input name="txtcost" type="text" size="10" />
</label>
<p align="left" class="style11">
<label></label>
This section is optional, it is specifically for those events which have sign up dates.</p>
<p align="left" class="style11">If has a sign-up date check this box
<label>
<input type="checkbox" name="checkbox" value="checkbox" />
</label>
</p>
<p align="left" class="style11">Start Date:
<input onclick="ds_sh(this);" name="date_start2" readonly="readonly" style="cursor: text" />
End Date:
<input onclick="ds_sh(this);" name="date_end2" readonly="readonly" style="cursor: text" />
</p>
<p align="left" class="style11">
<label></label>
<label> Registration Start Time:

<input name="txtregstarthr" type="text" size="2" />
</label>
<label>:
<input name="txtregstartmin" type="text" size="2" />
</label>
<label>Am/Pm
<select name="regstartap" size="">
<option>Am</option>
<option>Pm</option>
</select>
</label>
</p>
<p align="left" class="style11">
<label><span class="style27">_</span>Registration End Time: </label>
<label>
<input name="regendhr" type="text" size="2" />
:
<input name="regendmin" type="text" size="2" />
</label>
<label>Am/Pm
<select name="regendap" size="">
<option>Am</option>
<option>Pm</option>
</select>
</label>
</p>
<p align="left">
<span class="style11">
<label>Additional sign up information:</label>
</span><span class="style26">
<label></label>
</span><span class="style26"><label></label>
</span><span class="style15"><label></label>
</span><span class="style13"><label></label>
</span><span class="style4"><label> </label>
</span>
<label>
<textarea name="txtaddinfo"></textarea>
</label>
</p>
<label></label>
<label>
<div align="center">
<p>
<input type="submit" name="Submit" value="Submit" />
<?php
$server = "mysql7.easycgi.com";
$user = "angela";
$pw = "angela_123";
$con = mysql_connect($server , $user, $pw);

if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("eventdb", $con);

mysql_query("INSERT INTO event (title, host, place, startyr, startmm, startday, endyr, endmm, endday, st_timeap, st_timehr, st_timemin, end_timeap, end_timehr, end_timemin, description, weblink, cost, category, color, extra1, extra2, extra3) VALUES ($title, $host, $place, $startyr, $startmm, $startday, $endyr, $endmm, $endday, $st_timeap, $st_timehr, $st_timemin, $end_timeap, $end_timehr, $end_timemin, $description, $weblink, $cost, $category, $cost, $cost, $cost, $cost )") or die(mysql_error());
mysql_close($con);
?>
<input type="submit" name="Submit2" value="Cancel" />
</p>
<p class="style28">By clicking submit you are agreeing to the terms and agreements of aggiecorner.com </p>
</div> </label></td>
<td></td>
</tr>
<tr>
<td height="63"> </td>
<td> </td>
<td></td>
</tr>



<!--DWLayoutTable-->
















</table></td>
<td> </td>
</tr>



<tr>
<td height="2"></td>
<td colspan="2" rowspan="3" valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="249" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#762022" bordercolordark="#762022">
<!--DWLayoutTable-->

<tr>
<td width="141" height="249" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>



</table></td>
</tr>
<tr>
<td height="649"> </td>
</tr>
</table>
</body>
</html>





any how... any help would be tremendously appreciated!
  • 0

#2 thesquirrel16

thesquirrel16

    CC Newcomer

  • Just Joined
  • PipPip
  • 12 posts

Posted 22 April 2007 - 03:00 PM

ok so I narrowed it down to this line of code: mysql_query("INSERT INTO event (title, host, place) VALUES ($title, $host, $place)") or die(mysql_error()); but i don't know whats wrong with it.... any thoughts?
  • 0

#3 Guest_rubia126_*

Guest_rubia126_*
  • Guest

Posted 18 May 2007 - 01:54 AM

hi thr

well seriously i was having the same sort of issues few monhts a go and they really make me crazy oraclplace.com could be a good resource of help for u cause they also help me out

good luck
  • 0

#4 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 18 May 2007 - 04:48 AM

I only see one SQL statement

INSERT INTO event 
(title, host, place, startyr, startmm, startday, endyr, 
endmm, endday, st_timeap, st_timehr, st_timemin, end_timeap, 
end_timehr, end_timemin, description, weblink, cost, 
category, color, extra1, extra2, extra3) 
VALUES ($title, $host, $place, $startyr, $startmm, 
$startday, $endyr, $endmm, $endday, $st_timeap, 
$st_timehr, $st_timemin, $end_timeap, $end_timehr, 
$end_timemin, $description, $weblink, $cost, $category, 
$cost, $cost, $cost, $cost )"

Not the one you mentioned above. I see no errors though. You have no ending ; on it though which could cause the problem:

INSERT INTO event 
(title, host, place, startyr, startmm, startday, endyr, 
endmm, endday, st_timeap, st_timehr, st_timemin, end_timeap, 
end_timehr, end_timemin, description, weblink, cost, 
category, color, extra1, extra2, extra3) 
VALUES ($title, $host, $place, $startyr, $startmm, 
$startday, $endyr, $endmm, $endday, $st_timeap, 
$st_timehr, $st_timemin, $end_timeap, $end_timehr, 
$end_timemin, $description, $weblink, $cost, $category, 
$cost, $cost, $cost, $cost );

  • 0





Also tagged with one or more of these keywords: SQL, innerHTML, syntax

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download