So......another problem.

I have a form that when submitted adds the data to a database. I have at least 2 other forms like this within my site and they work perfectly . However this one doesn't, the code is, as far as i can see, exactly the same as the other forms (with the table data etc changed). The error i get is:

Couldn't add data to "reviews" table: 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 'show, body, rating) values('Stoot', 'Hello', 'Hellooo', '7'


The code i'm using is:

PHP Code:

include("config.php");


$name_submit = $_POST['name'];
$show_submit = $_POST['show'];
$body_submit = $_POST['body'];
$rating_submit = $_POST['rating'];
    
if ($name_submit == "" OR $show_submit == "" OR $body_submit == "" OR $rating_submit == "") {
    
print "You must enter something in each field!";
print "<br>";
print "<br>";
print "<a href = \"javascript:history.back(-1)\">Return and correct...</a>";


} else {


$query = "INSERT INTO reviews ( name, show, body, rating)
            values('$name_submit', '$show_submit', '$body_submit', '$rating_submit')";
            
mysql_query($query)
or die ("Couldn't add data to \"reviews\" table: "
.mysql_error() );


print "Your review has been submitted.  Thanks!";
print "<br>";
print "<br>";
print "<a href = \"gigs.php?skin=$skin\">Back to Gigs listings</a><br><br>";

} 


I really can't figure it out, so any help would be great.
Sorry for keeping asking questions. Cheers

Stoot

It sounds like it's not finding the right columns in the reviews table or else the reviews table itself doesn't exist. Did you double check them?

The only other thing I suggest is to try removing the blank space before the word name in

PHP Code:

$query = "INSERT INTO reviews ( name, show, body, rating) values('$name_submit', '$show_submit', '$body_submit', '$rating_submit')"; 


How are you connected? You sure you don't need a DB pointer as an arguament to your query? whats in your config.php, and whats the tables setup?

Config.php:

PHP Code:

<?php

$link = mysql_connect("localhost", "XXX", "XXXXX");
if (! $link)
    die("Couldn't connect to MySQL");
    
mysql_select_db("afi") or die ("Couldn't open database");


?>

The table structure is:

Reviews
id
name
show
body
rating

I've recreated the table and checked it so many times. The config.php setup HAS to be fine else the rest of the site wouldn't work, but it does.

If you want to check it out properly, the url is www.tearsofjoy.co.uk go to 'Gigs' then 'Submit Review'

Ugh this is really annoying me.

show is a reserved word (it can't be a field name). Also, you may want try replacing mysql_query($query) with mysql_query($query,$link).

You're the man WebwoRRks!!!! That's what did it. I changed 'show' to 'gig' and it worked fine. Thanks everyone for their help. woo

You can still use 'show' as a field name, you just have to surround it by backticks,

INSERT INTO table SET `show`='data'

But I'm like you, I'd rather rename it then have those ugly backticks everywhere ><

plus its just plain naughty chroder