Netcape Headaches printing problem

Anon

Netscape will not print html and data retrieved from mysql db (yes Netscape SUCKS) work fine with msie. below is my code:

A {
color:AA0000;
}

A:Hover {
color:FF0000;
}

</style>

    mysql_connect($host,$username,$password) 
            or die("Unable to connect to SQL server");
    @mysql_select_db($db) 
            or die("Unable to select database");

$getrows = mysql_query("SELECT merchant_id FROM merchant
                     WHERE merchant.category LIKE 'Bar%' OR merchant.category LIKE '%Restaurant%'");
$numrows=mysql_num_rows($getrows);

$result=mysql_query("SELECT merchant_id, name, address1, address2, url, number, package_id, happy_hour, attire, atmosphere FROM merchant
                     WHERE merchant.category LIKE 'Bar%' OR merchant.category LIKE '%Restaurant%' ORDER BY name LIMIT $offset,$limit") 
or die("Can't Perform Query");

$index++ ;
print ("<p>$results");

Leave the next 3 lines of code in. Need for debugging. robert 03/03/2001

#$row = mysql_fetch_array($result) ;
#print_r($row) ;
#exit ;

echo '<center>';
echo '<form><select name=Category>';

$aku = mysql_query("SELECT * FROM merchant_category");

echo "<option value=\"\">Area Of Austin\n";
echo "<option value=\"\">---------------------------\n";

while ($row = mysql_fetch_array($aku)) {
$cate=$row["area"];
echo "<option value=\"$cate\">$cate\n";
}

if ($cate=="") {
print ("$EMPTY_MSG");
}
echo "</select>\n";

echo '<form><select name=Category>';

$aku = mysql_query("SELECT * FROM merchant_category");

echo "<option value=\"\">Category\n";
echo "<option value=\"\">---------------------------\n";

while ($row = mysql_fetch_array($aku)) {
$cate=$row["category"];
echo "<option value=\"$cate\">$cate\n";
}

if ($cate=="") {
print ("$EMPTY_MSG");
}
echo "</select>\n";

echo '<form><select name=Genre>';

$aku = mysql_query("SELECT * FROM genre");

echo "<option value=\"\">Genre\n";
echo "<option value=\"\">---------------------------\n";

while ($row = mysql_fetch_array($aku)) {
$cate=$row["genre_type"];
echo "<option value=\"$cate\">$cate\n";
}

if ($cate=="") {
print ("$EMPTY_MSG");
}
echo "</select>\n";

echo '<form><select name=Age>';
echo "<option value=\"\">Age\n";
echo "<option value=\"\">----------\n";
echo "<option value=\"21+\">21+\n";
echo "<option value=\"18+\">18+\n";
echo "<option value=\"Any\">Any\n";
echo "</select>\n";

echo '</center>';

echo "<p>";

print ("<table border=0 align=center bgcolor=#000000 bordercolor=#000000 bordercolorlight=#CCCCCC bordercolordark=#333333 width=99%>") ;
printf ("<tr bgcolor=\"#FFFFFF\"> <font size=\"1\" color=\"FFFFFF\"><td bgcolor=000000></td><td><b><font color=\"#000000\" face=\"Times New Roman, Times, serif\">Bars/Restaurants</b></td><td color=000000><b><font color=\"#000000\" face=\"Times New Roman, Times, serif\">Features</b></td><td><b><font color=\"#000000\" face=\"Times New Roman, Times, serif\">Addresses</b></td><td><b><font color=\"#000000\" face=\"Times New Roman, Times, serif\">Phone</b></td></tr>");

if ($row = mysql_fetch_array($result)) {
do {
$MID=$row["merchant_id"];
$MerchantName=$row["name"] ;
$Address1=$row["address1"];
$Number=$row["number"] ;
$phone_number=$Number ;
$areac=substr("$phone_number", 0, 3) ;
$prefx=substr("$phone_number", 3, 3) ;
$phone=substr("$phone_number", 6, 4) ;
$formated_phone="(" . $areac . ") " . $prefx . "-" . $phone ;
$package_id=$row["package_id"];
$happy_hour=$row["happy_hour"];
$attire=$row["attire"];
$atmosphere=$row["atmosphere"];

$cal_result = mysql_query ("SELECT * FROM sched, schedule, artist
WHERE sched.merchant_id = '$MID'
AND sched.schedule_id = schedule.schedule_id
AND sched.artist_id = artist.artist_id
ORDER BY schedule.datetime
");
$CAL="";
if ($cal_row = mysql_fetch_array($cal_result)) {
do {
list ($date, $time) = split(' ', $cal_row["datetime"]);
list ($year, $month, $day) = split('-', $date);
$date=date("m-d", mktime(0,0,0,$month,$day,$year));
$time=substr($time, 0, 5);
$day=date("D", mktime(0,0,0,$month,$day,$year));
$ArtistName=substr($cal_row["name"], 0, 30) ;
#$Description=$cal_row["description"];
$SchedID=$cal_row["schedule_id"];
$CAL=$CAL . "$date $time $day, $ArtistName $Description<br>";
} while($cal_row = mysql_fetch_array($cal_result));
} else {$CAL="Sorry, no records were found!";}

$URL=$row["url"] ;

if ($package_id > 1) {
print "<tr bgcolor=\"#1D1D1D\"><td bgcolor=\"000000\"><img src=\"../forums/images/on.gif\">";

printf("<td><font size=2 face=\"Georgia, Times New Roman, Times, serif\" color=\"#FFFFFF\"><a href=\"http://%-s\"><font color=\"#FF0000\" face=\"Times New Roman, Times, serif\">%-s</a></font></td><td bgcolor=000000><A HREF=\"javascript:void(0);\" onMouseOver=\"overlib('$happy_hour' , CAPTION, 'Happy Hours')\" onMouseOut=\"nd()\">
<img border=0 src=\"../../img/martini.gif\"></a><A HREF=\"javascript:void(0);\" onMouseOver=\"overlib('$attire' , CAPTION, 'Required Attire')\" onMouseOut=\"nd()\"><img border=0 src=\"../../img/attire.gif\"></a>
<A HREF=\"javascript:void(0);\" onMouseOver=\"overlib('$atmosphere' , CAPTION, 'Atmosphere')\" onMouseOut=\"nd()\"><img border=0 src=\"../../img/partyball4.gif\"></a>
<A HREF=\"javascript:void(0);\" onMouseOver=\"overlib('$CAL' , CAPTION, 'Schedule')\" onMouseOut=\"nd()\"><img border=0 src=\"../../img/schedule.gif\"></a>
</td><td>
<font size=2 face=\"Georgia, Times New Roman, Times, serif\" color=FFFFFF>%-s</font></td><td><font size=2 face=\"Georgia, Times New Roman, Times, serif\" color=FFFFFF> %-s</td></font>", $URL, $MerchantName, $Address1, $formated_phone) ;

} else {
print "<tr bgcolor=\"#1D1D1D\"><td bgcolor=\"000000\"><img src=\"../forums/images/off.gif\">";

printf("<td><font size=2 face=\"Georgia, Times New Roman, Times, serif\" color=\"#FFFFFF\"><font color=\"#666666\" face=\"Times New Roman, Times, serif\">%-s</a></font></td><td bgcolor=000000><img src=\"../../img/lowpulse.gif\">
</td><td>
<font size=2 face=\"Georgia, Times New Roman, Times, serif\" color=666666>%-s</font></td><td><font size=2 face=\"Georgia, Times New
Roman, Times, serif\" color=666666> %-s</td></font>", $MerchantName, $Address1, $formated_phone) ;

}

} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}

print ("</font>") ;
printf ("<tr bgcolor=\"#FFFFFF\"> <font size=\"2\"><td bgcolor=000000></td><td></td><td></td><td><b>&nbsp</b></td><td><b>&nbsp
</b></td><table align=center><td>");

if ($numrows <= $limit) {
/ Added this statement so if the result shows less that or the
equal ammount of the limit to show nothing at all , to kill
the "2" that was just generated /
}
else {

    // Don't display PREV link if on first page 
    if ($offset!=0) {   
        $prevoffset=$offset-$limit; 
        echo   "<a onMouseOver=\"window.status='Previous $limit Results'; return true\"; href=\"$PHP_SELF?offset=$prevoffset&index=$prevoffset\"><B>[Previous]</B></a>&nbsp &nbsp"; 
    } /* I particularly like having the [Previous] on the first page
	      if it has enough results to display at all with my mod , just helps
		  set the over all structure of the navigation system its self
		  so ill just add this to the above if statement */
		  else echo "<b><font color=666666>[Previous]</font></b>&nbsp &nbsp";
		  /* If its not to your likeing simply comment it out ;) */


    // Calculate total number of pages in result 
    $pages = intval($numrows/$limit); 

    // $pages now contains total number of pages needed unless there is a remainder from division  
    if ($numrows%$limit) { 
        // has remainder so add one page  
        $pages++; 
    } 

    // Now loop through the pages to create numbered links 
    // ex. 1 2 3 4 5 NEXT 
    for ($i=1;$i<=$pages;$i++) { 


        // Check if on current page 
        if (($offset/$limit) == ($i-1)) { 
            // $i is equal to current page, so don't display a link 
            echo " <b><font color=666666>$i</font></b>  "; 
        } else { 
            // $i is NOT the current page, so display a link to page $i 
            $newoffset=$limit*($i-1); 
            echo  "&nbsp;<a onMouseOver=\"window.status='Page $i Results'; return true\"; href=\"$PHP_SELF?offset=$newoffset&index=$newoffset\"><B>$i</B></a>&nbsp;\n"; 
        } 

    } 

// Check to see if current page is last page 
    if (!((($offset/$limit)+1)==$pages) && $pages!=1) { 
        // Not on the last page yet, so display a NEXT Link 
        $newoffset=$offset+$limit; 
        echo   "&nbsp &nbsp <a onMouseOver=\"window.status='Next $limit Results'; return true\"; href=\"$PHP_SELF?offset=$newoffset&index=$newoffset\"><B>[Next]</B></a><p>\n"; 
    } /* Im doing the same thing here as i did in the [Previous] above */
	else echo "&nbsp &nbsp<b><font color=666666>[Next]</font></b>";

}

printf ("</td></table><center><img src=\"../../img/martini.gif\"><font color=#FFFFFF>Happy Hour</font><img src=\"../../img/attire.gif\">
<font color=#FFFFFF>Attire</font><img src=\"../../img/partyball4.gif\"><font color=#FFFFFF>Atmosphere</font><img src=\"../../img/schedule.gif\"><font color=#FFFFFF>Schedule</font><img src=\"../../img/lowpulsel.gif\"><font color=#FFFFFF>Low Pulse</font></center><p><p><table align=center><td align=center><i><font face=\"Georgia, Times New Roman, Times, serif\" size=\"1\" color=\"#FFFFFF\">Hosted
& Produced By:<a href=\"http://www.sniperproductions.com\"> Sniper Productions</a>
2001 © Copyright <a href=\"redirect.html\">AustinNights Network</a> LLC</font></i></td></tr></table><p><p>");
?>
</div>
</td>
</tr>
<tr>
<td width="159" height="1" valign="top"></td>
<td width="8" height="1" valign="top"></td>
</tr>
<tr>
<td width="159" height="1" valign="top"><img width="159" height="1" src="transparent.gif"></td>
<td width="8" height="1" valign="top"><img width="8" height="1" src="transparent.gif"></td>
<td width="591" height="1" valign="top"><img width="591" height="1" src="transparent.gif"></td>
</tr>
</table>
</body>

mikej

If you do not close all tables Netscape will not print the page, all you will see is a blank document.
Make sure you close all tables </table> for every <table> that you open.

Hope this helps,

Mike J