mysql hyperlinks

Tim_L

I'm creating a table with a field which will recommend available online shops to visit for that specific product.

I've set the TYPE to ENUM, but do I have to enter the full hyperlink address of the online shop into the DEFAULT or is their another way so that a link appears on the page.

I hope this makes sense....

mystrymaster

when you select it out of the db you can format it then

so you store it in the db as

amazon

and when it is selected from teh db you can do

echo "<a href='http://www." . $queryResult . ".com'>" . $queryResult . "</a>";

Make sense

Tim_L

Yes thanks, it makes sense, except for the

"...when it is selected from the DB..."

As you know i'm working in DW, but what do you mean by this term. Would I put that on the product detail page? Sorry if this is very simple!

mystrymaster

allright store the sites basic name in the db

Store table
ID | Name
1 | amazon
2 | buy
3 | fogdog

then on the page

$query = "SELECT Name from Store";

$getData =mysql_query($query) ;
WHILE ($outputdata = mysql_fetch_array($getData) {

echo "<a href='http://www." . $outputdata[0] . ".com'>" . $outputdata[0] . "</a>";
}

Help any?

Tim_L

thanks I'll give it a try!

yelvington

Tim, the purpose of the ENUM data type is to allow you to specify a list of legal values. Putting anything into the database that isn't on that short, defined list is an error. That might sound like it's appropriate for what you're trying to do ... but it's not.

If I understand the original question, you're jumping into the deep end of the pool without learning how to dog paddle first.

You have objects for sale that can be obtained from more than one supplier? And presumably one supplier sells more than one object?

This is a data modeling problem, and you need to understand how to design database tables before you start writing code.

There are a lot of books and tutorials on the subject. I typed "relational data modeling" into Google and found the following link, which looks very good:

http://www.utexas.edu/its/windows/database/datamodeling/rm/overview.html

Tim_L

thanksf or your advice. I'm not actually selling any products that's why I need to put in recommended stores. However, it is just about the same as you say.

I'll have a read through that article and see if i understand any of it. Is there an easy way to explain how to link to tables in a DB?