Hello,
I am trying to add hyperlink to my mysql query result. I have a table called EastLondon which consist of the following:
(restaurant_id INT UNSIGNED PRIMARY KEY, restaurant_name VARCHAR(20), phone_number VARCHAR(20), picture varchar(8), website varchar(40));
I extract all these info into a table using php. What I want to do is add the actual hyperlink to 'website' results. I have the following code but it doesn't work:
foreach ( $restaurants as $row ) {
echo '<table width="400" border="1" cellspacing="2" cellpadding="2">';
echo '<tr><th width="200">Restaurant Name </th>';
echo '<td width="200">'.$row['restaurant_name'].'</td></tr>';
echo '<tr><th width="200">Telephone Number </th>';
echo '<td width="200">'.$row['phone_number'].'</td></tr>';
echo '<tr><th width="200"><img src="./image/'.$row["picture"].'" width="100" height="131" ></th>';
echo '<a href="'.$row['website'].'">'.$row['website'].'</a>';
echo '</table>';
}