Devam Ediyor

sql query and php output

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.

Beceriler: MySQL, PHP, SQL

Daha fazlasını görün: string problems, search string array, find php, build mysql query, sql query, query table, project input output, sql query loop, php table array, mysql formatting output, query loop, php loop mysql column, php mysql sql example, php mysql query multiple, mysql loop sql, mysql output table, php output, column php loop, mysql query php, loop table php, simple display results php, find matches files, output table, sql query field, multiple string search

İşveren Hakkında:
( 6 değerlendirme ) Pompano Beach, United States

Proje NO: #6501142

Seçilen:

gutibs

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!

1 gün içinde 35$ USD
(43 Değerlendirme)
5.3

4 freelancer bu iş için ortalamada 31$ teklif veriyor

WebWars

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 fazlası

1 gün içinde 45$ USD
(53 Değerlendirme)
5.3
rajuahamedodesk

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 fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
pravatkumishra

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 fazlası

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
usmanali838

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

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0