statistics page using mysql
Posted: Tue Dec 27, 2005 1:48 am
i have code here that is trying to get a lot of statistics (say for example, the number of queries that CSE N. Roldan is getting between *start date* and *end date*).
it works for N. Roldan ($num_resultnroldan) but not for R. Cauton ($num_resultrcauton). Is this a correct way to do this? Can I only do one search string using one mysql connection? I've read somewhere that I need to do some stored procedures in MySQL.
Many thanks!
Code: Select all
//create variable names
$startstat=$_POST['startstat'];
$endstat=$_POST['endstat'];
//connect to mysql
$conn=mysql_pconnect('--','--','--');
mysql_select_db('qlog');
//N. ROLDAN
$zuknroldan="SELECT *
from clientquery WHERE
prep_by='N. ROLDAN' AND
date_received BETWEEN '.$startstat.' AND '.$endstat.'";
$resultnroldan=mysql_query($zuknroldan);
$num_resultnroldan=mysql_num_rows($resultnroldan);
//R. CAUTON
$zukrcauton="SELECT *
from clientquery WHERE
prep_by='R. CAUTON' AND
date_received BETWEEN '.$startstat.' AND '.$endstat.'";
$resultrcauton=mysql_query($zukrcauton);
$num_resultrcauton=mysql_num_rows($resultrcauton);Many thanks!