Log in

View Full Version : Help with sql error


harmor19
03-21-2006, 05:14 PM
Here's the error

Invalid SQL:

INSERT INTO hosting_plans
(
title,
posts,
webspace,
transfer,
email,
ftp,
subdomain,
databases,
addon,
parked
) VALUES (
'Test',
'200',
'1000',
'70000',
'5',
'5',
'5',
'5',
'5'
);

MySQL Error : 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 'databases,
addon,
parked
) VALUES (
'Test',


Here's the code


$db->query_write("
INSERT INTO " . TABLE_PREFIX . "hosting_plans
(
title,
posts,
webspace,
transfer,
email,
ftp,
subdomain,
databases,
addon,
parked
) VALUES (
'" . $db->escape_string($vbulletin->GPC['title']) . "',
'" . $db->escape_string($vbulletin->GPC['posts']) . "',
'" . $db->escape_string($vbulletin->GPC['webspace']) . "',
'" . $db->escape_string($vbulletin->GPC['bandwidth']) . "',
'" . $db->escape_string($vbulletin->GPC['email']) . "',
'" . $db->escape_string($vbulletin->GPC['subdomains']) . "',
'" . $db->escape_string($vbulletin->GPC['databases']) . "',
'" . $db->escape_string($vbulletin->GPC['addon']) . "',
'" . $db->escape_string($vbulletin->GPC['parked']) . "'
)");