[RESOLVED] MySQL query error

AndyEarley

Hi guys, back again..

right, problem here with inserting code into my database. It's giving me this message..

"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 4"

and here is the code...

<?php
require 'dbp.inc.php';

$db = mysql_connect('localhost', 'root') or
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db('carhire_website') or die(mysql_error($db));

$query = 'INSERT INTO vehicle
        (vehicle_id, make, model, colour, price, stock, description)
    VALUES
        ("01", "Ford", "Focus", "Blue", "380.93", "40", "Totton"),';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Success!';
?>

Help!

halojoy

you have an extra comma at the end
),';

Also you should not put quotes around INTEGER or NUMBER fields values
But if some of those numbers are VARCHAR or TEXT fields
then you should use quotes
01, "Ford", "Focus", "Blue", 380.93, 40, "Totton"
id, price, stock may be INTEGER/FLOAT fields

AndyEarley

legend! i love ya! cheers haha.

bradgrafelman

AndyEarley: I've moved your posts into a new thread (and marked it resolved), as the thread you originally posted in is dediced to PHP parse errors - not SQL query errors.

halojoy

AndyEarley;10943032 wrote:
legend! i love ya! cheers haha.

Thanks. It was not much.
But you make me happy.
🙂