Parsing URLS

[redrock]

hello this is the code im using and it is working perfectly

 <?
require("dbconn.php");


$sql=("SELECT em_members.em_member_name,em_members.em_icq,em_members.em_homepage,em_members.em_aim FROM em_members");

$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 

echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
    echo '<td>'.$rows['em_member_name'].'</td>';
    echo '<td>'.$rows['em_icq'].'</td>';
    echo '<td>'.$rows['em_homepage'].'</td>';
    if ($i++%1 == 0) {
        echo '</tr><tr>';

} 
}

echo '</tr></table>';
?>

This is information gathered from a form.WHen the person fills out the form their icq ,if they have one,their member name and their homepage shows on a webpage.WHat i am wanting to do is make their icq # directly go to a link that will add them,i already have the link.an for their homepage i have a small gif i want to show up that will automatically put their url into it..Is this possible?

[kevinsequeira]

well, im not sure what you need but if you want to make an image a link with the icq number a link then do this

<?php
if($rows['em_icq']!=""){
?>
	<a href="your_link.php?icq_number=<?php print($rows['em_icq']);?>"><img src="your_image.gif"></a>
<?php
}
?>

and the homepage a link

<?php
if($rows['em_homepage']!=""){
?>
	<a href="your_link.php?home_page=<?php print($rows['em_homepage']);?>">homepage link</a>
<?php
}
?>

reg
kevin