pleeez !! so easy but???!

hi
I have this function to print each question and it`s answar
/ actually
from 2 tables answers and questions /

I am taking the "question id"   to be the
"answer parent_id",so that I
can know each question and its answers..... ok!!

the quey like this:

function display (){
$sql="SELECT * from answers,questions WHERE
answers.parent_id=questions.question_id";
$exe=mysql_query($sql);
while ($row=mysql_fetch_assoc($exe))
{
				echo $row['answer']."<br>";
				echo $row['quest']."<br>";

}
}
display();

the problem is.. in this way the question will be printed
more than one
time , in another word the questios will be printed each
time its
answer printed !!!

SO how I can print the question just one time???!!!
pleeeez !!!
thank you very much my frnds !!!

hi,

Question is why are there two tables? is it possible to have
 more than
one answer for a question? If not, then one table with a
Question_ID,Question,Answer would probably help.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Professional PHP Developers"
group.
To post to this group, send email to Professional-PHPgooglegroups.com
To unsubscribe from this group, send email to
Professional-PHP-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/Professional-PHP
-~----------~----~----~----~------~----~------~--~---