[mrlocom]

concerning about my page http://www.mrlo.com/1.htm , i want to make hyperlinks , for example the word "abnegation" in line 3 , i want to link to a page http://encarta.msn.com/dictionary_/abnegation.html .

i use frontpage and of course i know how to create a single hyperlink , but i don't want to create all the link in the page http://www.mrlo.com/1.htm manually because it is too time consuming. Can anyone suggest a HTML code that can automatically create all the hyperlinks ? Each links are the same with http://encarta.msn.com/dictionary_/xxxxx.html , the only difference is the words in the "xxxxx" substitute for each different words inside the page.

Hope you can understand my question and offer me some help.


Thanks

[kjmatthews]

There is no "HTML code" to do that kind of thing. Remember that HTML is not code, it is "markup," and as such only describes what is there, not how it acts or how it looks.

To do what you want - dynamically add hyperlinks to each word - you would need to use some kind of server-side language (like PHP or ASP) that can generate the links for you and spit them out as HTML.

[mrlocom]

can anyone help me ? PHP or other language is ok .

thanks

[kjmatthews]

Do you have access to MySQL and databases on your server?

[mrlocom]

yes , i am using CPanel 10.0 with all the features with unlimited MySQL .

[kjmatthews]

The best way I can think of would be to put all the words into a database and pull them out alphabetized and dynamically generate the links. This would be a really easy script to write - a matter of a couple hours, if that. I'm sure someone in the PHP forums would be happy to write one for you, but honestly, you could write this yourself with a book and some study. And then you'd have the bonus of knowing a little PHP/MySQL and being able to use that in the future!

[mrlocom]

please offer me some help . i would be grateful for that . thanks.

[kjmatthews]

Like I said, writing the PHP script is easy, and giving it to you here is just letting you stay uninformed:

PHP Code:

<?php

//insert your "connect to database" function here



//get words in alphabetical order from database named "tablename"

$sql = "select * from tablename order by name";

$query = mysql_query($sql);

$number_words = count($query);

$result = mysql_fetch_array($query);



/*now loop the result $query for however many words there are and display the resultant link*/

for ($i=0; $i<$number_words; $i++) {

 $word = $result[$i];

 echo("<a href=\"http://encarta.msn.com/dictionary_/$word.html\">$word</a><br />");

}

?>

This will list all the words in your database in on long column, complete with links. To sort them all into rows as you have done, well, that takes a little more work.

What we can't do for you is set up your database. You'll have to do that for yourself, whether through your web hosts control panel or whatever. This book should be all the help you need and more, both to modify the above script for your needs and to set up this and future databases. You should post any questions you have in the PHP forum.

[rdprogrammer]

this could be done in javascript i think, ask in those forums