Posted by Mikey P on 09/27/38 11:36

Hi there, i'm still very new at this so please any patience would be
appreciated.

I've tried a couple of variations of coding this but i still haven't
gotten it down.

basically my query pulls all the tables within a certian search
criteria. When it shows the listings it shows a space like:

Name
Address
city, state zip
phone:
<blank space>
url

right now this is the code i have:

<?php echo('<b>' . $row['company'] . '</b>' . '<br>' . $row['address']
.. '<br>' .$row['city'] . ' ' . $row['state'] . ', ' . $row['zip'] .
'<br>' . '<a href="http://' . $row['website'] . '">' .
$row['website'] . '</a>' . '<br>' . $row['phone'] . '<br>' .
$row['description'] . '</font></li></p><p> <a
href="http://www.mapquest.com/maps/map.adp?searchtype=address&country=US&addtohistory=&searchtab=home&address='.
$row['address'] . '&city=' . $row['city'] . '&state=' . $row['state']
..'&zipcode=' . $row['zip'] .'" target="_blank"><img
src="assets/images/itl/map.gif" width="135" height="25" ></a>');
?>

How do i get it to disregard the tables with no information in them?

Also, these listings have a created date on them. how can i query only
listings that range from todays date back to 2 years. And everything 2
years old or older will be disregarded?

Any help would be greatly appreciated.

[Back to original message]