A condition in a mysql_fecth_array

[patlap]

I'm trying to do a mysql_fetch_array with condition in it and was wondering where is the best way to apply the condition.
Inside the array or as a function.

I think that my code will be little more explicit, I hope

                    <?php
                        $sql = 'SELECT * FROM pv ORDER BY region ASC';
                        $resultat = mysql_query( $sql );

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

                        $lieu = $row['lieu'];
                        $adresse = $row['adresse'];
                        $url = $row['url'];
                        $region = $row['region'];
                        $ville = $row['ville'];
                        $info = $row['info'];
                        $tel = $row['tel'];
                        $url = $row['url'];
                        $site = '<a href=http://'.$url.' target="_blank">Site internet</a>';                        
                        $www = if (!empty($url)) {
                        echo $site;
                        };
                        
                            echo "<div class='desbeer'>";
                            echo "<span class='beer'>";
                            echo $row ['lieu'];
                            echo "</span><br/>";
                            echo "<span class='type'>";
                            echo $row ['adresse'];
                            echo "<br />";
                            echo "T&eacute;l.: ";
                            echo $tel;
                            echo "<br />";                    
                            echo $region;
                            echo "</span><br>";
                            echo "<span class='descbeerPh'>";
                            echo $row['ville'];
                            echo "<br />";
                            echo $www;
                            echo "<div>";
                            echo $info;
                            echo "</div>";
                            echo "</span><br>";
                            echo "</div>";
                        }

                ?>

I know it's a mess but I want to have the "$www" printing only if is not empty??

[_Steve_]

if ($url != '') echo '<a href=http://'.$url.' target="_blank">Site internet</a>';

$str = '';
$str .= '<div class="desbeer">';
$str .= '<span class="beer">';
// other lines
echo $str;

[patlap]

Wow!
Much easier than I thought!

Thank you
--------Solved---------

[logic_earth]

Instead of writing all this:

$lieu = $row['lieu'];
$adresse = $row['adresse'];
$url = $row['url'];
$region = $row['region'];
$ville = $row['ville'];
$info = $row['info'];
$tel = $row['tel'];
$url = $row['url']; 

One can just do:

extract($row); 

But there is a catch, you don't want to do this just anywhere. Because it could over write other variables. But if you move it into a function then it is no longer an issue.

[Cups]

                            echo "<div class='desbeer'>";
                            echo "<span class='beer'>";
                            echo $row ['lieu'];
                            echo "</span><br/>";
                            echo "<span class='type'>";
                            echo $row ['adresse'];
                            echo "<br />";
                            echo "T&eacute;l.: ";
                            echo $tel;
                            echo "<br />";                    
                            echo $region;
                            echo "</span><br>";
                            echo "<span class='descbeerPh'>";
                            echo $row['ville'];
                            echo "<br />";
                            echo $www;
                          echo "<div>";
                            echo $info;
                            echo "</div>";
                            echo "</span><br>";
                            echo "</div>"; 

Instead of all that, working out whats single and double quotes etc look at using the heredoc syntax www.php.net/heredoc

$output = EOL<<<
<div class='desbeer'>
<span class='beer'> $row['lieu'] </span>
<br/>
 <span class='type'> $row['adresse'] <br /> T&eacute;l.: 
 $tel <br />$region </span><br>
<span class='descbeerPh'> $row['ville'] <br />
$www 
<div> $info  </div></span><br> </div>
EOL;

echo $output; 

and it respects double quotes!

Then you can echo your $output as and when it suits you, maybe after another sql call etc.

You can also truly see how many nested divs and spans you are using.