"Fossies" - the Fresh Open Source Software Archive

Member "faqadmin/faq/index.php" (26 Feb 2003, 2290 Bytes) of package /linux/www/old/faqadmin-current.tgz:

The requested HTML page contains a <FORM> tag that is unusable on "Fossies" in "automatic" (rendered) mode so that page is shown as HTML source code syntax highlighting (style: standard) with prefixed line numbers and code folding option. Alternatively you can here view or download the uninterpreted source code file. For more information about "index.php" see the Fossies "Dox" file reference documentation. 
    1 <HTML>
    2 <HEAD>
    3 </HEAD>
    4 <BODY background="" bgColor=white link=blue text=black vLink=purple>
    5 <table align=center border="0" width="765">
    6 <TR><TD>
    7 <?php
    8 include ("connect.php");
    9 include ("links.php");
   10 ?>
   11 <BR><BR><BR><P>
   12 <table align=left border="0" cellpadding=0 cellspacing=4 width="270">
   13 <tr><td>
   14 Search Posts
   15 </td></tr>
   16 <TR><TD>
   17 <form action=search.php method=get>
   18 <input type=text name=keywd> <input type=submit value=submit>
   19 </form>
   20 </td></tr>
   21 <tr><td></td></tr>
   22 <tr><td></td></tr>
   23 <tr><td bgcolor="#c3c3c3"><font color="#000000" face="arial" size="3"><b>Forums</b>&nbsp;</font></td></tr>
   24 <tr><td></td></tr>
   25 <tr><td></td></tr>
   26 <tr><td></td></tr>
   27 <?
   28 
   29 $result = mysql_query ("SELECT *
   30                FROM faq_forum
   31             ");
   32 
   33 if ($myrow = mysql_fetch_array($result)) {
   34 
   35 do {
   36 
   37  $fid = $myrow["fid"];
   38  $desc = $myrow["description"];
   39  $forum = $myrow["forum_name"];
   40  print "<TR><TD><a href=faq.php?fid=$fid><B>$forum</B></a><BR>$desc</TD></TR>";
   41 $quest = mysql_query ("SELECT COUNT(*) as questions
   42             from faq_dat
   43             where faq_fid = '$fid'
   44                ");
   45 
   46 if ($myrow = mysql_fetch_array($quest)) {
   47 print "<TR><TD><TT>Questions&nbsp;";
   48 print $myrow["questions"];
   49 
   50 }
   51 
   52 $reply = mysql_query ("SELECT count(*) as replies
   53             from faq_dat, faq_re_dat
   54              WHERE faq_re_dat.fodr = faq_dat.fodr
   55             and faq_re_dat.faq_re_fid = '$fid'
   56                ");
   57 
   58 if ($myrow = mysql_fetch_array($reply)) {
   59 
   60 print "&nbsp;&nbsp;Replies&nbsp;";
   61 print $myrow["replies"];
   62 print "</TT></TD></TR>";
   63 }
   64 
   65 } while ($myrow = mysql_fetch_array($result));
   66 
   67 } else {
   68     echo "<b>Error!!</b>";
   69 }
   70 
   71 ?>
   72 
   73 <tr><td></td></tr>
   74 <tr><td></td></tr>
   75 <tr><td></td></tr>
   76 <tr><td bgcolor="#c3c3c3"><font color=c3c3c3 face="arial" size="3"><b>&nbsp;</b>&nbsp;</font></td></tr>
   77 </TABLE>
   78 <!--<BR><BR><P>-->
   79 <table align=right border="0" cellpadding=0 cellspacing=0 width="450">
   80 <tr>
   81 <td align=left>
   82 This page is gearing up for another update.. Please be patient.<P>
   83 When finished, this new  version will support the creation, deletion,<BR>
   84 and management of multiple forums.
   85 <P>If you have any suggestions feel free to let us know.<BR>
   86  We always welcome "useful" suggestions.
   87 </td>
   88 </tr>
   89 </table>
   90 </TD></TR>
   91 <TR><TD>
   92 <table align=left border="0" cellpadding=0 cellspacing=0 width="450">
   93 <tr>
   94 <td align=left>
   95 
   96 </td></tr>
   97 </table>
   98 </TD></TR>
   99 </TABLE>
  100 </body>
  101 </html>