Hello. I have one problem. This is the code:

PHP Code:

$category = implode("', '",$_POST['category']);
$category1 = "'".$category."'";
$group = $_POST['group'];
$name = $_POST['name'];
$product = $_POST['product'];
$performance = $_POST['performance'];
$service = $_POST['service'];
$price = $_POST['price'];

mysql_query("INSERT INTO system VALUES ('', '$group', $category1, '$product', '$performance', '$service', '$name', '$price')") or die(mysql_error());
        echo "Product posted successfuly"; 


I get this error: "Column count doesn't match value count at row 1".

I don't know what is the problem. When i delete $category1 in query, and post '', it works. But, i need that variable. Please, help me. Bye.

It's because there are more or less columns in the table than you have specified values for.

exactly as chris said i'm guessing you have some columns that you're not filling out maybe a created at or updated at so the easier way is to defined the columns to insert into:

mysql_query("INSERT INTO system(col_group, col_cat1, cold_product,...) VALUES ('$group', $category1, '$product', '$performance', '$service', '$name', '$price')"

I changed it, and now i get another 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 'group, categories, product, performance, service, name, price) ('', '1', 'panel'' at line 1

What can i do now?

print the query to the browser instead of sending it to the server so you can see what is wrong.

('', '1', 'panel''

if it's auto increment/id you don't need the '', at the beginning. Start with the group column

I fount what is the problem. It was in implode function. My function looks like this now:

$category = implode(", ",$_POST['category']);

Thanks for answers. Bye.