[RESOLVED] Making Mysql data Output a Hyperlink

[akacj]

Hi,

I am a bit stumped on this one. I have a php script where data can get retrieved from a mysql database and it will display it in a table.

I need to hyperlink the Customer Number, so when a user clicks on this number, it will go to the page specified.
This Number is Shown from the database.

echo "<td>" . $row['Customer_Number'] . "</td>";

echo "<table border='1'>
 <tr>
 <th>Customer Number</th>
 <th>First Name</th>
 <th>Last Name</th>
 <th>Phone Number</th>
 <th>Email Address</th>
 </tr>";

while($row = mysql_fetch_array($result))
   {
   echo "<tr>";
   echo "<td>" . $row['Customer_Number'] . "</td>";
   echo "<td>" . $row['First_Name'] . "</td>";
   echo "<td>" . $row['Last_Name'] . "</td>";
   echo "<td>" . $row['Phone_Number'] . "</td>";
   echo "<td>" . $row['Email_Address'] . "</td>";
   echo "</tr>";
   }
 echo "</table>";

mysql_close($con);
  

[bradgrafelman]

akacj;11015231 wrote:

I need to hyperlink the Customer Number, so when a user clicks on this number, it will go to the page specified.
This Number is Shown from the database.

What page? You didn't seem to specify any page.

Regardless, the answer is simple: surround the text you wish to be a hyperlink with <a>...</a> anchor tags and supply the appropriate attributes, namely a 'href' one most likely.