|
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 | |
1){
$sql = "SELECT * FROM bos_links WHERE (active=1) AND (sitename LIKE '".$_GET['alpha']."%') ORDER BY sitename ASC";
}else{
if(isset($_GET['alpha']) && $_GET['alpha']==1){
$sql = "SELECT * FROM bos_links WHERE (active=1) AND (sitename NOT LIKE 'a%') AND (sitename NOT LIKE 'b%') AND (sitename NOT LIKE 'c%') AND (sitename NOT LIKE 'd%') AND (sitename NOT LIKE 'e%') AND (sitename NOT LIKE 'f%') AND (sitename NOT LIKE 'g%') AND (sitename NOT LIKE 'h%') AND (sitename NOT LIKE 'i%') AND (sitename NOT LIKE 'j%') AND (sitename NOT LIKE 'k%') AND (sitename NOT LIKE 'a%') AND (sitename NOT LIKE 'a%') AND (sitename NOT LIKE 'a%') AND (sitename NOT LIKE 'l%') AND (sitename NOT LIKE 'm%') AND (sitename NOT LIKE 'n%') AND (sitename NOT LIKE 'o%') AND (sitename NOT LIKE 'p%') AND (sitename NOT LIKE 'q%') AND (sitename NOT LIKE 'r%') AND (sitename NOT LIKE 's%') AND (sitename NOT LIKE 't%') AND (sitename NOT LIKE 'u%') AND (sitename NOT LIKE 'v%') AND (sitename NOT LIKE 'w%') AND (sitename NOT LIKE 'x%') AND (sitename NOT LIKE 'y%') AND (sitename NOT LIKE 'z%') ORDER BY sitename ASC";
}else{
$sql = "SELECT * FROM bos_links WHERE (active=1) ORDER BY sitename ASC";
}
}
$status=mysql_query("$sql") or die (mysql_error());
while ($row = mysql_fetch_array($status)){
?>
|
|
|
|
|
