i have check and there are 3 coloums and 3 values whats wrong here's the error
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
INSERT into vb3_sotw
(id,winner,week,url_image)
VALUES
('',
'asddsa'
'a'
'asdfsd')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
heres my code
Code:
if ($_POST['do'] == 'sqltable')
{
globalize($_POST, array(
'winner',
'week_no',
'url_image'
));
$DB_site->query("
INSERT into " . TABLE_PREFIX . "sotw
(winner,week_no,url_image)
VALUES
(
'" . addslashes("$winner") . "'
'" . addslashes("$week_no") . "'
'" . addslashes("$url_image") . "')
");
print_stop_message('completed_database_backup_successfully');
}
also my table has the coloums
id,winner,week,url_image
can any please help this is doing my head in!!! :disappointed: