Lithuanian National Cemetery Cook County, Justice, IL Compiled by: Tracy Duncan Database Upgrade Volunteer: Website/Database design by: Richard Gostautas All databases are copyrighted © 1999-2010 by LGGS. Commercial use or reproduction in any form is strictly prohibited.

".chr($x).""; else echo "".chr($x)." "; } echo "Original View"; $letter = $_GET["letter"]; if (isset($letter)) { $qrySurname = "SELECT * FROM lithnatcem_j_il WHERE surname LIKE '$letter%' ORDER BY surname"; } else { $qrySurname = "SELECT * FROM lithnatcem_j_il ORDER BY surname"; } $result = mysql_query($qrySurname); $num_rows = mysql_num_rows($result); echo "
(Total Number of Records in Database: $num_rows)

"; //Need to know the number of rows, so use this line $num_rows = mysql_num_rows($result); //Set a new variable called $rows $rows = ceil($num_rows / $columns); //For this vertical display, need to run another loop, which will populate an array with our values while($row = mysql_fetch_array($result)) { $surname[] = $row['surname']; $given[] = $row['given']; $dob[] = $row['dob']; $dod[] = $row['dod']; $inscrip[] = $row['inscrip']; } echo "\n"; for ($i = 0; $i < $rows; $i++) { echo ""; for ($j = 0; $j <$columns; $j++) { echo ""; } //echo "

".$surname[$i + ($j * $rows)].", ".$given[$i + ($j * $rows)]." Date of Birth: ".$dob[$i + ($j * $rows)]." Date of Death: ".$dod[$i + ($j * $rows)]." Inscription/Remarks: ".$inscrip[$i + ($j * $rows)].""; } echo "

"; //echo ""; //echo ""; //echo ""; //echo ""; //while ($row = mysql_fetch_array($result)) //{ //echo ""; //echo ""; //echo ""; //echo ""; //} echo "

Name	Inscription/Comments
{$row['surname']}, {$row['given']} Date of Birth: {$row['dob']} Date of Death: {$row['dod']}	Inscription: {$row['inscrip']} Photo#: {$row['photo_ID']}

"; $today = date("l dS of F Y h:i a"); print "Today is $today (server time)"; ?>