(beginner) User, Vraag en Antwoord uit MYSQL
Bedankt!
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
// Selecteer vraag en antwoord
$select=mysql_query("SELECT * FROM questions INNER JOIN answers ON (questions.question_id=answers.question_id) INNER JOIN customers ON (customers.customer_id = answers.customer_id)");
while($result=mysql_fetch_assoc($select)){
echo "Naam: ".$result['customer_name']."<br />";
echo "Vraag: ".$result['question_name']."<br />";
echo "Antwoord: ".$result['answers_name']."<br />";
}
$select=mysql_query("SELECT * FROM questions INNER JOIN answers ON (questions.question_id=answers.question_id) INNER JOIN customers ON (customers.customer_id = answers.customer_id)");
while($result=mysql_fetch_assoc($select)){
echo "Naam: ".$result['customer_name']."<br />";
echo "Vraag: ".$result['question_name']."<br />";
echo "Antwoord: ".$result['answers_name']."<br />";
}
Gewijzigd op 05/09/2012 16:34:46 door Erwin Augustijn
Code (php)
1
2
3
4
2
3
4
SELECT questions.question_name AS question_name, customers.customer_name AS customer_name
FROM answers
INNER JOIN questions ON questions.question_id = answers.question_id
INNER JOIN customers ON customers.customer_id = answers.customer_id
FROM answers
INNER JOIN questions ON questions.question_id = answers.question_id
INNER JOIN customers ON customers.customer_id = answers.customer_id
Toevoeging op 05/09/2012 17:48:18:
Is er dan alsnog een mogelijkheid om met GROUP_CONCAT de naam maar 1 keer te tonen en eronder de vragen en antwoorden?
Dankje!