April 2nd, 2003, 07:49 PM
|
|
Contributing User
|
|
Join Date: Aug 2002
Location: Atlanta GA
Posts: 73
Time spent in forums: 1 h 55 m 11 sec
Reputation Power: 7
|
|
|
Getting The Average
Say I have a number is a table.
How would I divide a number that I pulled from a table and divide by what day it is, to get the average since the beginning of the week.
Day 4: Wednesday - 50 in table
Number in table: 50, mysql_query: 50 divide that by 4[day] = Average: 12.5
_________________________________
this is what I have so far... not sure if I'm doing this right...
get the day
PHP Code:
$today = date("l");
if($today == "Sunday")
{
$xDay = "1";
}
elseif($today == "Monday")
{
$xDay = "2";
}
elseif($today == "Tuesday")
{
$xDay = "3";
}
elseif($today == "Wednesday")
{
$xDay = "4";
}
elseif($today == "Thursday")
{
$xDay = "5";
}
elseif($today == "Friday")
{
$xDay = "6";
}
elseif($today == "Saturday")
{
$xDay = "7";
}
else
{
}
________________________________________
get the total from mysql
$day_avg = get_data_array("SELECT...
here's where I divide..
$total = $day_avg;
$day = $xDay;
$average = $total / $day;
then, print("$average");
Last edited by zigote : April 2nd, 2003 at 10:08 PM.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
