$ptitle\n"; print "

 \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 << Maranatha Academy
"Provide a Christ-centered education
by integrating biblical principles
and truth into all subjects."
Trinity Campus
Phone: 913-631-0637
15000 West 63rd
Shawnee, KS 66216 West Campus
Phone: 913-631-0637
6826 Lackman Road
Shawnee, KS 66217
EOF; } if( isset($id) ) { # Print individual school record $cline = mysql_fetch_array(mysql_query("SELECT * FROM schools WHERE id = $id"),MYSQL_BOTH); 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 "

\n"; 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 "

\n"; if( $cline[phone] != "" ) { 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 "

Mapquest Map

\n"; if( $cline[url] != "" ) { print "

School Website

\n"; } if( $chedit ) { $url = "javascript:openWindow('/edit.php?&cmd=edit&gdbid=$id&gdb=kcchrist_kcchrist&table=schools','editwin','','600','640')"; print "

Edit

"; } } 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"; print " \n \n"; print " \n"; print " \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 "

" . $line['name'] . "

\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"; $colcount = 0; } } ++$count; } print "
\n"; } include 'page_close.php'; ?>