randydg Posted November 10, 2009 Share Posted November 10, 2009 The bellow code most of the time works, but if there is a previous customer it will pull up old data. any help would be greatfull thanks, Randy <? $worksheetnum = trim(stripslashes($_POST['worksheetnum'])); //Get Worksheet Data from database for $worksheetnum $query="SELECT * FROM `worksheets` WHERE `id` = $worksheetnum"; $result=mysql_query($query); $num=mysql_numrows($result); $n=0; while ($n < $num) { $date=mysql_result($result,$i,"date"); $time=mysql_result($result,$i,"time"); $caller=mysql_result($result,$i,"caller"); $equipment=mysql_result($result,$i,"equipment"); $warranty=mysql_result($result,$i,"warranty"); $billable=mysql_result($result,$i,"billable"); $inshopa=mysql_result($result,$i,"inshopa"); $onsite=mysql_result($result,$i,"onsite"); $called=mysql_result($result,$i,"called"); $workproblem=mysql_result($result,$i,"workproblem"); $workperformed=mysql_result($result,$i,"workperformed"); $serial=mysql_result($result,$i,"serial"); $comments=mysql_result($result,$i,"comments"); $dateworked1=mysql_result($result,$i,"dateworked1"); $dateworked2=mysql_result($result,$i,"dateworked2"); $dateworked3=mysql_result($result,$i,"dateworked3"); $timein1=mysql_result($result,$i,"timein1"); $timein2=mysql_result($result,$i,"timein2"); $timein3=mysql_result($result,$i,"timein3"); $timeout1=mysql_result($result,$i,"timeout1"); $timeout2=mysql_result($result,$i,"timeout2"); $timeout3=mysql_result($result,$i,"timeout3"); $techworked1=mysql_result($result,$i,"techworked1"); $techworked2=mysql_result($result,$i,"techworked2"); $techworked3=mysql_result($result,$i,"techworked3"); $quanity1=mysql_result($result,$i,"quanity1"); $quanity2=mysql_result($result,$i,"quanity2"); $quanity3=mysql_result($result,$i,"quanity3"); $quanity4=mysql_result($result,$i,"quanity4"); $quanity5=mysql_result($result,$i,"quanity5"); $quanity6=mysql_result($result,$i,"quanity6"); $description1=mysql_result($result,$i,"description1"); $description2=mysql_result($result,$i,"description2"); $description3 =mysql_result($result,$i,"description3"); $description4=mysql_result($result,$i,"description4"); $description5=mysql_result($result,$i,"description5"); $description6=mysql_result($result,$i,"description6"); $unitprice1=mysql_result($result,$i,"unitprice1"); $unitprice2=mysql_result($result,$i,"unitprice2"); $unitprice3=mysql_result($result,$i,"unitprice3"); $unitprice4=mysql_result($result,$i,"unitprice4"); $unitprice5=mysql_result($result,$i,"unitprice5"); $unitprice6=mysql_result($result,$i,"unitprice6"); $extendedprice1=mysql_result($result,$i,"extendedprice1"); $extendedprice2=mysql_result($result,$i,"extendedprice2"); $extendedprice3=mysql_result($result,$i,"extendedprice3"); $extendedprice4=mysql_result($result,$i,"extendedprice4"); $extendedprice5=mysql_result($result,$i,"extendedprice5"); $extendedprice6=mysql_result($result,$i,"extendedprice6"); $subtotal=mysql_result($result,$i,"subtotal"); $tax=mysql_result($result,$i,"tax"); $totalprice=mysql_result($result,$i,"totalprice"); $n++; }; ?> Quote Link to comment Share on other sites More sharing options...
waynewex Posted November 10, 2009 Share Posted November 10, 2009 What defines old data? Also, you should be using mysql_real_escape_string() instead of stripslashes(). Quote Link to comment Share on other sites More sharing options...
siric Posted November 10, 2009 Share Posted November 10, 2009 As a debug, I would print the $query statement to a logfile and check it when the problem occurs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.