Em Andamento

Quick PHP Query Project

I am building a topsites list, and in the process of ranking sites

have stumbled on a problem. I list sites in order of the sum of their

views in the last 7 days, from topsite_views which contains the number

of views for any given day there is more than 1 view. I know how to do

this.

My trouble is how to assign an actual rank number to the sites. I need

to find how many sites are above them and add 1 (I know this much),

but I don't know how to compare them when the actual calculation takes

place inside the query.

Here is an example:

First, I find out the sum of views in last 7 days for the site in

question ($valuex), then I want to see how many sites are better:

$qry = "select sum(views) as viewsum from topsite_views where viewsum

>= '$valuex'";

Obviously, the query fails because it doesnt know what viewsum is

until the query is finished... yada yada..

To clarify:

The query needs to count the number of sites in the toplist_views

table that have a sum of views column [where date = DATE_SUB(curdate(),INTERVAL 7 day)] which is greater than a

specific value. I cannot use subselects or subqueries because of my

mysql version.

For example, if I was just counting the sum of views for one site it would be:

$prerankqry = "select sum(views) as viewsum from toplist_views where

siteid='$siteid' and date =

DATE_SUB(curdate(),INTERVAL 7 day) group by siteid";

Query needs to be in format that is compatible with using TemplatePower.

THIS IS ONE LINE OF CODE NEEDED TODAY - THAT IS THE WHOLE PROJECT

AVAILABLE ON MSN FOR DISCUSSION IF NECCESSARY

Habilidades: PHP

Ver mais: ranking code, n query, inside view, greater building, find php, find it project, php query sum, the php group, quick order, query table, qry, project, project add, one line php, mysql query, how to add example project, find project, eugeneb, counting, clarify, any project, format php code, compatible php, date calculation, php code format

Acerca do Empregador:
( 27 comentários ) Maidenhead, United Kingdom

ID do Projeto: #46994

Premiar a:

EugeneB

Please check PMB.

$30 USD em 0 dias
(45 Avaliações)
5.2

2 freelancers estão ofertando em média $30 para este trabalho

VladKuznetsov

Hello. Please see PMB for more details. Regards Zend Certified PHP Developer Vladimir Kuznetsov.

$30 USD in 0 dias
(49 Comentários)
4.9