I am getting a sql error
Here's the php
PHP Code:
$vbulletin->input->clean_array_gpc('p', array(
'name' => TYPE_STR,
'email' => TYPE_STR,
'text' => TYPE_STR,
'testid' => TYPE_INT
));
$db->query_write("
UPDATE " . TABLE_PREFIX . "testimonials SET
name = '" . $db->escape_string($vbulletin->GPC['name']) . "',
email = '" . $db->escape_string($vbulletin->GPC['email']) . "',
text = '" . $db->escape_string($vbulletin->GPC['text']) . "',
WHERE testid = " . $vbulletin->GPC['testid'] . "
");
Here's the sql error
Code:
UPDATE testimonials SET
name = 'erg4ewg',
email = 'ewgwgew',
text = 'gewgewrg <b>egeg</b>',
WHERE testid = 1;
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 'WHERE testid = 1' at line 5
Error Number : 1064