Jump to content

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

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 :)

intial is just the field, i was working along the lines that you already have an intial field

273597[/snapback]

 

I see! I'n only a field "Organisation" wich I must extract the first letter (don know how, but I will find!).

 

Thx, Dom

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

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.