$str = array("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"); function toplamsayi($link, $indharf = "A", $durum = 1) { if ($durum == 1) $sql = $link->Get_Query_Result("SELECT COUNT(*) AS SAYI FROM sozcuk T WHERE SUBSTRING(T.sozcuk,1,1) = '$indharf'"); else $sql = $link->Get_Query_Result("SELECT COUNT(*) AS SAYI FROM sozcuk T WHERE T.sozcuk LIKE '%$indharf%'"); //var_dump($sql); return ($sql[0]['SAYI']); } include_once 'includes/db_mysql.inc'; include_once 'includes/connection.php'; $link = new MYSQL($GLOBALS['HOST'], $GLOBALS['USER'], $GLOBALS['PASSWD']); $link->Select_Db($GLOBALS['DBNAME']); $link->Run_Query("SET NAMES 'latin5'"); $link->Run_Query("SET CHARACTER SET latin5"); $link->Run_Query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'"); if (!isset($HTTP_POST_VARS['indharf'])) { $HTTP_POST_VARS['indharf'] = 'A'; } if (!isset($HTTP_POST_VARS['next'])) { $HTTP_POST_VARS['next'] = 15; } $prev = $HTTP_POST_VARS['next'] - 15; if (isset($HTTP_POST_VARS['go']) && ($HTTP_POST_VARS['aramasozcuk'] != "")) { $durum = 2; $HTTP_POST_VARS['indharf'] = $HTTP_POST_VARS['aramasozcuk']; } else $durum = 1; if (strlen($HTTP_POST_VARS['indharf']) > 1) { $islem = "go"; $HTTP_POST_vARS['aramasozcuk'] = $HTTP_POST_VARS['indharf']; $durum = 2; } if (!isset($HTTP_POST_VARS['toplam'])) { $HTTP_POST_VARS['toplam'] = toplamsayi($link, $HTTP_POST_VARS['indharf'], $durum); } ?>