1920 Michigan Census (Lithuanians only) Compiled by: Stephanie Smith 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.

Approximately 30% of the 1920 Michigan Census records have been indexed, extracting Lithuanian entries only. However, the indexing will continue and new entries will be added in the future. Thus we invite you to check back regularly. The information for this database is being compiled by Stephanie Smith (picture at left).

NOTE: To search this database, click on the letter representing the first letter of the surname you are interested in. This database is sorted bu surname. As such, an abode number has been added so that people from the same household can be quickly identified.

".chr($x).""; else echo "".chr($x)." "; } echo "Original View"; $letter = $_GET["letter"]; if (isset($letter)) { $qrySur = "SELECT * FROM 1920Michigan_census WHERE surname LIKE '$letter%'"; } else { $qrySur = "SELECT * FROM 1920Michigan_census"; } $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['surname']; $given[] = $row['given']; $relation[] = $row['relation']; $info[] = $row['info']; $abode[] = $row['abode']; $remarks[] = $row['remarks']; } 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)]." Relationship: ".$relation[$i + ($j * $rows)]." Information: ".$info[$i + ($j * $rows)]." Abode: ".$abode[$i + ($j * $rows)]." Remarks: ".$remarks[$i + ($j * $rows)].""; } echo "

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