How would I prevent this from echoing a field if the field is empty in the data base
And if it doesn’t echo have the gap where the data would be collapse down to the field with data.
$query = 'DELETE FROM Venues WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date1`';
mysql_query($query);
$query= 'SELECT venues_field_1, venues_field_2, venues_field_3, venues_field_4, venues_field_5, venues_field_6, venues_field_7, venues_field_8, venues_field_9, venues_field_10, venues_field_11, venues_field_12, venues_field_13, venues_field_14, venues_field_15 FROM Venues ORDER BY venues_field_1 DESC LIMIT 0, 100';
$result = mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
if ($num==0) {
echo "<b>NO Vemues Schedule</b><br>";
}else{
echo "<b><i>Where We Are</b></i><br><br>";
}
mysql_close();
$i=0;
while ($i < $num) {
$venues_field_1=mysql_result($result,$i,"venues_field_1");
$venues_field_2=mysql_result($result,$i,"venues_field_2");
$venues_field_3=mysql_result($result,$i,"venues_field_3");
$venues_field_4=mysql_result($result,$i,"venues_field_4");
$venues_field_5=mysql_result($result,$i,"venues_field_5");
$venues_field_6=mysql_result($result,$i,"venues_field_6");
$venues_field_7=mysql_result($result,$i,"venues_field_7");
$venues_field_8=mysql_result($result,$i,"venues_field_8");
$venues_field_9=mysql_result($result,$i,"venues_field_9");
$venues_field_10=mysql_result($result,$i,"venues_field_10");
$venues_field_11=mysql_result($result,$i,"venues_field_11");
$venues_field_12=mysql_result($result,$i,"venues_field_12");
$venues_field_13=mysql_result($result,$i,"venues_field_13");
$venues_field_14=mysql_result($result,$i,"venues_field_14");
$venues_field_15=mysql_result($result,$i,"venues_field_15");
echo "<b>$venues_field_1<br>$venues_field_2</b><br>$venues_field_3 $venues_field_4<br>$venues_field_5<br>$venues_field_6<br>$venues_field_7<br>$venues_field_8<br>$venues_field_9<br>$venues_field_10<br><b>Host</b> $venues_field_11<br><b>Hosts Email</b><br>$venues_field_12<br><b>$venues_field_1 WebSite</b><br>$venues_field_13<br><b>$venues_field_1 Phone No.</b><br>$venues_field_14<br>$venues_field_15<br>";
$i++;
}
Looks like this now
Where We Are
My Place
Some Street Close By
05/23/2009 1pm
these are enply fields
--
--
Host Kelly
Hosts Email
myemail@dox.net
My Place WebSite
something.com
My Place Phone No.
xxx-xxx-xxxx
with same echo look like this
Where We Are
My Place
Some Street Close By
05/23/2009 1pm
Host Kelly
Hosts Email
myemail@dox.net
My Place WebSite
something.com
My Place Phone No.
xxx-xxx-xxxx
