create link

Alidad

hi, i have created database for insert news information (news_Name and URL address), and I created retrieve news and url address from database, but how can i write code to automatic create link.

For smaile news_name is cnn and on word of cnn is http://www.cnn.com.

how can i write that code for that!

dagon

echo '<a href="'.$row[url].'">'.$row[news_Name ].'</a>';

Alidad

I'm getting error message, i know there is something wrong wrong with incorrect name of tables.

the tables called HomeNews and there are two column is called "News_Name , News_URL" so please correct if this is correct the way i should write code to make link works...

<?php echo '<a href="'.$row_HomeNews[News_URL].'">'.$row_HomeNews[News_Name ].'</a>'; ?>

Is this is correct! because is till not working right.... did i missed anything!

dagon

how are you extracting the data from the db?

Alidad

I use dreamweaver, is works great wih two of those column which is "News_name, News_URL) but then I want to change to have link using echo, i can't think of how to write that code, i have done everyhting is not working.
Any idea!