adding a row...

stew

hey guys, i was wondering if you could help me here...

the following code is adding a new row to a table in a database, however, when it is called up it says that there is an error in the SQL syntax in line 1

<?php

include ("connect.php"); 

if ($REQUEST_METHOD=="POST") { 
        # double-up apostrophes 
        $gig = str_replace("'","''",$gig);  

	$SQL = " INSERT INTO gigs "; 
        $SQL = $SQL . " (with, place, price, info, tickets, day, month, year, date, ticketmaster, ticketweb, wayahead, type) VALUES "; 
        $SQL = $SQL . " ('$with','$place','$price','$info','$tickets','$day','$month','$year','$doors','$date','$ticketmaster','$ticketweb','$wayahead','$type') "; 

$rock = mysql_db_query($db,"$SQL",$cid);
if (!$rock) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    } else {
echo ("<P><B>New gig Added - you the man!</B></P>\n
       <p>click
	<a href=submitgig.php>here</a> to add another gig.</p>
	oh and neil, you are a wank!"); }
    } 
mysql_close($cid);
?>

any ideas of what is going wrong in this script?

Lars_Berg

It could be a problem with reserved words. e.g. with.

Lars_Berg

What does the error message say more exactly.

stew

the exact error is

" ERROR: You have an error in your SQL syntax near 'with, place, price, info, tickets, day, month, year, date, ticketmaster, ticketw' at line 1 INSERT INTO gigs (with, place, price, info, tickets, day, month, year, date, ticketmaster, ticketweb, wayahead, type) VALUES ('','','','','','1','2','2003','','2003-02-01','','','','Live') "

i was thinking that it might be the whole reserved words thing too, but i use a similar script on another site and its fine with the day/date variable things...

is there a limit to the number of variables that can be passed from script to script?

Lars_Berg

With is a reserved word and the fact that message says 'at with' indicates a problem with with. I'd change the name.