A problem with my SQL

[Guest]

Gday,

 

Just wondering if someone sql savvy could help me out with this issue

 

when i go to add products, or edit a product in the backend ( admin )

after i go and add the product

it comes up with 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 'now() where products_id = '1251'' at line 1

 

update products set products_quantity = '1000', products_model = '1158280009', products_price = '45.4091', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '24', products_image = 'adam & eves audio erotic sound activated egg.jpg', now() where products_id = '1251'

 

can someone please tell me what the problem could be

 

thankyou

 

Greg.

[Guest]

Gday,

 

Just wondering if someone sql savvy could help me out with this issue

 

when i go to add products, or edit a product in the backend ( admin )

after i go and add the product

it comes up with 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 'now() where products_id = '1251'' at line 1

 

update products set products_quantity = '1000', products_model = '1158280009', products_price = '45.4091', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '24', products_image = 'adam & eves audio erotic sound activated egg.jpg', now() where products_id = '1251'

 

can someone please tell me what the problem could be

 

The problem is that last clause:

 

, now() where products_id = '1251'

 

As you may be aware, now() is a MySQL function which returns the current time. I'm guessing that in this query it is supposed to be setting one of the datetime fields in the products table, probably products_last_modified to the time that the query is run.

 

If that last clause read:

, products_last_modified = now() where products_id = '1251'

it would probably work.