A to Z dynamic listing

@vicpal25Jan 27.2005

I have 500 names on a database and I created a static A-Z html listing that anchors dynamically to a variable link in my query

[code=php] $anchorlink = strtolower(substr($lastname, 0, 1));

if ($tempanchor != $anchorlink) { print(“<h3><a name=”$anchorlink”></a>”.strtoupper($anchorlink).”</h3>n”); } [/code]

I noticed that there is no last names that end with a ‘U’ so I have to make my A to Z list dynamically to check if a record with that list exists and make the link active or not-active depending on the availability of the record. Does anyone know on how to go about this? I know I have to check with a query to see if the record exists from a table and then i dont know.put it in a for loop? any suggestions are welcomed! thanks!

to post a comment

PHP

@ShrineDesignsJan 27.2005 — #trySELECT COUNT(last_name LIKE '%a') FROM table

@vicpal25authorJan 27.2005 — #nope that just counts how may records are there in the table, i need to check if any names that start with an A and check true and then check for B and then true and then C if not then false and so forth. I dont know if i can do this with a query.

@ShrineDesignsJan 27.2005 — #this works, but you would need to send 26 queries to the serverSELECT COUNT(*) FROM <span><code>table</code></span> WHERE <span><code>last_name</code></span> LIKE '%a'i think if you query the entire table then use a reg exp it would be more efficient

[code=php]<?php
 $db = mysql_connect('localhost', 'root', '');
 mysql_select_db('dbname', $db);
 
 $result = mysql_query("SELECT last_name FROM table ORDER BY last_name ASC");
 $names = array();
 $count = array();
 
 for($i = 0; $i < 26; $i++)
 {
 $count[chr(97 + $i)] = 0;
 }
 while($row = mysql_fetch_array($result, MYSQL_NUM))
 {
 $names[] = $row[0];
 
  if(preg_match("/^[a-z]{1}/i", $row[0], $match))
  {
   $count[strtolower($match[0])] += 1;
  }
 }
 print_r($count);
 ?>[/code]

@george1234Jan 28.2005 — #If you have a frontend for your database, so that everything already has its own page etc. you could take alook at a tool like HTML Indexer: http://www.html-indexer.com/

A to Z dynamic listing

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

A to Z dynamic listing

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴