php script - results show unwanted blank line - PHP Server Side Scripting forum at WebmasterWorld

I have a script for a address book that I need to tweak. Some members have a physical address (Address1) and a mailing address (Address2), but some members have only one address.
With the script I am using, for those members with only 1 Address and not two, the second "address line" comes up as a blank line. I would like to delete this line altogether but have so far been unable to figure out how to do it.
The script I am using which brings up the empty line is below:

$db_name ="noodle";

$table_name ="Member_Directory";

$connection = @mysql_connect("localhost","noodle","puffballs") or die(mysql_error());

$db = @mysql_select_db($db_name,$connection) or die(mysql_error());

$sql = "SELECT `Letter`,`Name`,`Address1`,`Address2`,`City`,`County`,`State`,`Zip`,`Phone`,`Fax`,`Brands`,`email`,`WebSite` FROM `Members_Directory` ORDER BY 'Name' ";

$result = @mysql_query($sql,$connection) or die(mysql_error());

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

$Name = $row['Name'];
$Address1 = stripslashes($row['Address1']);
$Address2 = stripslashes($row['Address2']);
$City = stripslashes($row['City']);
$County = stripslashes($row['County']);
$State = stripslashes($row['State']);
$Zip = stripslashes($row['Zip']);
$Phone = $row['Phone'];
$Fax = $row['Fax'];
$Brands = stripslashes($row['Brands']);
$email = $row['email'];
$WebSite = $row['WebSite'];

$display_block .= "<P><strong>$Name</strong><br>
$Address1 <br>
$Address2 <br>
$City, $State $Zip<br>
$County <br>
Phone: $Phone<br>
Fax: $Fax<br>
$Brands<br>
<a href=\"mailto:$email\">$email</a><br>
<a href=\"http://$WebSite\">$WebSite</a></P>";

}
?>

<HTML>
<HEAD>
<TITLE>Members List (Ordered by Name)</TITLE>
</HEAD>
<BODY>
<H2>Members List:Ordered by Name</H2>
<? echo "$display_block";?>

</BODY>
</HTML>

I have an additional script that will take out the blank line, but creates another problem in the process, that being it only shows the last member, none of the other members are acknowledged. The script, below, is entered in place of the <? echo "$display_block";?>
which follows the <H2>Members List:Ordered by Name</H2> in the Body of the file.

script:
<?

$db_name ="noodle";

$table_name ="Member_Directory";

$connection = @mysql_connect("localhost","noodle","puffballs") or die(mysql_error());

$db = @mysql_select_db($db_name,$connection) or die(mysql_error());

$sql = "SELECT

`Letter`,`Name`,`Address1`,`Address2`,`City`,`County`,`State`,`Zip`,`Phone`,`Fax`,`Brands`,`email

`,`WebSite` FROM `Members_Directory` ORDER BY 'Name' ";

$result = @mysql_query($sql,$connection) or die(mysql_error());

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

}
?>

<HTML>
<HEAD>
<TITLE>Members List (Ordered by Name)</TITLE>
</HEAD>
<BODY>
<H2>Members List:Ordered by Name</H2>
<P><strong><? echo "$Name";?></strong> <br>
<?
if ($Address1!="") {
echo "$Address1 <br>";
}
if ($Address2!="") {
echo "$Address2 <br>";
}
?>
<? echo "$City, $State $Zip";?> <br>

<?
if ($County!="") {
echo "$County <br>";
}
if ($Phone!="") {
echo "Phone: $Phone <br>";
}
if ($Fax!="") {
echo "Fax: $Fax <br>";
}
if ($Brands!="") {
echo "$Brands <br>";
}
if ($email!="") {
echo "<a href=\"mailto:$email\">$email</a><br>";
}
if ($WebSite!="") {
echo "<a href=\"http://$WebSite\">$WebSite</a><br>";
}

?>
</P>

</BODY>
</HTML>

I've looked that the table very carefully to make sure no unwanted spaces appear to alter the way the info should be displayed and everything appears fine there...

Anyone know why this second script - although listing the info in the manner I want - only brings up the last member and not everyone?....and is there any suggestion on how to correct this?

Thanks muchly for your time.
fiddler

php script - results show unwanted blank line

fiddler

StupidScript

fiddler

fiddler

StupidScript

fiddler

StupidScript

fiddler

StupidScript

fiddler

StupidScript

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week