[insert_php]
global $wpdb;
for($i=0; $i<26; $i++) {
$chr = chr(ord('A')+$i);
$cnt = $wpdb->get_var(“SELECT count(*) FROM green_links WHERE `show`=’y’ AND title LIKE ‘$chr%'”);
if($cnt>0) {
print “
$chr “;
}
else {
print “
$chr “;
}
}
[/insert_php]
[insert_php]
for($i=0; $i<26; $i++) {
$chr = chr(ord('A')+$i);
$items = $wpdb->get_results(“SELECT * FROM green_links WHERE `show`=’y’ AND title LIKE ‘$chr%’ ORDER BY title”);
if(count($items)<=0) continue;
print "| $chr | | [ top ] |
“;
print ‘| |
‘;
foreach($items as $item) {
print ““;
print “| url\” target=_blank>$item->title | “;
print “
“;
print “| $item->desc |
“;
if(strlen($item->url) > 40) $url = substr($item->url, 0, 37) . ‘…’;
else $url = $item->url;
print “| [ url\” target=_blank>$url ] |
“;
print ‘| |
‘;
print ‘| |
‘;
}
}
[/insert_php]
