paging with column hyperlinks

[thanos]

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($qu ery . $pagingQuery) or die('Error, query
failed');

//display query results
echo '<table width="100%"><t r><td>column1</td><tdcolumn2</td>
<td>column3</td></tr>';
while(list($col 1, $col2, $col3) = mysql_fetch_arr ay($result))
{echo "<tr><td>$c ol1</td><td>$col2</td><td>$col3</td></tr>";
}
echo '</table>';

[petersprc]

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=\"{$url}\" >$a</a>";

On Jul 14, 10:23 pm, thanos <inlov...@hotma il.comwrote:

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($qu ery . $pagingQuery) or die('Error, query
failed');
>
//display query results
echo '<table width="100%"><t r><td>column1</td><tdcolumn2</td>
<td>column3</td></tr>';
while(list($col 1, $col2, $col3) = mysql_fetch_arr ay($result))
{echo "<tr><td>$c ol1</td><td>$col2</td><td>$col3</td></tr>";}
>
echo '</table>';

[Jerry Stuckle]

Re: paging with column hyperlinks

thanos wrote:

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($qu ery . $pagingQuery) or die('Error, query
failed');
>
//display query results
echo '<table width="100%"><t r><td>column1</td><tdcolumn2</td>
<td>column3</td></tr>';
while(list($col 1, $col2, $col3) = mysql_fetch_arr ay($result))
{echo "<tr><td>$c ol1</td><td>$col2</td><td>$col3</td></tr>";
}
echo '</table>';
>

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'>$c ol1</td>.......";

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===