This project is to build two simple queries to locate lines in a table that have duplicate values and lines which have values that are blank (no string).
As for the duplicate values query:
Attached is the table choice_tracker.
The query needs to search the table choice_tracker for items in the table where client_matter, client_number and client_name match another line in the table. The search must return matches regardless of the case of the string (i.e. ‘ACT’ must match ‘act’)
As for the query to find blank items:
Same table. Query should build an array of items which have a field which has no string value in any column.
For both queries, the query and output need to be written in a manner where they can be pasted into existing php files. Then the results need to be displayed as output with a for loop to display multiple lines of output. An example of how the output should be formatted is in the attached filed [url removed, login to view] (look in the if (isset($find_location)) section for output being displayed).
When the query is provided I will input it into the pages where it will be run and the output displayed and you will assist in working out any problems in formatting so the query works for its intended purpose.
Hello, question, do you have table structure? how many records are there on the table? Can help you out, but would like to have that information in order to create the best query. Thanks!
4 freelancers are bidding on average $31 for this job
Dear Sir I am very good in writing sql mysql query because I taught database lab 3 times so I have a lot of experience of dealing with such queries