hi i have to select this :
$t2=mysql_db_query($db, "SELECT radacct.UserName,sum(radacct.AcctSessionTime)
as t1,usergroup.GroupName ".
"from radacct LEFT JOIN usergroup ON
radacct.UserName=usergroup.UserName where".
"usergroup.GroupName='unlimited' AND
radacct.AcctStartTime>='2001-$month-01 00:00:00'".
"AND AcctStopTime<='2001-$month-31 23:59:59' group by UserName");
when i do it in mysql database it already give me result and thereis about
400 rows.
but when i want to generate it fetch the array there is a error
Supplied argument is not a valid MySQL result resource in <b>./stats.php</b>
on line (bellow is the line
$x=mysql_fetch_array($t2);
what might be possible wrong with the code..(it just a simple one)
Yamin Prabudy
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
