1 2 3 4 5 6 7 8 9 10 11 12 13
|
$retrieve_test_query = "SELECT u.quizz_id, u.nom_du_quizz, q.question_id, q.quizz_id, q.question, q.reponse, q.premier leurre, q.deuxieme leurre, q.troisieme leurre FROM `quizz` AS u JOIN `questions` AS q ON u.quizz_id = q.quizz_id AND u.quizz_id and questions.test_id = ".$post; // jai egalement essaye de mettre where a la place de and mais sans resultat.
$retrieve_test_result = $my_db_object->query($retrieve_test_query);
if ($retrieve_test_result === false){
die('Invalid query: ' . $my_db_object->error);
}
$retrieve_test_num_rows = $retrieve_test_result->num_rows;
if ($retrieve_test_num_rows > 0){
$test_data = $retrieve_test_result->fetch_assoc();
$retrieve_test_result->free();
print_r($test_data);// ne me renvoie qu'une des deux questions du quizz
//include "displaytest.php";
} |
Partager