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!
Bu iş için 4 freelancer ortalamada $31 teklif veriyor
Hello sir, I have 6 years experience in web design and development and I am really looking forward to work on this project. I love web design and coding. Below you can check some projects I worked in the past. ww Daha Fazla
I am a skilled Web Developer and professional on PHP. I can solve any kinds of problems on Programing. I am expert on web design and who is able to create any kinds of web page. I am a hard working person and responsib Daha Fazla
Dear Sir/Madam, I would like to inform that i am a privileged one who is participating in your tender and very much interested for the mentioned bid. Please go through the following credenti Daha Fazla
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