\n"; echo "TitleAuthorYearMediaMenreNotes\n"; do { printf(" %s %s %s %s %s %s \n", $myrow["title"], $myrow["author"], $myrow["year"], $myrow["media"],$myrow["genre"],$myrow["$notes"]); } while ($myrow = mysql_fetch_array($result)); echo "\n"; } else { echo "Sorry, no records were found!"; } echo "\n"; ?>