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: string problems, search string in array, find php, build mysql query, SQL Query, query table, php mysql display existing 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, query query, column php loop, mysql query php, loop table php, simple display results php, find matches files, output table

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

Proje NO: #6501142



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 %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(43 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(53 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)