Simple Random Question

[juanitobunito]

i created a database (Questionnaires)
i also create two tables (Questions and Answers)

i successfully display the questions randomly but my problem is i cannot connect the answers according to its primary ID

here is my code

mysql_select_db("questionaires", $con);
$result = mysql_query("Select * from Answers where AnswerID = {$row['QuestionID']} order by AnswerID asc");
while($row = mysql_fetch_array($result))
{
	echo $row['Answers'];
	echo "<br/>";
}

i dont know if the syntax is correct..

[vibhaJ]

Where is the select query for question table?
Post that query and also any error is you getting.

[pzuurveen]

why use 2 tabels?
isn't it easier to use only one?

> i dont know if the syntax is correct..

SO?
What do you want? SOmebody to check your code for you?

What's the problem? DO you get an error? More info.