'; echo '

Search Results For Terms Beginning With - '; echo strtoupper($searchstring); echo '

'; //retrieve info $SQL = "SELECT name, description FROM glossary "; $SQL = $SQL . "WHERE name LIKE '"; $SQL = $SQL . $searchstring . "%' ORDER BY name"; $retid = mysql_query("SET NAMES utf8"); //makes sure result renders correctly $retid = mysql_db_query('bj_poetryforms',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '

---

'; echo ucfirst($row['name']); echo '

'; echo parse_bbcode($row['description']); } echo '

---

'; echo '

Search Glossary by Alphabetical Order

'; echo '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'; echo '

---

'; echo ''; echo '

 

'; echo '

'; echo ''; echo '
Social Bookmarks'; echo '