Code: Select all
$query = "SELECT * FROM LINEITM, CUSTSHP WHERE LINEITM.SHIP_ID = CUSTSHP.SHIP_ID AND LINEITM.SO_NO=$id";
$row['NAME'];
$row['ADDRESS'];
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo $row['QTY'];
$row['DESCRIP'];
}
echo "footer.php"
The problem is if I do that I would get a whole bunch of product listings in my array.
I really need to repeat the entire form over with a page break (html to format printing).
I have been thinking and reading about maybe limiting the query to one and then loop back through it adding one to the id until I get to the id2.
Am I on the right track.
Is there a way to do what I want? I am new but learning so point me in the right direction.
Thanks,