can any one tell me how to put a link to a web site in to a field in a database i copied and pasted one but it wasnt active cheers Doug
hehe.. do you understnad sql queries or atleast phpMyAdmin? Instead of giving a one word answer, I recommend you to pick up some sql basics, mysql administration though phpMyAdmin and basics about php/mysql interface. Without that you may not be able to do much. Putting something into a field using phpMyAdmin is plain simple. But diagnosting your problem is not!
Most databases do not support hyperlinks. It's just not a datatype. You can only enter it as nchar, nvarchar, text, etc. If you want to take a url from the database to a webpage and have it active you need to enclose the data in the correct tags, or you can include the tags in the database so instead of using http://www.domain.com in the databse, use <a href="http://www.domain.com" >Anchor Text</a> Hope that helps
the magic command is "insert into", and datatype varchar(255) should be enought for most cases. http://www.w3schools.com/sql/sql_insert.asp - but this is probaly useless if you dont know the basics.
You can also use http://www.domain.com in the database And in fact it will take less space, then output it like <a href="<here goes the variable from DB>" >Anchor Text</a> Depends on what you need to achieve, if the field is only for links, then this method is better, if it's mixed with text - then use gazu's method.