Jump to content

Display initials navigation menu with links or not


Recommended Posts

Hello

 

I wich to make a address book with a initials navigation with link on. No problem until now, it's working perfectly (php + mysql wit Dreamweaver MX2004).

 

Now I wisch to show in my initals naviagtion menu only links where I've entries regarding my address book name field.

 

Per exemple:

A B C D E F G H I J K etc...

 

and i've only entrie on C and J, i wish on C and J a link.

Other not.

 

How it is possible to do that?

A lot of thx for your help and time.

 

Regards, Dom

Link to comment
Share on other sites

im not sure how you would do this using dreamweaver interface but heres a way you should be able to do it using PHP coding

 

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]

$alphabet=(\'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\');

$query=mysql_query(\"select distinct(initial) FROM table\");

while ($r=mysql_fetch_array($query)) {

$initial=$r[\'intial\'];

$links=str_replace(\"$initial\",\"<a href=\\"$initial.php\\">$initial</a>\",$alphabet);

}

echo(\"$links\");

[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

 

that *should* work you will just have to change the table name, field name and so on :)

Link to comment
Share on other sites

Hello

 

I try you code in this way:

<?php require_once('../../Connections/connect.php'); ?>
<?php
mysql_select_db($database_connect, $connect);
$query_rsInitials = "SELECT DISTINCT UPPER(LEFT(organisation,1)) FROM contacts ORDER BY organisation ASC";
$rsInitials = mysql_query($query_rsInitials, $connect) or die(mysql_error());
$row_rsInitials = mysql_fetch_assoc($rsInitials);
$totalRows_rsInitials = mysql_num_rows($rsInitials);
?>
<html>
<head>
<title>Untitled Document</title>
</head>

<body>
<?php
$alphabet=('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');
while ($r=mysql_fetch_array($rsInitials)) {
$initial=$r['organisation'];
$links=str_replace("$initial","<a href=\"$initial.php\">$initial</a>",$alphabet);
}
echo("$links");
?>
</body>
</html>
<?php
mysql_free_result($rsInitials);
?>

 

And I receive for every letter the error:

Notice: Undefined index: organisation in g:\elce\www.website.ch\cms\address\letters.php on line 18

 

Any idea where I'm wrong?

 

Regards, Dom

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.