i am seeing this error when i submit data to db and do not know how to correct it.
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 103.
this points to line 40 in the posted code. it is however inserting the data correctly. i would be grateful if someone could point out how to correct this error.many thanks
$company = $_SESSION['kt_idcom_usr'];
$sql = 'select btref'
. ' from boxes'
. " where customer = '$company'"
. ' order '
. ' by id desc'
. " limit 1";
$result = mysql_query($sql);
$btref = mysql_result($result,0,"btref"); <--- LINE 40
return $btref + 1;}