|
Greek Councils
For Current Members
For Prospective Members and Parents
|
# This script will list all the tables in the specified data source.
# Connect to the data source and get a handle for that connection.
# http://www.sql-tutorial.net
$hostname = "sdessql1.sdes.ucf.edu";
$username = "fslife";
$password = "fs153$2!";
$dbName = "FSLife";
if (!mssql_connect($hostname,$username,$password)){
if (phpversion() < '4.0'){
exit("Connection Failed: . $php_errormsg" );
}
else{
exit("Connection Failed:" . odbc_errormsg() );
}
}
# Retrieves table list.
mssql_select_db($dbName) or DIE("Table unavailable");
$ifcformquery = "SELECT * FROM FSLChapters WHERE council = 'Interfraternity Council'";
$nphcformquery = "SELECT * FROM FSLChapters WHERE council = 'National Pan-Hellenic Council'";
$panformquery = "SELECT * FROM FSLChapters WHERE council = 'Panhellenic Council'";
$dgcformquery = "SELECT * FROM FSLChapters WHERE council = 'Diversified Greek Council'";
$ifcformresult = mssql_query( $ifcformquery );
$nphcformresult = mssql_query( $nphcformquery );
$panformresult = mssql_query( $panformquery );
$dgcformresult = mssql_query( $dgcformquery );
//print( "Found the table FSLForms" + mssql_num_rows( $result ));
//print("\n");
//foreach ($January 24, 2007 12:49 PMt( "")January 24, 2007 12:49 PMpe=text/css January 24, 2007 11:41 AM>Fraternity & Sorority Life Chapters" );
print( "
" ); print( "
" ); print( "
" ); print( "
|



