Php mysql database query scriptemplois

Bonjour, Ma configuration WP actuelle Version de PHP/MySQL : 7.0/5.5 Thème utilisé : EstateEngine Nom de l’hébergeur : OVH Adresse du site : [se connecter pour voir l'URL] Problème(s) rencontré(s) : C’est un site de résidence principale, et je voudrais insérer par exemple une location d&...

Veuillez vous inscrire ou vous connecter pour voir les détails.

I have a mysql query I am working on, part of it is correct and part of of it is not. I need help correcting the issue. I can provide sample data and queries. This is the main query in its current state. amtbill column does not sum correctly. I'm sure it is the type of join but I am not sure how to fix. SELECT [se connecter pour voir l'URL], [se connecter pour voir...

Pivot Query with Multi Where clause , Sql Server

Project is to fix an error in a WordPress site. The error appears to be in a PHP file. The error is very generic and [se connecter pour voir l'URL] on some page loads, not others, and when it does, if you refresh a few times, page may [se connecter pour voir l'URL], some pages just will not load at all however may times you refresh. The site in question has been running 5 years

The project is using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project.

I want to extract some data via PHPmyadmin from a database in a CSV format. only apply if you are an expert and can do this right now. I think its small task and it can be done within 5 min if you understand my requirements. Need to be done on anydesk.

Need some strong Jquery developer to set over flow issues, already we used horizontal scroll need to set overflow for one sections, will give more details.

...10 min ago and balance < z_min and z_warn > z_tries you will receive values like [se connecter pour voir l'URL] 5 1 [se connecter pour voir l'URL] 5 5 [se connecter pour voir l'URL] 4 1 etc for each entry received issue php /var/www/html/gateway/[se connecter pour voir l'URL] --ussd --gw [IP] --ports [channel].[sim] --ussd-code [z_rech_code][card]# mark...

We have a stored procedure with sql queries , need a person to help us converting it to cube and get the desired output. we have the dimension and measures are in place

Hi there, My IT person is away on holidays and I need someone to help me with 6 simple queries. Very simple task is to write 6 SQL statements based on a simple data model (4 tables only). Easy for a very good SQL programmer, should take less than 20' of your time! Details of the model and the 6 questions to be shared privately after project approved.

Hi friends - I have this syntax that I am attempting to query an API and return data from it. My issue is that when the syntax hits List<IH> ih... line it returns a 500 error. Can someone examine this and let me know what I should do to remedy? private void LoadGrid() { List<IH> IH = new List<IH>(); IH = dal

NEED SOMEONE TO HELP FIX SQL DATABASE QUERY (Load directions: 610 directions)

...excel document a table of queried results around the search for "leaf" under the USPTO database. I will need to have links for only the items that have a word mark leaf only and are live. [se connecter pour voir l'URL]:1375z2.1.1 Query/Search - "leaf" View Search History - Live Example: [se connecter pour voir l'URL]

Please write sql statement to query “total sales of each product for each salesman who had sales on more than 1 product“ check files

The project is a web based application that uses MySQL for its database. The application is written in php, runs on iis and hosted in aws and in AURORA db. The scope of work includes running benchmarks tests, analyzing the results and improve the query performance Till acceptable performance level is achieved. This is no simple sql writing job. Need

Need to be able to semantically parse queries to classify textual queries into buckets and translate them into actions to perform. More information if we decide to proceed.

I need to make 10 queries on MS-Access, are multitable query. And very important, I have a table with User and password. Need to show information if user and password is valid, if not valid the query not show information. I want to the freelance will connect to my machine to make queries.

The PHP needs to: Check a date field then email me (a designated email address) and a client (their email is in a table in same database) on that day. Email to say something like "Just a reminder." with a subject of "(field in database) Date" and also Check a second date field then email me (a designated email address) and a client (their email is

I would like some help with some simple MongoDB queries. Message me for more info!

SQL Query for an existing database

I am looking for someone to write an Excel / PowerBi power query to allow me to access a text analysis API provided by Tisane. The API documentation can be found here: [se connecter pour voir l'URL]

I need to solve a json_decode query (PHP, using curl_setopt). The php file will be hosted in a URL without HTTPS, but the data provider had HTTPS. The code is attached here.

...Project Manager to a page in a table format with a link to additional information in a profile page. The Project Manager has a search and query search but the search does not work. I want to be able to input a query based on the following fields in the table: class year, position, ht, wt, state/region, gpa, act. Any assistance that you can guide me

Can someone fix my C# syntax to query SQL Server from ASP.Net? This is my syntax I attempt but I have multiple compile errors -> what would be the proper way to do this? public class InvoicePullController : ApiController { public IEnumerable<Invoice> Get() { List<Invoice> result = new List<Invoice>(); using

Hi! I want hire someone who can write one small query and one small function which can provide me required data in table. I have one table called number_list in which I have id, name, number and one another table called number_status in which I have id, number, start_time and end_time. I want display data in my table called name, number and Number

I belong to about 30 Facebook Groups. I have about 10 products that I post for sale to each of these groups . I need a Program that can identify all my Post Id's in all my groups. The ID's can be saved to a text file. I own a Windows 10 laptop. If you can't write a program for my laptop, then an app for my samsung s9 android phone would be my second choice. If you could tell me how ...

2. This assignment 1 is worth 20% of the total marks for this unit. You are required to build your own website with raw HTML5, CSS3, Javascript and PHP/SQL. You are not allowed to use any web authoring packages such as Dreamweaver, Visual Studio or any other website building software. The site must be created according to the required standards or specifications

Veuillez vous inscrire ou vous connecter pour voir les détails.

Calculate the Credit transaction views for each month, per customer. CreditView - In the form 1-0-0-1-1-...etc where 1 is a month with at least one transaction and 0 a month with no transaction CreditVolumeView - In the form 2-1-3-0-1-..etc where each digit is the total volume(number) of transactions for one month CreditAmountView - In the form 128-29-24-89-...etc where each number is the total ...

I am looking for someone to transfer excel data manipulation logic into Microsoft power query (Microsoft power BI) to enable assessment of a large data set (>200m rows).

I am looking to create a query the links two columns in the same table and considers them as a single row when running the query. This needs to ensure that column 1 ('action') and column 2 (availability_date) both equal the value listed. We have multiple entries where 'user_id' in this database table, which has matches for the action and availability_date

Using Entity Framework and C# want to run a Select statement Stat...studphone from studeninfo where validated IS NULL Need full C# syntax that can query SQL Server using Entity Framework and execute the above select statement. I already have set-up Entity Framework and am returning all results from table, just need to know how to do a raw sql query

I want to add query to retrieve data from other MySql database in same server to Joomla website using login user condition

An existing stored procedure which is having sql queries we need to update the sql queries to MDX.

...T2 medium). Site's working fine mostly, but sometimes the server CPU utilization shoots up to 200% (2 cores) because of one mysql query. On setting up a slow_query log and testing with few orders, there's this particular query which takes the most time. SELECT c.category_id, c.parent_id, [se connecter pour voir l'URL] as title , ( SELE...

AppGini knowledge a plus! I have a database which houses several tables, consisting of employees, their titles, and what brand they work for. I then have a table which houses various training programs and another that lists which training programs are required by which brand and for which position. I need a report that will display what training is

I have a MongoDB query: var queryLookup = {from:'fromCollection',localField:'field',foreignField:'otherField',as:'lookup_info'} [se connecter pour voir l'URL]({$match:queryObj},{$lookup:queryLookup},{$project:queryProject},{$sort:sortObj}).toArray(function(err,items){}); However, the lookup_info value is an array with the first element being th...

...discovered an issue with duplicate images. Some products call images like abcd_01, abcd_02, abcd_03 but it's always the same image. We want someone who can script a SQL function or a PHP script to make the product call abcd_01 for all variants or for all other products which call abcd_02 and abcd_03 and so on. But, obviously, we have 61637 other products

Please see excel spreadsheet attached- it has 2 tabs. Tab 1 – Jan-Sept –Lauren info Tab 2-AB vins unpaid –Andre info I need to populate column H of my tab with description “AB list.” as per the VIN and part number in his spreadsheet-column C and D on his tab The ones in yellow on his spreadsheet I did manually & populated column H on my spreadsheet by typing in...

I'm providing you with a UML diagram (see attachment and the note below) and the following question based on which a SQL needs to be written. The Question is, Which Drugs are in a relationship with a Gene that is in a relationship with a Protein which has a relationship with another Protein where minimum positivity is 0.8 and minimum identicality is 0.85, and that other Protein is in a relat...

I need to take out matching records from sql server saven in key and value pair. Key can be anything like "Masters in Maths" etc and value can be anything like ...pair. Key can be anything like "Masters in Maths" etc and value can be anything like "90%" for example. I need to take out all records when i pass "Masters in Maths" as query parameter.

script language: PHP front end: html/javascript database: mysql NO FRAME WORKS Table Structure: ALL TABLES: id (auto insert) createddate (auto insert) modifieddate (auto update) Table A (entities) name varchar state (varchar) 2 letter us state code type varchar(city, county, school district, university, college) url varchar table B (url) datasource

We have a map application with a Laravel website. The GeoHash has been implemented and there's small issue with it. We need you to fix it. If you know Open Layer or Laravel programming. It should be easy. The work has to be done using remote control: Teamviewer or Anydesk.

Looking for anyone with knowledge of dbf files

Hi, I would like you to create a sample Java application that can continuously listen to any addition, modification, deletion that we do on a specific region in Pivotal Cloud Cache... We need to use Spring framework 1.5.*, Maven for the build... The application should be deployed in Pivotal Cloud Foundry.. Thank you. PS: Note if you are proficient with PCF and binding multiple internal and ext...

...give me correct answer. Please don't bid more! Query 1: select date_format(livedate,'%Y-%M') as month, sum(allotted) as made_available from sky_seat_detail s, sky_film f where [se connecter pour voir l'URL]!='backstage' and f.live=1 and livedate>=live_date and s.film_id=[se connecter pour voir l'URL] group by month order by livedate asc; Query...