A|B|C List items

[Haggen]

Hi, i have a problem trying to make a "list all" items page. So far i just have A-Z items, but for 0-9# items, i just cant make them show. You can see it in action here: http://www.animerate.net/listado_anime.php it might load slowly, i have more than 1000 items on that list.

Im sure its a query issue, so here is my query.

$sql = "SELECT
mnl_items.config_field_1,
mnl_items.config_field_5,
mnl_items.config_field_6,
mnl_items.config_field_7,
mnl_items.cat_id ,
mnl_items.sub_cat_id ,
mnl_items.item,
mnl_items.item_id,
mnl_items.image_source
FROM mnl_items
WHERE mnl_items.active='yes' AND mnl_items.item LIKE '" . $_GET['letra'] . "%'
ORDER BY item ASC ";


$result_all_items_list = mysql_query($sql);
while($row_item = mysql_fetch_array($result_all_items_list)){
$tempo ++;
if ($tempo / 2 == intval($tempo / 2 ))
{ $background = "#FFFFFF";}
else { $background = "#ECECEC";}

$item = $row_item['item'];
$item_id = $row_item['item_id'];
$cat_id = $row_item['cat_id'];
$sub_cat_id = $row_item['sub_cat_id'];
$config_field_1 = $row_item['config_field_1'];
$config_field_5 = $row_item['config_field_5'];
$config_field_6 = $row_item['config_field_6'];
$number_reviews = $row_item['number_reviews'];
$config_field_7 = $row_item['config_field_7'];

After this of course the echo stuff to print the result row.

So how can i make a no ABC link to show some items that DONT start with ABC?

P.S Dont my english, it sucks i know 😛

[sfullman]

ob_start();
$letterLinks=array();
while( getting the result set ){
$item = 'the thing you sorted by';
//store all actual letter links in array
if(($x=strtoupper(substr($item,1,0)))!==$buffer){
$buffer=$x;
$letterLinks[$x]=true;

//also echo your <a name="$x"></a> here

}

//echo your items as normal

}
$x=ob_get_contents();
//now print out your letter links at the top - loop through a-z, and make it a link ONLY if it is in letterLinks

echo "<br>";

//now flush the list you created:
echo $x;

[Haggen]

Sorry, im not sure i understand everything... Can you please show me an example using my query? 🙁 im newbie sorry.