query($sql); //end connect echo ""; while($row = $result->fetch_assoc()) { echo ""; echo "" . $row['visitrefnumber'] . "
"; echo "" . $row['dealer'] . "
"; echo "" . $row['dateofvisit'] . "
"; echo "" . $row['status'] . "
"; echo "" . $row['address'] . "
"; echo "" . $row['zonemanager'] . "
"; echo "" . $row['contact'] . "
"; echo ""; echo ""; echo ""; echo ""; } echo "

FAMILY	ITEM	COMMENT
" . $row['family_checklist'] . "	" . $row['item_checklist'] . "	" . $row['comment_checklist'] . "

"; $conn->close(); ?>

Select a person: 27TVMMZ-VN-20/08/2014 27TVMMZ-VN-20/08/

Person info will be listed here...