Search the Community
Showing results for tags 'database query'.
Hello Im stucked on a problem related with this... Can anyone help me? I want to insert the customer ID into the SQL query with WHERE. How could I use the customer ID variable of Prestashop here to make this work and only show the user his rows?: $eventos = Db::getInstance()->executeS('SELECT * FROM `pss_tabla` WHERE id_cliente= customer_id }');
Hi, My database has become rather large and unwieldy of late (a couple of hundred Mbs) with all the updates/new products I am doing and I was wondering if there is either a php script, SQL command to run through phpmyadmin or a module that allows me to 'clean/sanitise' the history of my products so that only the latest most upto date product information is retained but the 'history' of it's updates etc is wiped. Thanks in advance for any help/advice/assistance. Stuart