Re: Any One See where this is going wrong?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
>  $sqlStatements = "INSERT INTO guns (manufacturer, type, model, caliber,
>
condition, price, description, image_file_name, available) VALUES

('$manufacturer',
> '$type', '$model','$caliber','$condition','$price','$description','$image_file_name','$available');

 INSERT INTO images(id, image_file) VALUES ('', '$image_file')";


Gary, the second insert has what appears to be a troublesome bit of code:

VALUES ('', '$image_file')";

Shouldn't it read:

INSERT INTO images(image_file) VALUES ('$image_file')";

That's assuming you have id set to auto-increment, so no id in the first or
second set of parentheses.  Additionally, the ", before the $image_file var
would cause issues, too.

Adam
-- 
Nephtali:  PHP web framework that functions beautifully
http://nephtaliproject.com

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux