"; if ($_SESSION["ALPHA"] == ""){ echo" Alpha: Password: "; } else{ echo" Welcome A$_SESSION[ALPHA] [ Alumni Info ] [ Logout ] "; } echo"

> NOT REGISTERED? > TROUBLE LOGGING IN? > FORGET YOUR PASSWORD?

"; $query = "SELECT * FROM brothers, big_brothers, addresses, phone_numbers, email_addresses, employers, degrees, im_names, comments WHERE brothers.brother_id = '$brother_id' AND big_brothers.brother_id = '$brother_id' AND addresses.brother_id = '$brother_id' AND phone_numbers.brother_id = '$brother_id' AND email_addresses.brother_id = '$brother_id' AND employers.brother_id = '$brother_id' AND degrees.brother_id = '$brother_id' AND im_names.brother_id = '$brother_id' AND comments.brother_id = '$brother_id'"; $res = mysql_query($query); $num = mysql_numrows($res); $records[0] = array("brother_tx_num","brother_first_name","brother_nickname","brother_middle_name","brother_last_name","brother_suffix","brother_url","last_updated","big_brother_id","street_1","street_2","city","state_region","region","postal_code","country_id","addresses_public","deleted","home_number","cell_number","phone_public","email_address","email_address_2","email_public","employer","employer_url","title","business_street_1","business_street_2","business_city","business_state_region","business_region","business_postal_code","business_country_id","business_phone","retired","retirement_date","employers_public","degree_1","major_1","school_1","year_1","degree_2","major_2","school_2","year_2","degree_3","major_3","school_3","year_3","degrees_public","aim","yahoo","im_public","spouse","comments","date_posted"); for ($i=0;$i<$num;$i++) { $rec = array( mysql_result($res,$i,"brother_tx_num"), // alpha number mysql_result($res,$i,"brother_first_name"), // first name mysql_result($res,$i,"brother_nickname"), // first name mysql_result($res,$i,"brother_middle_name"), // middle name mysql_result($res,$i,"brother_last_name"), // last name mysql_result($res,$i,"brother_suffix"), // suffix mysql_result($res,$i,"brother_url"), // url mysql_result($res,$i,"last_updated"), // last updated mysql_result($res,$i,"big_brother_id"), // big brother mysql_result($res,$i,"street_1"), // home address line 1 mysql_result($res,$i,"street_2"), // home address line 2 mysql_result($res,$i,"city"), // city mysql_result($res,$i,"state_region"), // state mysql_result($res,$i,"region"), // region mysql_result($res,$i,"postal_code"), // postal code mysql_result($res,$i,"country_id"), // country id mysql_result($res,$i,"addresses_public"), // show street mysql_result($res,$i,"deleted"), // brother deleted mysql_result($res,$i,"home_number"), // home phone mysql_result($res,$i,"cell_number"), // cell phone mysql_result($res,$i,"phone_public"), // phone public mysql_result($res,$i,"email_address"), // primary email mysql_result($res,$i,"email_address_2"), // alternative email mysql_result($res,$i,"email_public"), // email public mysql_result($res,$i,"employer"), // suffix mysql_result($res,$i,"employer_url"), // url mysql_result($res,$i,"title"), // last updated mysql_result($res,$i,"business_street_1"), // alpha number mysql_result($res,$i,"business_street_2"), // first name mysql_result($res,$i,"business_city"), // first name mysql_result($res,$i,"business_state_region"), // state mysql_result($res,$i,"business_region"), // region mysql_result($res,$i,"business_postal_code"), // last name mysql_result($res,$i,"business_country_id"), // country id mysql_result($res,$i,"business_phone"), // last name mysql_result($res,$i,"retired"), // retired mysql_result($res,$i,"retirement_date"), // retirement date mysql_result($res,$i,"employers_public"), // last updated mysql_result($res,$i,"degree_1"), // last updated mysql_result($res,$i,"major_1"), // alpha number mysql_result($res,$i,"school_1"), // first name mysql_result($res,$i,"year_1"), // first name mysql_result($res,$i,"degree_2"), // middle name mysql_result($res,$i,"major_2"), // last name mysql_result($res,$i,"school_2"), // last name mysql_result($res,$i,"year_2"), // last updated mysql_result($res,$i,"degree_3"), // middle name mysql_result($res,$i,"major_3"), // last name mysql_result($res,$i,"school_3"), // last name mysql_result($res,$i,"year_3"), // last updated mysql_result($res,$i,"degrees_public"), // degrees public mysql_result($res,$i,"aim"), // middle name mysql_result($res,$i,"yahoo"), // last name mysql_result($res,$i,"im_public"), // im public mysql_result($res,$i,"spouse"), // last name mysql_result($res,$i,"comments"), // last updated mysql_result($res,$i,"date_posted") // last updated ); $records[$i+1] = $rec; } //END FOR LOOP for ($row=1;$row<2;$row++) { $tbldat = $records[$row]; echo" "; }//END FOR LOOP echo" BROTHER DATABASE To search for a Brother enter their name (partials allowed) or Alpha number below: Welcome A$_SESSION[ALPHA]     Change password     Update your information     Upload file or photo E-MAIL SITE ADMINISTRATOR "; if ($tbldat[8] == 0){$tbldat[8] = "";} //if big brother value is 0 set to blank echo" "; if ($tbldat[20] = 'Y'){ echo" "; } else{ echo" "; } echo" "; if ($tbldat[23] = 'Y'){ echo" "; } else{ echo" "; } echo" "; if ($tbldat[53] = 'Y'){ echo" "; } else{ echo" "; } echo" "; if ($tbldat[16] = 'Y'){ echo" "; } else{ echo" "; } echo" "; $query_countryname = "SELECT country_name FROM countries WHERE country_id = '$tbldat[15]'"; $res_countryname = mysql_query($query_countryname); $num_countryname = mysql_numrows($res_countryname); $records_countryname[0] = array("country_name"); for ($i_countryname=0;$i_countryname<$num_countryname;$i_countryname++) { $rec_country = array( mysql_result($res_countryname,$i_countryname,"country_name")); $records_countryname[$i_countryname+1] = $rec_country; } //END FOR LOOP for ($row_countryname=1;$row_countryname "; if ($tbldat[37] = 'Y'){ echo" "; } else{ echo" "; } if ($tbldat[35] == 'Y'){ echo" "; } else{ echo" "; } echo" "; $query_businesscountryname = "SELECT country_name FROM countries WHERE country_id = '$tbldat[33]'"; $res_businesscountryname = mysql_query($query_businesscountryname); $num_businesscountryname = mysql_numrows($res_businesscountryname); $records_businesscountryname[0] = array("country_name"); for ($i_businesscountryname=0;$i_businesscountryname<$num_businesscountryname;$i_businesscountryname++) { $rec_businesscountryname = array( mysql_result($res_businesscountryname,$i_businesscountryname,"country_name")); $records_businesscountryname[$i_businesscountryname+1] = $rec_businesscountryname; } //END FOR LOOP for ($row_businesscountryname=1;$row_businesscountryname "; if ($tbldat[50] = 'Y'){ echo" "; } else{ echo" "; } echo" "; $query_rpi = "SELECT email, phone, address, employment, rpi_updated FROM rpi_share WHERE brother_id = '$brother_id'"; $res_rpi = mysql_query($query_rpi); $num_rpi = mysql_numrows($res_rpi); $records_rpi[0] = array("email, phone, address, employment, rpi_updated"); for ($i6=0;$i6<$num_rpi;$i6++) { $rec_rpi = array( mysql_result($res_rpi,$i6,"email"), mysql_result($res_rpi,$i6,"phone"), mysql_result($res_rpi,$i6,"address"), mysql_result($res_rpi,$i6,"employment"), mysql_result($res_rpi,$i6,"rpi_updated") ); $records_rpi[$i6+1] = $rec_rpi; } //END FOR LOOP for ($row=1;$row Brother Information Alpha: $tbldat[0] Name: $tbldat[1] $tbldat[3] $tbldat[4] $tbldat[5] Nickname: Big Brother: $tbldat[8] Phone Numbers Public Public Home Phone: Cell Phone: E-mail Addresses Public Public E-mail Address 1: E-mail Address 2: Instant Messengers Public Public AIM: Yahoo!: Current Home Address Public Public Address Line 1: Address Line 2: City: State: $tbldat[12] Alabama Alaska American Samoa Arizona Arkansas Armed Forces Africa Armed Forces Americas Armed Forces Canada Armed Forces Europe Armed Forces Middle East Armed Forces Pacific California Colorado Connecticut Delaware District of Columbia Federated States of Micronesia Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northern Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming Region: Country: "; if ($tbldat[15] == "211" || $tbldat[15] == "" || $tbldat[15] == "0"){ echo"United States"; } else{ echo"$country_name"; } $query_country = "SELECT * FROM countries"; $res_country = mysql_query($query_country); $num_country = mysql_numrows($res_country); $records_country[0] = array("country_id","country_name"); for ($i_country=0;$i_country<$num_country;$i_country++) { $rec_country = array( mysql_result($res_country,$i_country,"country_id"), // alpha number mysql_result($res_country,$i_country,"country_name") // first name ); $records_country[$i_country+1] = $rec_country; } //END FOR LOOP for ($row_country=1;$row_country"; } echo"$tbldat_country[1]"; } echo" Postal Code: Spouse: Employment Public Public Retired     Date: Retired     Date: Employer: URL: Job Title: Address Line 1: Address Line 2: City: State: $tbldat[30] Alabama Alaska American Samoa Arizona Arkansas Armed Forces Africa Armed Forces Americas Armed Forces Canada Armed Forces Europe Armed Forces Middle East Armed Forces Pacific California Colorado Connecticut Delaware District of Columbia Federated States of Micronesia Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northern Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming Region: Country: "; if ($tbldat[33] == "211" || $tbldat[33] == "" || $tbldat[33] == "0"){ echo"United States"; } else{ echo"$business_country_name"; } $query_bizcountry = "SELECT * FROM countries"; $res_bizcountry = mysql_query($query_bizcountry); $num_bizcountry = mysql_numrows($res_bizcountry); $records_bizcountry[0] = array("country_id","country_name"); for ($i_bizcountry=0;$i_bizcountry<$num_bizcountry;$i_bizcountry++) { $rec_bizcountry = array( mysql_result($res_bizcountry,$i_bizcountry,"country_id"), // alpha number mysql_result($res_bizcountry,$i_bizcountry,"country_name") // first name ); $records_bizcountry[$i_bizcountry+1] = $rec_bizcountry; } //END FOR LOOP for ($row_bizcountry=1;$row_bizcountry"; } echo"$tbldat_bizcountry[1]"; } echo" Postal Code: Business Phone: Education Public Public Degree Type: Major: University: Year Completed: Second Degree: Major: University: Year Completed: Third Degree: Major: University: Year Completed: RPI Exchange of Membership Information Yes, I wish to have my e-mail addresses shared with RPI on a periodic basis. Yes, I wish to have my home phone number shared with RPI on a periodic basis. Yes, I wish to have my home address shared with RPI on a periodic basis. Yes, I wish to have my employment info shared with RPI on a periodic basis. "; } echo" Updates Posted: $tbldat[56] $tbldat[55] [ TOP ]

ALL CONTENT COPYRIGHT © 2006-07 THETA XI FRATERNITY. SITE DESIGN BY VIGCRAFT ARTS; COPYRIGHT © 2006-07 VIGCRAFT ARTS, INC.

"; ?>