Overzicht winkels op alfabet' . "\n"; $alphabet = range(A,Z,1); foreach($alphabet AS $letter) { // query $sql = "SELECT `name`, `url_name` FROM `advertiser` WHERE `name` LIKE '".$letter."%' AND `status_id` = 1 ORDER BY `name` LIMIT 99"; $qry = mysql_query($sql); // sys - information $int = mysql_num_rows($qry); // check if($int > 0) { echo '

'.$letter.'

'; echo '' . "\n"; echo '
' . "\n"; } else { //echo '

(geen)

' . "\n"; } } // database echo disconnect_db(); // footer include_once 'footer.php'; ?>