[Resolved] MySQL INSERT Query Problem

[bump909]

Hi,
Can anyone tell me why this query will not insert the values into the database:

$query_quote = "INSERT INTO quotes VALUES (NULL, '{$SESSION['user_id']}', '{$SESSION['quantity']}', '$r1_qty', '$r1_prod', '$r1_up', '$r2_qty', '$r2_prod', '$r2_up', '$r3_qty', '$r3_prod', '$r3_up', '$r4_qty', '$r4_prod', '$r4_up', '$r5_qty', '$r5_prod', '$r5_up', '$r6_qty' '$r6_prod', '$r6_up', '$r7_qty', '$r7_prod', '$r7_up', '$r8_qty', '$r8_prod', '$r8_up', '$net_tot', '$vat', '$inv_tot', '{$_SESSION['sr']}', NOW(), 'n', 'n')";

$result_quote = mysql_query ($query_quote);

if (mysql_affected_rows() == 1){

[bump909]

The rest of the code:

echo 'success';
} else {
echo '<p>There was a problem entering your quote into the database</p>'.mysql_error();
}

The error message that appears is:

There was a problem entering your quote into the database
Column count doesn't match value count at row 1

I know for a fact that the number of values = the number of fields in the quotes table. Although some of the values may return NULL, I've set the database to accept NULL values. except of course the auto-incremented 'quotes-id' which will not let me. Any help will be greatly appreciated.

Kris K

[tomhath]

You have quotes inside of quotes. That won't work:

 '{$_SESSION['user_id']}'

[bump909]

They will if they are within curly braces. I've now resolved the issue. There was a comma missing after '$r6_qty' and so it was treating 2 separate values as one.
I think I need laser eye surgery ;(

Kris K