Re: Any One See where this is going wrong?

yeah, try using the PDO instead On Sat, May 1, 2010 at 9:14 PM, Adam Richardson <simpleshot@gmail.com>wrote: > On Sat, May 1, 2010 at 6:54 PM, Gary <gwpaul@ptd.net> wrote: > > > > > "Adam Richardson" <simpleshot@gmail.com> wrote in message > > > > news:AANLkTinqiXXB9oiPU4Op2xzTrZe_vwpbyMAYWziwbhr-@mail.gmail.com... > > > > > > >> $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 > > > > > > > > > > > > __________ Information from ESET Smart Security, version of virus > > > signature database 5078 (20100501) __________ > > > > > > The message was checked by ESET Smart Security. > > > > > > http://www.eset.com > > > > > > > > > > Adam > > > > The second INSERT is part of a multi_query, and yes there is a > > auto-increment field in front named id, it is the foreign key that links > > the tables. > > > > I had removed, and just tried again, but the same result. > > > > I have tried it so many ways my fingers and eyes are about to bleed. It > > makes not sense how it works in one but not the other. > > > > I cant see to get the error called out. > > > > Thanks again. > > > > Gary > > > > > > > > > > __________ Information from ESET Smart Security, version of virus > signature > > database 5078 (20100501) __________ > > > > The message was checked by ESET Smart Security. > > > > http://www.eset.com > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > And you also removed the double quote and the comma next to it (sorry, just > making sure?) That is to say, you copied the line of code I sent? > > $sqlStatements = "INSERT INTO guns( *id,*manufacturer, type, model, // > *id,*should be removed > caliber, condition, price, description, image_file_name,submitted > ,available) VALUES ('*',*'$manufacturer', '$type', > '$model', '$caliber', > // the *",* combo should be removed > '$condition', '$price', > '$description','$image_file_name', ' ', > '$available'); > > INSERT INTO images (*id,* image_file) VALUES('','$image_file')"; > // > the *id,* should be removed AND the *",* combo should be removed > > Also, have you tried directly echoing out the error (e.g., *echo > mysql_error();* if it's mysql you're using, or the comparable method in > the > library you're using.) > > If that didn't work, I'd break up the multi-query into 2 separate queries > to > better troubleshoot the issue. I like using PDO and setting it up so it > throws exceptions when something goes wrong (additionally, I like using the > prepared statements, too.) Have you been trying that? > > I'm still hopeful you'll get this figured out before there's any blood-loss > ;) > > Feel free to send back the new code after the edits if you still have > issues. > > Adam > > -- > Nephtali: PHP web framework that functions beautifully > http://nephtaliproject.com > -- A Brandon_R Production