Jump to content

error


searls03

Recommended Posts

can anyone help me find out what is wrong with this query?

<?php
if(isset($_POST['save']))
{  

   $event = $_POST['event'];
   $startdate = $_POST['startdate'];
   $enddate = $_POST['enddate'];
   $description = $_POST['description'];
      $location = $_POST['location'];
      $month = $_POST['month'];
        $title1 = $_POST['title1'];
        $title2 = $_POST['title2'];
        $title3 = $_POST['title3'];
        $title4 = $_POST['title4'];
        $title5 = $_POST['title5'];
        $title6 = $_POST['title6'];
        $title7 = $_POST['title7'];
        $title8 = $_POST['title8'];
        $date1 = $_POST['date1'];
        $date2 = $_POST['date2'];
        $date3 = $_POST['date3'];
        $date4 = $_POST['date4'];
        $date5 = $_POST['date5'];
        $date6 = $_POST['date6'];
        $date7 = $_POST['date7'];
        $date8 = $_POST['date8'];
        $subevent1 = $_POST['subevent1'];
        $subevent2 = $_POST['subevent2'];
        $subevent3 = $_POST['subevent3'];
        $subevent4 = $_POST['subevent4'];
        $subevent5 = $_POST['subevent5'];
        $subevent6 = $_POST['subevent5'];
        $subevent7 = $_POST['subevent6'];
        $subevent8 = $_POST['subevent7'];
        $price1 = $_POST['price1'];
        $price2 = $_POST['price2'];
        $price3 = $_POST['price3'];
        $price4 = $_POST['price4'];
        $price5 = $_POST['price5'];
        $price6 = $_POST['price6'];
        $price7 = $_POST['price7'];
        $price8 = $_POST['price8'];
        $month2 = $_POST['month2'];
		 $month_num = $_POST['month_num'];
        $day = $_POST['day'];
        $year = $_POST['year'];




  


    $q = "UPDATE Registration Set event='$event', startdate='$startdate', enddate='$enddate', description='$description', location='$location', month='$month, title1='$title1', title2='$title2', title3='$title3', title4='$title4', title5='$title5', title6='$title6', title7='$title7', title8='$title8', date1='$date1', date2='$date2', date3='$date3', date4='$date4', date5='$date5', date6='$date6', date7='$date7', date8='$date8', subevent1='$subevent1', subevent2='$subevent2', subevent3='$subevent3', subevent4='$subevent4', subevent5='$subevent5', subevent6='$subevent6', subevent7='$subevent7', subevent8='$subevent8', price1='$price1', price2='$price2', price3='$price3', price4='$price4', price5='$price5', price6='$price6', price7='$price7', price8='$price8', month2='$month2', shutoff='$shutoff', month_num='$month_num', day='$day', year='$year' Where eventid='eventid'"; $sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}

  
  

?>

 

errror 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 'Campout', title2='', title3='', title4='', title5='', title6='', title7='', titl' at line 1

Link to comment
https://forums.phpfreaks.com/topic/235452-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.