FAQ page w. 1 query.

Admin · 08-20-2002, 08:21 AM

here is what i need to print out:

Quote:

1. Question #1
2. Question #2
3. Question #3

1. Answer #1

2. Answer #2

3. Answer #3

i am doing something like:: select id, question, answer from faq

then i need to run a loop on the questions and then a seperate loop on the answers.

i could do this in 1.72 seconds using 2 queries, but it would be better if i just used 1...

blegh.

redhead · 08-20-2002, 08:34 AM

PHP Code:


			
$questions="";

$answers="";

$i=1

$res=mysql_query("Select * from database");

while($row=mysql_fetch_array($res))

{

  $questions .="$i: $row[question] <br>";

  $answers .= "$i: $row[answers] <p>";

  $i++;

}

 echo "Your faq is:<br>

            $questions

             <hr>

            And the answers are:<br>

            $answers

         ";

Admin · 08-20-2002, 09:14 AM

thank you very much, worked perfect