\n"; if($letter != ''){ if($letter == 'a'){ $query = "SELECT * FROM thumbs WHERE LABEL NOT regexp '^(The|A|An)+( )+[^".$letter."]' AND LABEL NOT regexp '^\"+[^".$letter."]' AND (LABEL regexp '^(The|A|An)+( )+".$letter."' OR LABEL like '".$letter."%' OR LABEL regexp '^[^abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ]' OR LABEL regexp '^(The|A|An)+( )+^[^abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ]') AND (SECTION1 = '".$dir."' OR SECTION2 = '".$dir."' OR SECTION3 = '".$dir."') ORDER BY LABEL ASC;"; }else if($letter == 't'){ $query = "SELECT * FROM thumbs WHERE LABEL NOT regexp '^(The|A|An)+( )+[^".$letter."]' AND (LABEL regexp '^(The|A|An)+( )+".$letter."' OR LABEL regexp '^\"+".$letter."' OR LABEL like '".$letter."%') AND (SECTION1 = '".$dir."' OR SECTION2 = '".$dir."' OR SECTION3 = '".$dir."') ORDER BY LABEL ASC;"; }else{ $query = "SELECT * FROM thumbs WHERE (LABEL regexp '^(The|A|An)+( )+".$letter."' OR LABEL regexp '^\"+".$letter."' OR LABEL like '".$letter."%') AND (SECTION1 = '".$dir."' OR SECTION2 = '".$dir."' OR SECTION3 = '".$dir."') ORDER BY LABEL ASC;"; } }else{ $query = "SELECT * FROM thumbs WHERE (SECTION1 = '".$dir."' OR SECTION2 = '".$dir."' OR SECTION3 = '".$dir."') ORDER BY LABEL ASC;"; } $query_result = $MySQL->query($query); $empty = 1; while($row = mysql_fetch_array($MySQL->sql_result)){ $empty = 0; $regs[3] = ''; eregi("^(The|A|An)+( )+(.*)",$row["LABEL"],$regs); if($regs[3]){ $sorty[]= $regs[3]; #echo "Matched 3: ".$regs[3]."
\n"; }else{ $sorty[] = $row["LABEL"]; } $rows[] = $row; } if($sorty){ foreach($sorty as $val){ $sortarray[] = $val; } array_multisort($sortarray,$rows); } $x = 0; while($rows[$x]){ $link = $rows[$x][3]; $img = $rows[$x][2]; $label = htmlentities($rows[$x][1]); #echo "Link: $link
\n"; #echo "img: $img
\n"; #echo "Label: $label
\n"; #echo "sLabel: $sortarray[$x]

\n"; echo " "; $x++; } # end while list if($empty){ echo " "; } echo "

".$label."

This index is currently empty. Please choose another from the list below.

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

"; ?>