Mysql Query Problem

[Tracer]

I have the following query:

$sql2="
INSERT INTO bill
( bill_id , 'record_id, 'drugname , billdate , qty , price )
VALUES
('', '$recordid', '$drugname', '$billdate', '$row[qty]', '$row[price]')";

I can display $drugname to the screen (echo), but it does not add to the mysql db, and I get no errors?! $drugname often contains spaces such as "Claritin 10mg Tablets". Unfortunately however i Do not think the spaces are the problem (I have hardcoded claritin 10mg tablets into the query and it works fine). Any Ideas?

[Tracer]

Here is all the code from the query

foreach($drugs2 as $key=>$value)
{
$row=& $drugs2[$key];
$drug ="$row[name]";
if ("$row[price]" > 0)
{
$sql2="INSERT INTO bill ( bill_id , record_id , drugname , billdate , qty , price )
VALUES ('', '$recordid', ' $drug ', '$billdate', '$row[qty]', '$row[price]')";
$results2 = mysql_query($sql2, $connection);
}
echo "$drug<BR>"; //REMOVE just test if var is set
echo "$sql2<BR>"; //REMOVE just test if var is set
unset($sql2);
unset($row);
}

[Frag]

There are errors in your query now. So you are saying that everything except $drug are updated? Drug is null? or just white spaces? From the looks of the query building you have un-needed quotes and a comma.

Frag