problem with code pulling up wrong data

[randydg]

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++;
};
?>

[waynew]

What defines old data?

 

Also, you should be using mysql_real_escape_string() instead of stripslashes().

[siric]

As a debug, I would print the $query statement to a logfile and check it when the problem occurs.