Jump to content

Syntax for creating mailto from MySQL Database query


feddie1984

Recommended Posts

Can someone help me with the correct syntax for turning the field requester_email into a mailto link?

 

while($row = mysql_fetch_array($qry_result)){
$display_string .= "<tr>";
$display_string .= "<td>$row[iD]</td>";
$display_string .= "<td>$row[requester_name]</td>";
$display_string .= "<td>" .  <a href='mailto:' . $row[requester_email] . '>' . $row[requester_email] . "</a>" . "</td>";
$display_string .= "<td>$row[todays_date]</td>";
$display_string .= "<td>$row[start_Date]</td>";
$display_string .= "<td>$row[End_Date]</td>";
$display_string .= "<td>$row[Department]</td>";
$display_string .= "<td>$row[No_Engineers_Required]</td>";
$display_string .= "<td>$row[Prefered_Engineers]</td>";
$display_string .= "<td>$row[Customer_Name]</td>";
$display_string .= "<td>$row[Location]</td>";
$display_string .= "<td>$row[Type_Of_Job]</td>";
$display_string .= "<td>$row[Job_Ref_No]</td>";
$display_string .= "<td>$row[Additional_info]</td>";
$display_string .= "</tr>";

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.