paging with column hyperlinks

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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

//display query results
echo '<table width="100%"><tr><td>column1</td><td> column2</td>
while(list($col1, $col2, $col3) = mysql_fetch_array($result))
{echo "<tr><td>$col1</td><td>$col2</td><td>$col3</td></tr>";
echo '</table>';

Re: paging with column hyperlinks

Your query can fetch the URL by doing a join:

select a.x,y.z,b.url from a, b where a.x = b.x

Then when you print the results:

echo "<a href=\"\">$a</a>";

Quoted text here. Click to load it

Re: paging with column hyperlinks

thanos wrote:
Quoted text here. Click to load it

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
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline