Links

[redrock]

I am trying something on a members page i have on my website.I am trying to make it where the icq # is a link if they have it an if not i am wanting it to put in "NA".I am also trying to do the same with there homepage.Im sure its a simple thing an its just something im overlooking.Please help.

<?

require("dbconn.php");
require("./members.html");


$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 = "10" CELLSPACING = "10" CELLPADDING = "10" WIDTH = "100%" MYSW_TABLETYPE = "TT_PERCENT" MYSW_TABLEREN = "RT_CERN"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
echo '<td>'.$rows['em_member_name'].'</td>';

echo '<td>'.$rows['em_icq'].'</td>';    

$icq = $row;
if ($icq == "n/a") {
$icqnumber = "n/a";
$icqpic = "";
}
else {
$icqnumber = "$icq";
$icqpic = "<a href='http://wwp.icq.com/scripts/Search.dll?to=$icq'><img border='0' src='http://web.icq.com/whitepages/online?icq=$icq&img=5' align='absmiddle'></a>";
}

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

} 

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

[DigitalExpl0it]

<?

require("dbconn.php");
require("./members.html");


$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 = "10" CELLSPACING = "10" CELLPADDING = "10" WIDTH = "100%" MYSW_TABLETYPE = "TT_PERCENT" MYSW_TABLEREN = "RT_CERN"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
echo '<td>'.$rows['em_member_name'].'</td>';
//Look Here ----------------------------------
echo '<td>'.$rows['em_icq'].'</td>';    

if ($rows['em_icq'] == "n/a") {
$icqnumber = "n/a";
$icqpic = "";
} else {
$icqnumber = $rows['em_icq'];
$icqpic = "<a href='http://wwp.icq.com/scripts/Search.dll?to=".$rows['em_icq']."'><img border='0' src='http://web.icq.com/whitepages/online?icq=$icq&img=5' align='absmiddle'></a>";
}
//Ive added somthings -------------------------

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

} 

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

[DigitalExpl0it]

look here

$icq = $row;
if ($icq == "n/a") {
$icqnumber = "n/a";
$icqpic = "";
}

what does $row have???

if you mean $rows you can do that must be $rows["field_here"];

[redrock]

Still not linking to i must be a little on the slow side here.What am i missing?

<? 

require("dbconn.php"); 
require("./members.html"); 


$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 = "10" CELLSPACING = "10" CELLPADDING = "10" WIDTH = "100%" MYSW_TABLETYPE = "TT_PERCENT" MYSW_TABLEREN = "RT_CERN"><tr>'; 

$i = 0; 
while ($rows=mysql_fetch_array($result)){ 
echo '<td>'.$rows['em_member_name'].'</td>'; 

echo '<td>'.$rows['em_icq'].'</td>';     

if ($rows['em_icq'] = "n/a") { 
$icqnumber = "n/a"; 
$icqpic = ""; 
} else
 { 
$icqnumber = $rows['em_icq']; 
$icqpic = "<a href='http://wwp.icq.com/scripts/Search.dll?to=".$rows['em_icq']."'><img border='0' src='http://web.icq.com/whitepages/online?icq=$icq&img=5' align='absmiddle'></a>"; 
} 


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

}  

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