|
||
|
".chr($x).""; else echo "".chr($x)." "; } echo "Refresh Database"; $letter = $_GET["letter"]; if (isset($letter)) { $qrySur = "SELECT * FROM st_casimir WHERE sc_surname LIKE '$letter%' ORDER BY sc_surname"; } else { $qrySur = "SELECT * FROM st_casimir ORDER BY sc_surname"; } $result = mysql_query($qrySur); $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['sc_surname']; $firstname[] = $row['sc_firstname']; } echo " If you have a database or information that you would like to put into our database, that pertains to Lithuanian genealogy, please contact us at webmaster@lithuaniangenealogy.org |