Query question

[Anon]

Hi fellow flashers,
If i were to have the following php query:

$query = "SELECT * FROM alist WHERE list_id = $id";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "<b>{$row['List_Name']}</b><BR>";
echo "{$row['address']}, {$row['state']}<BR>{$row['post_code']}<BR>Tel: {$row['phone']}<BR><BR>";
echo "{$row['Info']}<BR>";
echo '</blockquote>';

....how can i get the data from those rows that have data.
For example, some rows won't have a 'phone' value so i don't want this to leave a blank area when it comes to outputting the rsults.
What do i need to add to my script inorder to achieve this?

Thanx...suzy_Q

[stueee]

"so i don't want this to leave a blank area when it comes to outputting the rsults"

What do you want to output instead of a blank area? Just trying to understand what you want to do first.

[Anon]

Thanks for the reply...

If there is no value to output i don't want it to leave a space. At the moment if a paricular row doesn't have a value the output displays a blank space.

ie. echo "<BR>Tel:{$row['phone']}";
The Tel: part of the script shows but no value. That's fine if there is no value to display but how can i hide the Tel: part of the script?

[khaine]

You could put it in an if statement. i.e.

if ( !empty($row['phone']) )
{
echo "<BR>Tel :{$row['phone']}";
}

Then the header tel will only be output if the phone number is present.

Mark.