---

".chr($x).""; else echo "".chr($x)." "; } echo "Original View"; $letter = $_GET["letter"]; if (isset($letter)) { $qrySurname = "SELECT * FROM `mps_Men_Chorus-SG` WHERE surname LIKE '$letter%' ORDER BY surname"; } else { $qrySurname = "SELECT * FROM `mps_Men_Chorus-SG` ORDER BY row_num"; } $result = mysql_query($qrySurname); //Need to know the number of rows, so use this line $num_rows = mysql_num_rows($result); echo "
(Total Number of Records in Database: $num_rows)

"; //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']; $title[] = $row['title']; $given[] = $row['given']; $row_num[] = $row['row_num']; $position[] = $row['position']; $add_info[] = $row['add_info']; } echo "\n"; for ($i = 0; $i < $rows; $i++) { echo ""; for ($j = 0; $j <$columns; $j++) { echo ""; } //echo "

".$surname[$i + ($j * $rows)].", ".$title[$i + ($j * $rows)]." ".$given[$i + ($j * $rows)]." R:".$row_num[$i + ($j * $rows)].", P:".$position[$i + ($j * $rows)].""; } echo "

"; //echo ""; //echo ""; //echo ""; //echo ""; //echo ""; //while ($row = mysql_fetch_array($result)) //{ //echo ""; //echo ""; //echo "Row: {$row['row_num']}"; //echo "Position: {$row['position']}"; //echo ""; //} echo "

Name	Row	Position
{$row['surname']}, {$row['given']}

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

If you know the names of any of the above individuals, please contact us with the name,
row # (Row#1=bottom; Row#3=top), and position # (starting from the left).
Example: Aldona Jukaitis, Row 1 (from bottom), 3rd from the left.

Top | Back to Database Main Page