About Gale Virtual Reference Library
Provides access to nearly 100 complete reference works, including encyclopedias, dictionaries and handbooks.
Instantly access full-text eBooks on and off campus.
To get started, watch the Gale Virtual Reference guided tour. »
Title List
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
'; $count=0; while ($row = mysql_fetch_array ($result)) { //get first letter of $row['name'] without "The" //prevent trimming of Theater - and other words that begin with "the" - The \b in the pattern indicates a word boundary, so only the distinct word "the is matching and not Theater. if (preg_match('/\The\b/i',$row['name'])) { $dbtitle=trim($row['name'], "The "); } else { $dbtitle=$row['name']; } $first_letter = $dbtitle[0]; //compare to see if the first letter is new if ($first_letter_compare!==$first_letter) { //add anchor echo ''; echo ''.$first_letter.' back to top
'; } $first_letter_compare=$first_letter; echo 'Total: ' . $count.'
'; mysql_close($dbc); ?>