Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Help


webiknight

Recommended Posts

I have added the module for shipping per item and need to update my database with the shipping costs. I would like to do this with a SQL statement but the one basic one that i am trying to use isnt working.

 

INSERT INTO `products_ship_price`

VALUES ( 6.00 )

WHERE 'product_model' = "01-2729-12";

 

MySQL states: #1064 - You have an error in your SQL syntax.

 

Please help and let me know whats wrong with my syntax.

 

THanks, :blink:

Link to comment
Share on other sites

if the module adds a field to the products table it should be

 

update products

set products_ship_price = '6.00'

WHERE 'product_model' = "01-2729-12";

 

if it's a new table, then you need to tell us the table structure for us to help without having to dive into the contribution ourselves

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

woow, that was an easy fix B)

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...