Fawkner Memorial Park Victoria, Melbourne, Australia Compiled by: Vytas Levickis Website/Database design by: Richard Gostautas All databases are copyrighted © 1999-2008 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 fmp_melbourne WHERE surname LIKE '$letter%' ORDER BY surname"; } else { $qrySurname = "SELECT * FROM fmp_melbourne 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)) { $reg_num[] = $row['reg_num']; $surname[] = $row['surname']; $given[] = $row['given']; $age[] = $row['age']; $dob[] = $row['dob']; $dod[] = $row['dod']; $service[] = $row['service']; $location[] = $row['location']; $ser_type[] = $row['ser_type']; $gender[] = $row['gender']; $fun_dir[] = $row['fun_dir']; } 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)]." Gender: ".$gender[$i + ($j * $rows)]."  Age: ".$age[$i + ($j * $rows)]." Date of Birth: ".$dob[$i + ($j * $rows)]." Date of Death: ".$dod[$i + ($j * $rows)]." Date of Service: ".$service[$i + ($j * $rows)]." Location: ".$location[$i + ($j * $rows)]." Service Type: ".$ser_type[$i + ($j * $rows)]." Funderal Director: ".$fun_dir[$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)"; ?>