If statement in query display HELP

[michaelowen]

hello everybody,

here is my problem: i wrote this script format results from my database, however i do not want to display a blank area on the table if the field is empy in the database.

I guess this would be an optional if statement saying something like "if field is populated display....if not then do not display".

How would i code that?

---

<?php

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

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

echo "<table width=100% border=0>";
//while($user_row = mysql_fetch_array($user_result)){
$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>.......Calendar: </font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
// echo "<tr><td><b>Race Name </b> </td><td><b>State</b></td><td><b>City</b></td><td><b>Date</b></td><td><b>Website</b></td></tr></table>";
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>

<a href=http://".$mydatarunwebsite." target=race>".$mydatarunname."</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>

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

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

---

thanks,
-michael