$glos_page = $_GET['glos_page']; $glos_item = $_GET['glos_item']; if (!isset($glos_page)) { $glos_page = '0'; } if ($glos_page == '') { $glos_page = '0'; } if ($glos_item != '') { $glos_page = substr($glos_item,0,1); } $server="localhost"; $user="CAS"; $pw="lotuselanK1!"; #$server="dm-scottc-w2k"; #$user="cas"; #$pw="cas"; #$cn = mssql_connect ($server,$user,$pw) or die('bollocks'); $cn = mysql_connect ($server,$user,$pw) or die('bollocks'); mysql_select_db("csdb"); #mssql_select_db("CASTemp"); # Get an array of all the glosary terms and their respective links $sqlq = "select * from csdl_glos order by glos_name"; #$rs = mssql_query($sqlq); #$NumRows = mssql_num_rows($rs); $rs = mysql_query($sqlq); $NumRows = mysql_num_rows($rs); $glos_links = array(); for ($i=0;$i<=$NumRows;$i++) { # $k = mssql_fetch_row($rs); $k = mysql_fetch_row($rs); # $glos_links[strtoupper($k[1])] = "".strtoupper($k[1]).""; # $glos_links[strtolower($k[1])] = "".strtolower($k[1]).""; # $glos_links[ucwords($k[1])] = "".ucwords($k[1]).""; $glos_links[strtoupper($k[1])] = "".strtoupper($k[1]).""; $glos_links[strtolower($k[1])] = "".strtolower($k[1]).""; $glos_links[ucwords($k[1])] = "".ucwords($k[1]).""; if (ucwords($k[1]) != ucfirst($k[1])) { $glos_links[ucfirst($k[1])] = "".ucfirst($k[1]).""; } } echo "\n"; echo "
\n"; echo "\n"; echo "Glossary
\n"; echo "\n"; echo "[1-9]\n"; for ($i=65;$i<=90;$i++) { echo "[".chr($i)."]\n"; } echo "
\n"; if ($glos_page != '0') { $sqlq = "select * from csdl_glos where glos_name like \"".$glos_page."%\" order by glos_name"; } else { $sqlq = "select * from csdl_glos where glos_name like \"0%\""; $sqlq .= " or glos_name like \"1%\""; $sqlq .= " or glos_name like \"2%\""; $sqlq .= " or glos_name like \"3%\""; $sqlq .= " or glos_name like \"4%\""; $sqlq .= " or glos_name like \"5%\""; $sqlq .= " or glos_name like \"6%\""; $sqlq .= " or glos_name like \"7%\""; $sqlq .= " or glos_name like \"8%\""; $sqlq .= " or glos_name like \"9%\" order by glos_name"; } #$rs = mssql_query($sqlq); #$NumRows = mssql_num_rows($rs); $rs = mysql_query($sqlq); echo mysql_error(); $NumRows = mysql_num_rows($rs); for ($i=0;$i<$NumRows;$i++) { # $k = mssql_fetch_row($rs); $k = mysql_fetch_row($rs); reset($glos_links); $useme = $k[1]; while (list ($key, $val) = each ($glos_links)) { if ($key != $k[1]) { $k[1] = str_replace($key,$val,$k[1]); $k[2] = str_replace($key,$val,$k[2]); } } echo "\n"; } echo "\n"; echo "\n"; echo "\n"; ?>