You must select a category from the list, when browsing by category

"); $mode="newsearch"; } if($mode=="newsearch"){ $sql="select c.title, c.cat_id, count(*) as total from categories c, faq f where c.cat_id=f.catid group by c.title, c.cat_id order by c.title"; include($path_to_mysql); $numrows=sizeof($cat_id); $j=0; while($j<$numrows){ $catselect.="\n"; $j++; } print("

Search WISPFAQ Database

Browse by category

Search for Word or Phrase
Select Category:
Search for:

Search Tips:
You may browse a category or search for a specific keyword.

When browsing categories, the number of FAQ's is listed to the right of the category name in parenthesis.

When searching specific keywords or phrases, do not use any quotations. Just type out exactly what word or phrase you wish to search for.
"); } if($mode=="bcategory"){ $sql="select title from categories where cat_id=$scategory"; include($path_to_mysql); $sql="select * from faq where catid=$scategory and active='y'"; include($path_to_mysql); $numrows=sizeof($faq_id); $j=0; print(" "); if($numrows==0){ print(" "); } while($j<$numrows){ print(" "); $j++; } print("
Listing FAQs in \"$title[0]\"

Sorry, currently no FAQs listed in that category
Go back and try again.
Q. $question[$j]
A. $answer[$j]
  Posted by: $postedby[$j]$faq_id[$j]
"); if($email[$j]==$myemail[0]){ print(""); } print("

"); } if($mode=="search"){ if($scategory=="all"){ $sql="select * from faq where active='y' and ( question like '%$stext%' OR answer like '%$stext%')"; }else{ $sql="select * from faq where catid=$scategory and active='y' and (question like '%$stext%' OR answer like '%$stext%')"; } include($path_to_mysql); $numrows=sizeof($faq_id); $j=0; print(" "); if($numrows==0){ print(""); } while($j<$numrows){ print(" "); $j++; } print("
Search for \"$stext\"

No Results Found. Please try another Search
Q. $question[$j]
A. $answer[$j]
  Posted by: $postedby[$j]$faq_id[$j]
"); if($email[$j]==$myemail[0]){ print(""); } print("

"); } if($mode=="detail"){ $sql="select * from faq where active='y' and faq_id=$id"; include($path_to_mysql); $numrows=sizeof($faq_id); print(" "); if($numrows==0){ print(""); }else{ print(" "); } print("
Displaying FAQ id $id

No FAQ was found with that ID
Q. $question[0]
A. $answer[0]
  Posted by: $postedby[0]$id
"); if($email[0]==$myemail[0]){ print(""); } print("

"); } include("footer.html"); ?>