How to insert a href from database results..
How to insert a href from database results..
polomintus
Posts: 3Questions: 0Answers: 0
Hi All
First of I love datatables, its easy and works like a dream. The problem/question I have is method of working better.. Atm the moment i'm storing www sites within my database but the problem i fear is the size of the database. Because I'm putting the html code within the database i'm sure this is putting unnesscary data into the database and slowing down the fetch.
For example lets say col 5 within my SQL database contains site links, I've put [code]Visit[/code]
As you can see i'm including the full html code so when it fetchs the data it outputs the link.. this is ideal if the database was small but since its growing im sure this will lead to problems..
What I want to do is simply store in col 5 within the database just the weblink so for example
www.Datatables.net
Then on the output results, display it as Visit, and also a href it as a blank page...
Does anyone know a better way of doing what I want to do.. ie via a script of somesort. Sorry if this is 010101 basics to some people, any help is appericated.
Thanks
First of I love datatables, its easy and works like a dream. The problem/question I have is method of working better.. Atm the moment i'm storing www sites within my database but the problem i fear is the size of the database. Because I'm putting the html code within the database i'm sure this is putting unnesscary data into the database and slowing down the fetch.
For example lets say col 5 within my SQL database contains site links, I've put [code]Visit[/code]
As you can see i'm including the full html code so when it fetchs the data it outputs the link.. this is ideal if the database was small but since its growing im sure this will lead to problems..
What I want to do is simply store in col 5 within the database just the weblink so for example
www.Datatables.net
Then on the output results, display it as Visit, and also a href it as a blank page...
Does anyone know a better way of doing what I want to do.. ie via a script of somesort. Sorry if this is 010101 basics to some people, any help is appericated.
Thanks
This discussion has been closed.