Search the Community
Showing results for tags 'database query'.
Found 3 results
-
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
-
Can someone please help me on how to query from a different table in prestashop in backoffice? i had maid a menu that should give all the list of products from a different table. but i dont know how to make the query statement.. can you give me a simple script? see the images below.
