\n"; print " \n"; if( $chedit ) { $url = "javascript:openWindow('/edit.php?&cmd=add&gdb=kcchrist_kcchrist&table=schools','editwin','','600','640')"; print " "; } print "
\n"; if( $mode=="n" ) { print <<
$cline[name]
\n"; if( $cline[m_address] != "" ) { print "";
print "Meeting at:
\n";
if( $cline[m_name] != "" ) { print "$cline[m_name]
\n"; }
if( $cline[m_address] != "" ) { print "$cline[m_address]
\n"; } else { print "<address unknown>
\n"; }
if( $cline[m_city] != "" ) { print "$cline[m_city]"; }
if( $cline[m_state] != "" ) { print ", $cline[m_state]"; }
if( $cline[m_zip] != "" ) { print " $cline[m_zip]"; }
print "
";
print "Mailing address:
\n";
}
else
{
print "
";
}
if( $cline[address] != "" ) { print "$cline[address]
\n"; } else { print "<address unknown>
\n"; }
if( $cline[city] != "" ) { print "$cline[city]"; }
if( $cline[state] != "" ) { print ", $cline[state]"; }
if( $cline[zip] != "" ) { print " $cline[zip]"; }
print "
$cline[phone]
"; } if( $cline[fax] != "" ) { print "FAX: $cline[fax]
"; } $mqurl = "http://www.mapquest.com/maps/map.adp?address="; if( $cline[mapquest] != "" ) { $mqurl .= "$cline[mapquest]"; } else { if( $cline[m_address] != "" ) { $mqurl .= ereg_replace(" ","+",$cline[m_address]); $mqurl .= "&city="; $mqurl .= ereg_replace(" ","+",$cline[m_city]); $mqurl .= "&state=$cline[m_state]"; $mqurl .= "&zipcode=$cline[m_zip]"; } else { $mqurl .= ereg_replace(" ","+",$cline[address]); $mqurl .= "&city="; $mqurl .= ereg_replace(" ","+",$cline[city]); $mqurl .= "&state=$cline[state]"; $mqurl .= "&zipcode=$cline[zip]"; } } print "\n"; if( $cline[url] != "" ) { print "\n"; } if( $chedit ) { $url = "javascript:openWindow('/edit.php?&cmd=edit&gdbid=$id&gdb=kcchrist_kcchrist&table=schools','editwin','','600','640')"; print ""; } } else { # Print list of schools $result = mysql_query($query); $num_rows = mysql_num_rows($result); # Divide the list into two columns if( $first > $num_rows ) { $first = 1; $page = 1; } $last = ($first + $limit) - 1; if( $last > $num_rows ) { $last = $num_rows; } $half = ($last-$first+1)/2; if( $num_rows > $limit ) { if( $first > 1 ) { $ppage = $page-1; $prev = "Previous"; } else { $prev = "Previous"; } if( $last < $num_rows ) { $npage = $page+1; $next = "Next"; } else { $next = "Next"; } print "$prev $next Found $num_rows, showing $first-$last
\n"; } print "| \n";
$count = 1;
$colcount = 0;
$col = 0;
# Print all the records found
while( ($line = mysql_fetch_array($result,MYSQL_ASSOC)) && ($count<=$last) )
{
if( $count >= $first )
{
print " \n";
print " "; if( $line[m_city] != "" ) { print "$line[m_city]"; if( $line[m_state] != "" ) { print ", $line[m_state]"; } } else { if( $line[city] != "" ) { print "$line[city]"; if( $line[state] != "" ) { print ", $line[state]"; } } else { print " "; } } print " \n"; ++$colcount; # See if time to divide into columns if( $colcount >= $half ) { print " | \n";
print " \n"; $colcount = 0; } } ++$count; } print " | \n"; print "