Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- paging with column hyperlinks
July 15, 2007, 2:23 am
rate this thread
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
$query = "SELECT col1, col2, col3 FROM table1 ";
///store results of query
$result = mysql_query($query . $pagingQuery) or die('Error, query
//display query results
echo '<table width="100%"><tr><td>column1</td><td> column2</td>
while(list($col1, $col2, $col3) = mysql_fetch_array($result))
Re: paging with column hyperlinks
Add the link as an href in your table, i.e. assuming the link is in
'col4', retrieve that column. Then just
echo "<tr><td><a href='$col4'>$col1</td>.......";
Remove the "x" from my email address
JDS Computer Training Corp.