I would like to select all active categories and view it with a breadcrumb. In my database I have the following: id_category category_name velleman_id velleman_parent prestashop_category prestashop_category_2 prestashop_category_3 prestashop_category_4 deleted 1 Car & Bike 10 0 2 Bike 10.10 10…
I have 2 tables, 'manufacturers' and 'products'. A manufacturer can have multiple products and a product has a 'qty', 'price' and 'cost' field. I've LEFT JOINed them together and can get SUMs on the 'price' and 'cost' fields based on…
I'm looking for guidance on how to apply IFNULL to an outer query in my mySQL Query. The query checks for new timecards submitted the previous day and kicks off a procedure that writes the results to a file server.…