okay, so i have a db that i query using php. in the db, i have a table of links. the table links has a field called "active". in the php query that gets the links, if the link is labled inactive, it should not be pulled. however, SOMETHIGN is pulled because there's a space in the output where a link should be.
//site id is established earlier in the php script.
$site_details = "SELECT * FROM links WHERE site_id ='$site_id' AND active='active'";
$site_details_query = mysql_query ($site_details);
while ($site_results = mysql_fetch_array ($site_details_query, MYSQL_ASSOC))
{
$show_name = $site_results["show_name"];
$link= $site_results["link"];
echo "<dd><a target= \"_blank\" href=\"$link\">$show_name</a></dd>";
}
it's easy see the gap in action at:
http://www.links2.tv/
right there in ABC (first one on the list) you'll see a gap between 'duel' and 'pushing daisies'.
:queasy: wtf??
