We need a query to generate the quantity sold and the price for each product in prestashop for each year. I can provide a database dump. We need to be able to export in excel/csv like the below example, I should be able to change the year in the query, for example to generate results for 2015, 2016 and 2017 separately. Product | Quantity Sold
Hello Friends, I have developed a form to insert the values from Google maps using j query with single color for each record and successfully saving in the back end. Now I am unable to retrieve the inserted data with color I have saved and update the map / existing record. I will provide you the tables and queries related to that form. You
...is run a as a db event that need to create a credit and I need this improved and reviewed. I feel like the query mostly works but it is creating a blank record. I need to make sure everything works as expected due to the importance of this query. 2. I have time left text I want to look like a timer. The calendar below should also be accurate and
I have a query that it should finish in about 30 minutes but instead it just keeps running on end, it fills the filesystem and then die I need someone that knows SQL very well, has experience with columnar database and how they work (example no indexes etc) and that it can properly read and understand query plans I will provide the query and more
I need a WordPress query written to pull repeater entries that have a specific option selected from a custom post type. I have the custom post type and all of the fields created, including a select field that I need the entries to be queried by - just having some trouble with the code to display the correct results.
...using PHP and MySQL. The three text files should be ported into MySQL tables. The schemas for the three tables are simple and should be derivable just from the column names and the values seen under each column. There are however a lot of columns (> 150 for each). The website has two features: “Get lexical characteristics”, i.e., search through
Im needing a query added to my wordpress site ([url removed, login to view]) that basically runs like this: The customer types in their car license / rego number and hits search. The website then needs find the cars details on carjam.co.nz. It then needs to find the matching vehicle on my database, and copy some details and put them into a graphic which it displays
Small project,, need help with write script query data from mysql then turn it into feed or API
I have a .js file that controls several intranet pages for my organization. I am trying to get 1-3 snippets added to this file. I'll definitely share the .js file that I have once hired. To start off, I'll need a snippet that does the following: - Creates a keyboard shortcut to go back to homepage. For example: if I press ALT+H on my keyboard, it should take me back to my intranet ho...
Hello, I'm using wordpress with an email newsletter plugin name "Mailster", bought on Canyon. I set up a cron job to send email each minute, everything is OK until NOW: Each time the cron run, it eat 100% CPU of my VPS for about 60 seconds, that makes the web so slow. I contact the plugin editor but they seem busy, so I decide to find someone who can fix this. Thank ...
...have their current php code modified with a MYSQL query. Project Details. The client has a static page that uses a query to select * from a specific table. The client recently updated their database and now they have 5 tables, all of them have identical structures with different data in each one. The client wants to create a query that will find which
Hello, I need a simple mysql query that i can enter into my Wp Datatables plugin in wordpress. All form entries are stored in the Formidable Pro data tables but i need to query these tables to pull out form entries as rows in Wp Datatables Thanks