How to use a $variable that includes html output?

damanic

Hi there,

I have a script that echos data from mysql into a html table. The problem I have is that one of my fields may or may not have data.

So if I echo like this:

echo "<p><a href='$link'>Click here for more info </a></p></td>"

and there is no data in the link table for the result I will get a click here for more info with a root directory link when what I want is for it not to display at all.

So I figured that there might be a way I can make the $link variable output the html aswell so I can just put

echo "$link"

and if the info is not in the table php will not process it.

Does this make sence. Perhaps there is another way.

Help apreciated.

Matt

peppeto

I think you men this
if($link !=""){
$link = $link;
}else{
$link = "SOmething here";
}
echo "<a href='$link'>Click here for more info </a></td>"

damanic

peppeto wrote:
I think you men this
if($link !=""){
$link = $link;
}else{
$link = "SOmething here";
}
echo "<a href='$link'>Click here for more info </a></td>"

Ok so If I was to use that then should there be no info for link in mysql database, I can put in what ever I want right. So link it to a page not available....

This is usefull thanks but let me put this into an example. In the following echo I have a table with multple cells. The bottom cell is there to display a link. However if this link is not available in mysql I would like for the link not to display at all.

As it stands it looks like this:

while ($row = mysql_fetch_array($result)){ 
    $header = $row['header']; 
    $content = $row['content']; 
	$link = $row['link'];
    echo "<table width='90%' border='1' cellspacing='0' cellpadding='5'>
  <tr bgcolor='#006699'>
    <td width='150'><span class='style1'>Header Img </span></td>
    <td><span class='style1'>$header</span></td>
    <td width='150' align='right'><span class='style1'>Date Posted </span></td>
  </tr>
  <tr>
    <td colspan='3'align='left'>$content</td>
  </tr>
  <tr bgcolor='#C1EBFF'>
    <td colspan='3' align='right'>"<p><a href="$link">Click here for more info </a></p>";
} 
?>

So how can I only display a link if there is one available?

qolbu

like peppeto advice,

while ($row = mysql_fetch_array($result)){  

    $header = $row['header'];  

    $content = $row['content'];  

    $link = $row['link']; 
    echo "<table width='90%' border='1' cellspacing='0' cellpadding='5'> 
  <tr bgcolor='#006699'> 
    <td width='150'><span class='style1'>Header Img </span></td> 
    <td><span class='style1'>$header</span></td> 
    <td width='150' align='right'><span class='style1'>Date Posted </span></td> 
  </tr> 
  <tr> 
    <td colspan='3'align='left'>$content</td> 
  </tr> 
  <tr bgcolor='#C1EBFF'>";
   //if link is not empty
   if($link=='') {
      // you can put here what you 
       echo "<td colspan='3' align='right'>";
   } else {    

       echo "<td colspan='3' align='right'><p><a href="$link">Click here for more info  </a></p>";
    }
    }
}  

?>

hope that help

peppeto

then you do something like
<? if($link !=""){
<tr bgcolor='#C1EBFF'>
<td colspan='3' align='right'>"<a href="$link">Click here for more info </a>";
</tr>
}

?>

damanic

Thanks guys.

Golbu your one looks spot on but when I call the page I get a blank. Have I missed something in the formatting? Why are there so many }'s at the end?

Oh ok.. I got it working. It was because of an extra } at the end.