Amy1980 Posted December 30, 2006 Share Posted December 30, 2006 Hi.I have problem with MySQL DB. I have my own ;D Guestbook scropt, and I wanna to add to db users browser. I created table but now I get error:[code]Error, query failed. Column count doesn't match value count at row 1[/code]What is wrong? Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/ Share on other sites More sharing options...
dbo Posted December 30, 2006 Share Posted December 30, 2006 Show the code that generates that error. Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150092 Share on other sites More sharing options...
Amy1980 Posted December 30, 2006 Author Share Posted December 30, 2006 [code] // prepare the query string $browser = $_SERVER['HTTP_USER_AGENT']; $query = "INSERT INTO guestbook (name, email, url, message, entry_date) " . "VALUES ('$name', '$email', '$url', '$message', '$browser', current_date)";[/code]TABLE[code]browser varchar(255) latin2_general_ci No [/code] Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150098 Share on other sites More sharing options...
AV1611 Posted December 30, 2006 Share Posted December 30, 2006 $query = "INSERT INTO guestbook (`name`, `email`, `url`, `message`,`YOUAREMISSINGBROWSERFILEDHERE`, `entry_date`) VALUES ('$name', '$email', '$url', '$message', '$browser', current_date)"; Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150101 Share on other sites More sharing options...
dbo Posted December 30, 2006 Share Posted December 30, 2006 Grats. Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150104 Share on other sites More sharing options...
Amy1980 Posted December 30, 2006 Author Share Posted December 30, 2006 Shane on me ::)I'm noob, I'm learning all the time;]Thisi is my first script ;D Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150106 Share on other sites More sharing options...
Amy1980 Posted December 30, 2006 Author Share Posted December 30, 2006 hmmm... ::)How to call it?:> Link to comment https://forums.phpfreaks.com/topic/32324-mysql-error/#findComment-150109 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.