display only populated fields help

[michaelowen]

hello everybody,

I am having problems displaying only populated fields within my fetched array.

What i want my if/else statement to say is "if there are website past results available, then display....if not, leave empty".

here is the entire code.....the part in question is at the bottom.

---

<?php

$db = mysql_connect("localhost", ".....", ".....");

mysql_select_db("......",$db);

echo "<table width=100% border=0>";
$run_query = "SELECT * FROM calendar order by event_state, month, day";
$run_result = mysql_query($run_query);
echo "<tr><td><center><font size=+2 color=red>....... Events Calendar: </font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
while($run_row = mysql_fetch_array($run_result)){
$mydatarunname = $run_row['name'];
$mydatarunstart = $run_row['event_start'];
$mydataruncategory = $run_row['category'];
$mydataruncategoryother = $run_row['category_other'];
$mydatarundescription = $run_row['description'];
$mydataruneventone = $run_row['event_one'];
$mydataruneventtwo = $run_row['event_two'];
$mydataruneventthree = $run_row['event_three'];
$mydatarundistanceone = $run_row['distance_one'];
$mydatarundistancetwo = $run_row['distance_two'];
$mydatarundistancethree = $run_row['distance_three'];
$mydataruncity = $run_row['event_city'];
$mydatarunstate = $run_row['event_state'];
$mydatarunaddress = $run_row['event_address'];
$mydatarunzip = $run_row['event_zip'];
$mydatarunday = $run_row['day'];
$mydatarunhour = $run_row['start_hour'];
$mydatarunminute = $run_row['start_minute'];
$mydatarunzone = $run_row['start_zone'];
$mydatarunmonth = $run_row['month'];
$mydatarunyear = $run_row['year'];
$mydatarunphonea = $run_row['phone_a'];
$mydatarunphoneb = $run_row['phone_b'];
$mydatarunphonec = $run_row['phone_c'];
$mydatarunemail = $run_row['email'];
$mydataruncontactname = $run_row['contact_name'];
$mydatarun = $run_row[''];
$mydatarunwebsite = $run_row['website'];
$mydatarunwebsiteresults = $run_row['results_website'];

echo "<table><tr><td>

<b><font color=red size=+2>".$mydatarunmonth."/".$mydatarunday."/".$mydatarunyear."</font></b><br>

<b><font size=+1>".$mydatarunname. "</font>&nbsp;".$mydatarundescription. "&nbsp;</b>&nbsp<i>".$mydataruncategory. "&nbsp;".$mydataruncategoryother. "</i>&nbsp;&nbsp;<b><i>".$mydatarunhour. ":".$mydatarunminute. "&nbsp;".$mydatarunzone. "</b></i><br>

<b>Start Location:&nbsp;</b>".$mydatarunstart. ",&nbsp;".$mydatarunaddress. ",&nbsp;".$mydataruncity.",&nbsp;".$mydatarunstate."&nbsp;".$mydatarunzip."<br>

<b>Event(s):&nbsp;&nbsp;".$mydataruneventone. "&nbsp;<it>".$mydatarundistanceone. "</it></b>......".$mydataruneventtwo. "&nbsp;&nbsp;<it>".$mydatarundistancetwo. "</it>......".$mydataruneventthree. "&nbsp;<it>".$mydatarundistancethree. "</it>&nbsp;<br>

<b>Race Contact:&nbsp;</b>".$mydataruncontactname.",&nbsp;".$mydatarunemail.",&nbsp;(".$mydatarunphonea.")".$mydatarunphoneb."-".$mydatarunphonec."<br>

<a href=http://".$mydatarunwebsite." target=race>".$mydatarunname."</a>&nbsp;&nbsp;&nbsp;&nbsp

if(!empty($mydatarunwebsiteresults)){
<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>
};
else{&nbsp;
};

</td></tr></table><hr>";
}
?>

---

i can not get the if/else statment to work to show the websiteresults variable ONLY if it exists.

thanks
-michael

[mmilano]

<?
if($mydatarunwebsiteresults)
{
  echo "<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>";
};
?>

[mmilano]

p.s. don't forget to close the echo line above the if/else statement with ";