I gang

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.

Færdigheder: Databehandling, PHP

Se mere: what is search string, what is placement new, what is a search string, up string, top query, string processing in c, string match, search engine questions, placement new example, php and mysql search engine, n query, namely, match string, it positions, database positions, c# report, report example, SQL Query, sql database report, simple query, schema, report sql, query table, Pipe, php test

Om arbejdsgiveren:
( 24 bedømmelser ) Derby, United States

Projekt-ID: #112680

Tildelt til:

hussainweb

Hi, Please check PMB.

$52 USD på 1 dag
(99 bedømmelser)
6.7

9 freelancere byder i gennemsnit $49 for dette job

webedeveloper

Let's start. Plz chechk pmb for details.

$45 USD in 0 dage
(104 bedømmelser)
7.0
nima

Please check PM

$50 USD in 0 dage
(53 bedømmelser)
5.7
perou

I am very interested in completing this project for you.

$40 USD på 1 dag
(13 bedømmelser)
3.9
iferianto

let discuss on PMB

$50 USD in 7 dage
(5 bedømmelser)
3.7
Ellemer

Hello, I can write this script for you.

$35 USD in 0 dage
(7 bedømmelser)
3.3
EvroStandart

can be done

$50 USD på 1 dag
(0 bedømmelser)
0.0
TMayer

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

$50 USD in 0 dage
(0 bedømmelser)
0.0
auspicious

lets do it

$70 USD in 5 dage
(0 bedømmelser)
0.0