I am pulling my hair out trying to add an email link into this query. I almost had it, but it seems to link everything from email down and without the email address being linked. This is NOT the same question I had before if someone is wondering why I started a new thread. This is completely a different link issue. Here's my query and you'll see email half way through the string. Oh, and you're probably wondering why I mingled html in the CONCAT query. Long story!!! Here's the string and thanks
$query = "SELECT CONCAT(yacht_name, '<p><br><b>Position:</b></p> ', position, '<p><br><b>Motor or Sail:</b></p> ', motor_sail, '<p><br><b>Length of Yacht:</b></p> ', length, '<p><br><b>Salary:</b></p> ', salary, '<p><br><b>Location:</b></p> ', location, '<p><br><b>Start Date:</b></p> ', start_date, '<p><br><b>Comments:</b></p> ', comments, '<td valign=top><p><br><b>Name of Contact:</b></p> ', name_contact, '<p><br><b>Phone 1:</b></p> ', phone_1, '<p><br><b>Phone 2:</b></p> ', phone_2, '<p><br><b>E-Mail:</b></p> ', email, '<p><br><b>Ticket(s) Required:</b></p> ', ticket, '<p><br><b>Position Filled:</b></p> ', position_filled, '<p><br><b>Date Registered:</b></p> ', DATE_FORMAT(registration_date, '%d %M %Y')) FROM users WHERE user_id=$id";