A Simple Question

Anon

Hi,

I'm trying to modify the faq from php-nuke so it will work without php-nuke and there's this one piece of code that's missing and I was wondering if anyone could fill in the gap or give me an idea of what needs to be used.
The problem is that when I click on a category I get a 404. All of the functions are there, but I need to know how to get the questions to show up. Here's the source followed by the db dump (if anyone needs it).

<?
$dbhost = "localhost";
$dbuname = "root";
$dbpass = "";
$dbname = "Faq";

Mysql_connect($dbhost, $dbuname, $dbpass);
Mysql_select_db($dbname);

$bgcolor1 = "#cccccc";
$bgcolor2 = "#999999";

function OpenTable() {
global $bgcolor1, $bgcolor2;
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" bgcolor=\"$bgcolor2\"><tr><td>\n";
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"8\" bgcolor=\"$bgcolor1\"><tr><td>\n";
}

function CloseTable() {
echo "</td></tr></table></td></tr></table>\n";
}

function ShowFaq($id_cat, $categories) {
OpenTable();
echo"<center><font class=\"content\"><b>FAQ (Frequently Asked Questions)</b></font></center><br><br>"
."<a name=\"top\"></a><br>" / Bug fix : added missing closing hyperlink tag messes up display /
."Category: <a href=\"faq.php\">Main</a> -> $categories"
."<br><br>"
."<table width=\"100%\" cellpadding=\"4\" cellspacing=\"0\" border=\"0\">"
."<tr bgcolor=\"$bgcolor2\"><td colspan=\"2\"><font class=\"option\"><b>Question</b></font></td></tr><tr><td colspan=\"2\">";
$result = Mysql_query("select id, id_cat, question, answer from faqAnswer where id_cat='$id_cat'");
while(list($id, $id_cat, $question, $answer) = Mysql_fetch_row($result)) {
echo"<strong><big>·</big></strong>  <a href=\"#$id\">$question</a><br>";
}
echo "</td></tr></table>
<br>";
}

Table structure for table `faqanswer`

CREATE TABLE faqanswer (
id tinyint(4) NOT NULL auto_increment,
id_cat tinyint(4) default NULL,
question varchar(255) default NULL,
answer text,
PRIMARY KEY (id)
) TYPE=MyISAM;

--------------------------------------------------------

Table structure for table `faqcategories`

CREATE TABLE faqcategories (
id_cat tinyint(3) NOT NULL auto_increment,
categories varchar(255) default NULL,
PRIMARY KEY (id_cat)
) TYPE=MyISAM;

theslinky

You say it gives you a 404 file not found?

Can you print out the HTML output of the part where this link is (that you click on to get the 404) and the URL of the 404 (meaning what didn't load)?

You probably made a simple mistake in the URL inside the href. Perhaps a leading / where it doesn't belong?

-sridhar

Anon

no, I know why there is a 404, but i need the code so it will show up with the variables in the href. All of the functions are there.

theslinky

Why do you say "you need the code so it will show up w/ the vars" if you say "all the functions are there"?

What exactly is it that doesn't show up? Are the categories being listed? When you click on a category, does it show the questions?

In your initial post, you say the "problem is that when I click on a category I get a 404".

Anyway, I think the problem is in this line:

if (!$myfaq) {

I've never use phpnuke (nor do i intend to), but from what I gather, that if/else statements wants to either print the categories, or show the questions.

$myfaq is not declared anywhere else in the script.

Change this to if(!$id_cat), because if $id_cat is specified, then you know that the user wants to load the questions for the category which has the id $id_cat.

maybe i'm totally lost! please do explain in more detail or give me the URL of where your script it currently so I can also see what the problem is.

thanks,
-sridhar

Anon

ok, php-nuke features an faq. I wanted to take the faq out so it would work without php-nuke. I got everything to work except for faq.php?id_cat=$id_cat&categories=$catname when they click on the category. What code would I use so it would display the questions for that category.

theslinky

Did you try the thing I said? Change the if(!$myfaq) to if(!$id_cat) because I think that if/else clause is deciding whether to print categories or print the questions for a specific category.

I'll download and look at the phpnuke code and compare it with your standalone if needed to find out what your standalone lacks.

-sridhar

Anon

Oh i didn't notice you said that, I changed it and now it works. Thanks a ton.