Showing results for certain dates?

[xwishmasterx]

Hello

I am not sure that this is even possible, but then again I am not an expert in the php-arena :-)

I have this piece of code that shows the top 100 sponsors:

$rs=mysql_query("select * from topref order by ref desc limit 0,100");
while($arr=mysql_fetch_array($rs)) {
$rs1=mysql_query("select * from users where Username='$arr[0]'");
$arr1=mysql_fetch_array($rs1);
echo "<br> User:$arr[0] have $arr[1] Referrals";

Is it possible to show the results for "last week" and "current week"

The members have a signup date located in the "users" table..

Let me know if you need more info :-)

Regards,
Casper

[bretticus]

Not familiar enough with your table structure to say for sure, but as long as you have a date field somewhere, you should be able to query by date. Check out the MySQL date and time functions. Also, it's worth noting that since you have a corresponding field for Username in your topref table, you should use join syntax to avoid having to query the database 101 times. In other words, you probably only need to make 1 query. In order to get it into one query with last week and current week values you may have to use sub queries. Aggregate functions can also be helpful for counting or summing values.