1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| <?php
($sql = "SELECT id AS ID, membres_id AS membreID ,login AS Login, ville AS Ville, pays AS Pays, photo AS Photo,
date_naissance AS Date_Naissance, message AS Message, date_inscription AS Date_Inscription
FROM plateforme
UNION
SELECT id AS ID, membres_id AS membreID, login AS Login, ville AS Ville, pays AS Pays, photo AS Photo ,
date_naissance AS Date_Naissance, message AS Message , date_inscription AS Date_Inscription
FROM plateau");
//ORDER BY date_inscription ASC";
$data = mysql_query($sql) or die('Erreur - tables jointures: ' . mysql_error());
$totalRows_data = mysql_num_rows($data);
$nb_lignes = 10;
$nb_pages = ceil($totalRows_data/$nb_lignes);
while($info = mysql_fetch_array($data, MYSQL_BOTH )) {
$tableau_res = array();
$tableau_res[$info['ID']] = ($info);
//$tableau_res = $info;
}
echo $totalRows_data;
?> |
Partager