Hyperlinkable SQL Database

andrwleong

Hi

I thought i would sk in this forum in relation to a thread i posted in another section of this website:

hyperlinking PHP/SQL search results

I have created a database and a website. The website has a product page that displays all the Amino Acids etc.

Since the information is pulled from a database I don't know how to make the product name linkable.

I understand I make it linkable in SQl but I am unsure how. Is there any tutorials.

here is a sample ot my database table and data:


CREATE TABLE Product
ProductID VARCHAR(10) NOT NULL,
Category VARCHAR(10) NOT NULL,
Name CHAR(30) NOT NULL,
Manufacturer VARCHAR(30) NOT NULL,
Size VARCHAR(20) NOT NULL,
Price VARCHAR(10) NOT NULL,
Brief_Description VARCHAR(500) NOT NULL,
PRIMARY KEY (ProductID))


INSERT INTOProduct (ProductID, Category, Name, Manufacturer, Size, Price, Brief_Description) VALUES
(‘01’, ‘Amino Acid’, ‘Amino Liquid’, ‘MET RX’, ‘473ml’, ‘£9.96’, ‘MET-Rx Hi-Test Amino Liquid 473ml Cherry’);


I want the Name in this case Amino Liquid to link to the Amino Liquid page.