Posted by Jim Michaels on 02/23/06 12:06

"Beshoo" <basheermoro@gmail.com> wrote in message
news:1139698882.214335.219900@g43g2000cwa.googlegroups.com...
> 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>";

I hear one area you are going to run into trouble is your dotted column
names. you will need to use AS to rename the columns before you can use
them like $row['answer'] and such. here's why:
C:\Documents and Settings\Jim>php test1.php
Array
(
[0] => 1
[cat_id] => 1
[1] => a
[category] => a
[2] => 1
)

C:\Documents and Settings\Jim>type test1.php
<?php
mysql_connect("localhost","username","password");
mysql_select_db("database");
$q=mysql_query("SELECT * FROM categories,categoryroots WHERE
categories.cat_id=categoryroots.cat_id") or die("oops1.");
$row=mysql_fetch_array($q);
print_r($row);
mysql_free_result($q);
?>

C:\Documents and Settings\Jim>

well, I got everything from the categories table (trhe first table mentioned
in the SELECT). Because I didn't specify the columns I wanted from both
tables.





>
> }
> }
> 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 !!!
>

[Back to original message]