Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

GET listing info ebay contrib


Guest

Recommended Posts

I get this error:

1064 - 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 'virginator' tshirt L@@K!!', NULL , '1', '0.0000', 'GBP 9.99', '

INSERT INTO auction_basket ( `auction_basket_id` , `auction_house_id` , `auction_item_id` , `ext_id` , `auction_winner_id` , `listing_status` , `time_start` , `time_end` , `orders_id` , `ext_title` , `ext_desc` , `quantity` , `price_start` , `price_end` , `insurance` , `shipping` , `sales_tax` , `products_id` ) VALUES ('', '1', '0', '2863749479', '1', '2', '2003/10/18 3::', '2003/10/25 14:10:49', NULL , 'Gothic 'virginator' tshirt L@@K!!', NULL , '1', '0.0000', 'GBP 9.99', '0.0000', '0.0000', '0.0000', '713')

[TEP STOP]

 

Any ideas??

I think it may be the ' in the item name, not sure tho.

Link to comment
Share on other sites

Isn't that what tep_db_prepare_input does?

 

Or something like $stuff_to_output_formatted = preg_replace("/'/", "\\\'", $stuff_to_output);

 

Hth,

Matt

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...