[MYSQL/PHP]How to display a query dynamicly
Hello,
I have two lines of results for a mysql query :
line 1 : 1 // 5 // Conception et mise en oeuvre d'une politique de communication // 2013-06-11 // 2013-06-13 // 15
line 2 : 5 // 3 // Evaluer une association : transparence et efficacité // 2013-06-10 // 2013-06-15 // 15
I want this "design" in a div :
Name : Places :
Date ; Book it !
All lines will appear one by one, every 30s
My PHP code :
<div class="reserver">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>
<script type="text/javascript" src="jquery_page.js"></script>
<?php
// on crée la requête SQL
$sql = 'Select
appli_formation.session.id_session,
appli_formation.formation.id_formation,
appli_formation.formation.formation_libelle,
appli_formation.session.session_date_debut,
appli_formation.session.session_date_fin,
appli_formation.session.session_nb_places
From
appli_formation.formation Inner Join
appli_formation.session On appli_formation.session.id_formation_formation =
appli_formation.formation.id_formation
Order By
appli_formation.session.session_date_fin;';
//on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
echo "<div id='loading'></div>";
echo "<div id='content'>";
echo "<table width='800px'>";
echo "<tr>";
echo"<td>";
echo $row['id'];
echo"</td>";
echo"<td>";
echo $data['id_session'];
echo"</td>";
echo"<td>";
echo $data['id_formation'];
echo"</td>";
echo"<td>";
echo $data['formation_name'];
echo"</td>";
echo"<td>";
echo $data['session_date_begin'];
echo"</td>";
echo"<td>";
echo $data['session_date_end];
echo"</td>";
echo"<td>";
echo $data['session_nb_places'];
echo"</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
}
?>
</div>
Thanks you for your help