|
|
Posted by thanos on 07/15/07 02:23
Hello,
Im in a real bind here trying to figure out a solution to my problem.
I have a table which has paging. However, since the data is coming
from a database, I would like for the values in one of the columns to
also include hyperlinks.
Here is my sample code for extracting and displaying the data. Now I
would like to display col1 as a hyperlink, Col1 is just two letter
symbol char(2), however each symbol has its own unique hyperlink. I
have the hyperlink addresses saved in the database as well. Any ideas
would be extremely helpful! Thanks Al
///create query
$query = "SELECT col1, col2, col3 FROM table1 ";
///store results of query
$result = mysql_query($query . $pagingQuery) or die('Error, query
failed');
//display query results
echo '<table width="100%"><tr><td>column1</td><td> column2</td>
<td>column3</td></tr>';
while(list($col1, $col2, $col3) = mysql_fetch_array($result))
{echo "<tr><td>$col1</td><td>$col2</td><td>$col3</td></tr>";
}
echo '</table>';
Navigation:
[Reply to this message]
|