...website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly. The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster. My VPS >> "MySQL Slow Query" log s...
Our website (WordPress and Gravity Forms) has an online offering system. Clients can ask online for a quote and our server mails the offer (in pdf) to the client. Our office uses MS Access and we want to make queries from MS Access (VBA) to the database made by Gravity Forms on our website (I think the small database is stored on our site and know it is a sql-database) . So I am looking who know...
I am looking to rename multiple choice answers client side (php file) that are showing as numbers. Example what I now have in my PHP file: 'sql_query' => "SELECT element_10,element_2,element_3,element_5,element_4,element_6,element_8,element_9 FROM ap_form", Here's what I need element_5 has 2 choices Choice 1 is showing up 1 I would like it
I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
Our client has a web site in PHP. On web site, there is a contact us form in PHP with form validation. No data base used in contact us form. Contact us Form fields - * All form fields are mandatory. Full Name:_____________ Email: ______________ Skype ID: ______________ Telephone: _____________ Country: _____________ Message: _____________
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.