Devam Ediyor

Report Query, formatted results needed (PHP)

Need a SQL query and proper php logic to construct a table of results for the following:

the table in mysql contains search engine placement data, namely the name of the search engine, the keywords (up to 5, separated by pipe | in a string), the positions (numeric, also separated by pipe | in a string which match each keyword) and the week the data was gathered (numeric, say 49 as an example).

Here's what the report needs to do:

For each search engine, it needs to print out the heading (eg <h3>google</h3>), then print out a table with the keyword9s) in the left-most col, the week in the top row, and the positions in the row of each keyword. For example:

| 45 | 46 | 47 | 48 | 49 |

-------------------------------------------------------------

keyword1 | 36 | 40 | 30 | 25 | 30 |

keyword2 | 1 | 4 | 6 | 4 | 10 |

It needs to be repeated for each search engine (there are three of them who's data is in the table.) the report needs to look at the current week - 10 weeks, so basically it is historical to 10 weeks.

The way the database table is constructed is each search engine has its own row for a given week, so google, msn, and yahoo each have a row of data for a given week (49 for example.)

Here's the last interesting part - week to week, the keywords may change. if the keyword string changed since the last week, the report needs to add row(s) with the new keywords (see below - keyword 3 is new...added during week 47...and keyword 2 was removed during week 49.)

| 45 | 46 | 47 | 48 | 49 |

-------------------------------------------------------------

keyword1 | 36 | 40 | 30 | 25 | 30 |

keyword2 | 1 | 4 | 6 | 4 | |

keyword3 | | | 23 | 25 | 20 |

Any questions, please PM me...should be simple for someone who knows php and mysql. Will provide mysql table schema and test data to the winning bidder, of course.

Beceriler: Veri İşleme, PHP

Daha fazlasını görün: placement new, up string, top query, string match, search engine questions, placement new example, n query, namely, match string, it positions, database positions, report example, sql query, sql database report, simple query, schema, report sql, query table, pipe, php test, numeric, mysql report, mysql query, it report, database needed

İşveren Hakkında:
( 24 değerlendirme ) Derby, United States

Proje NO: #112680

Seçilen:

hussainweb

Hi, Please check PMB.

1 gün içinde 52$ USD
(99 Değerlendirme)
6.7

9 freelancer bu iş için ortalamada 49$ teklif veriyor

webedeveloper

Let's start. Plz chechk pmb for details.

in 0 gün içinde45$ USD
(104 Değerlendirme)
7.0
nima

Please check PM

in 0 gün içinde50$ USD
(53 Değerlendirme)
5.7
perou

I am very interested in completing this project for you.

1 gün içinde 40$ USD
(13 Değerlendirme)
3.9
iferianto

let discuss on PMB

in 7 gün içinde50$ USD
(5 Değerlendirme)
3.7
Ellemer

Hello, I can write this script for you.

in 0 gün içinde35$ USD
(7 Değerlendirme)
3.3
EvroStandart

can be done

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

Experienced with reporting in PHP/mysql/HTML, will deliver this for you today. More in PMB...

in 0 gün içinde50$ USD
(0 Değerlendirme)
0.0
auspicious

lets do it

in 5 gün içinde70$ USD
(0 Değerlendirme)
0.0