PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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*).
//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);
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.
OK spitfire. Why don't you also try some error reporting. You're not even checking if the query succeded. That would be first place to start in my opinion.