Guest Posted October 5, 2009 Posted October 5, 2009 Hi Everyone, I need to empty the 'product_image' column in the 'products' table but I am not sure of the SQL syntax. Can anyone help me out ? Thanks Chris
FIMBLE Posted October 5, 2009 Posted October 5, 2009 Hi Chris You can use phpmydmin select the table then select "Empty" from the drop down menu at the bottom, or you could use an sql command Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
Guest Posted October 5, 2009 Posted October 5, 2009 Hi Fimble, Thanks for the reply but if I use the EMPTY in myphpadmin it empties the entire Table. I only need to empty the 'products_image' column of the 'products' table. So, I need help with the SQL statements to do this. Chris
♥bruyndoncx Posted October 5, 2009 Posted October 5, 2009 update products set products_image = ''; 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
♥FWR Media Posted October 5, 2009 Posted October 5, 2009 Via PhpMyAdmin/SQL UPDATE `products` SET products_image = null Via php $query = "UPDATE `'" . TABLE_PRODUCTS . "'` SET products_image = null"; Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.