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']) . "'
)");
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']) . "'
)");