Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Hyperlink data in my table
03-30-2014, 11:37 PM #1
- Join Date
- Mar 2014
- Thanked 0 Times in 0 Posts
Hyperlink data in my table
Hey, i'm relatively new with MySQL so bare with me...
I have a form on my website where users will input two fields, a websites name (e.g., Google) and a website url (e.g., https://www.google.com/)
This form stores data in my database table "websites" with 3 columns(id, website, url)
I'm looking to retrieve just the website names to show up on my page but have them linked to the url associated with them.
The short story
Users input 2 fields (website name and url)
Which is stored in my db
I want to recall the "website name" to my front end
but have it linked to the given url.
04-01-2014, 10:21 PM #2
- Join Date
- Jan 2011
- Thanked 734 Times in 732 Posts
SELECT `url` FROM table WHERE `WEBSITE` = "website name";
Of course when you store them you should check for duplicates
Evolution - The non-random survival of random variants.
Soon to not be a resident of Missouri - hitting the road for better pastures.