Sedang Disiapkan

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.

Kemahiran: Pemprosesan Data, PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 24 ulasan ) Derby, United States

ID Projek: #112680

Dianugerahkan kepada:

hussainweb

Hi, Please check PMB.

$52 USD dalam sehari
(99 Ulasan)
6.7

9 pekerja bebas membida secara purata $49 untuk pekerjaan ini

webedeveloper

Let's start. Plz chechk pmb for details.

$45 USD dalam 0 hari
(104 Ulasan)
7.0
nima

Please check PM

$50 USD dalam 0 hari
(53 Ulasan)
5.7
perou

I am very interested in completing this project for you.

$40 USD dalam sehari
(13 Ulasan)
3.9
iferianto

let discuss on PMB

$50 USD dalam 7 hari
(5 Ulasan)
3.7
Ellemer

Hello, I can write this script for you.

$35 USD dalam 0 hari
(7 Ulasan)
3.3
EvroStandart

can be done

$50 USD dalam sehari
(0 Ulasan)
0.0
TMayer

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

$50 USD dalam 0 hari
(0 Ulasan)
0.0
auspicious

lets do it

$70 USD dalam 5 hari
(0 Ulasan)
0.0