salut
cette page perment d'afficher le nombred'enregistrement d'une table,
donc j'ai fait:
$res = mysql_query("SELECT * FROM reference",$con);
$nb_enreg = mysql_num_rows($res);
mais sans résultat
-----------------------------------
<?
require("connexion.php");
$table="reference";
//_____________________________________________________________________________________
//_____________________________________________________________________________________
$rs=mysql_query("select * from reference",$log);
[mailto:$txt1=@mysql_result($rs,0,"txt1 $txt1=@mysql_result($rs,0,"txt1]");
[mailto:$img1=@mysql_result($rs,0,"img1 $img1=@mysql_result($rs,0,"img1]");
$rs2=mysql_query("select * from reference order by id desc limit 2",$log);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns="
http://www.w3.org/1999/xhtml ">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
<SCRIPT TYPE="text/javascript">
<!--
function newImage(arg) {
if (document.images) {
rslt = new Image();
rslt.src = arg;
return rslt;
}
}
function changeImages() {
if (document.images && (preloadFlag == true)) {
for (var i=0; i<changeImages.arguments.length; i+=2) {
document[changeImages.arguments[i]].src = changeImages.arguments[i+1];
}
}
}
var preloadFlag = false;
function preloadImages() {
if (document.images) {
home_over = newImage("images/home-over.gif");
qui_over = newImage("images/qui-over.gif");
form_over = newImage("images/form-over.gif");
contact_over = newImage("images/contact-over.gif");
sub2_body_mind_spirit_over = newImage("images/sub2-body-mind-spirit_over.gif");
sub2_business___economics_over = newImage("images/sub2-business-%26-economics_o.gif");
sub2_computers_over = newImage("images/sub2-computers_over.gif");
sub2_family___relationships_over = newImage("images/sub2-family-%26-relationships.gif");
sub2_health___fitness_over = newImage("images/sub2-health-%26-fitness_over.gif");
sub2_history_over = newImage("images/sub2-history_over.gif");
sub2_reference_over = newImage("images/sub2-reference_over.gif");
sub2_religion_over = newImage("images/sub2-religion_over.gif");
sub2_self_form_over = newImage("images/sub2-self-form_over.gif");
sub2_sex_over = newImage("images/sub2-sex_over.gif");
sub2_fiction_over = newImage("images/sub2-fiction_over.gif");
sub2_adventure_over = newImage("images/sub2-adventure_over.gif");
sub2_crime_over = newImage("images/sub2-crime_over.gif");
sub2_erotica_over = newImage("images/sub2-erotica_over.gif");
sub2_fantasy_over = newImage("images/sub2-fantasy_over.gif");
sub2_historical_over = newImage("images/sub2-historical_over.gif");
sub2_romance_over = newImage("images/sub2-romance_over.gif");
sub2_science_fiction_over = newImage("images/sub2-science-fiction_over.gif");
sub2_thrillers_over = newImage("images/sub2-thrillers_over.gif");
sub2_non_fiction_over = newImage("images/sub2-non-fiction_over.gif");
preloadFlag = true;
}
}
// -->
</SCRIPT>
<style type="text/css">
<!--
.Style4 {
font-size: 12px;
font-weight: bold;
color: #0142CF;
}
.Style8 {color: #0066FF}
.Style11 {color: #999999}
-->
</style>
</head>
<link href="css/styles.css" rel="stylesheet" type="text/css">
----
,
,
,
,
----
,
,
,
,
,
,
,
,
----
,
,
,
,
,
,
<marquee direction="left" scrollamount="6">
Investir en immobilier vaut mieux qu’une perle dans un collier (Proverbe Marocain)
</marquee>
,
,
----
,
,
,
,
,
,
,
,
----
,
----
<table width="213" border="0" cellspacing="0">
----
, </td>
,
----
,
,
----
,
APPARTEMENTS,
----
,
,
----
,
VILLAS,
----
,
,
----
,
TERRAINS,
----
,
,
----
,
FERMES,
----
,
,
----
,
MAISONS,
----
,
,
----
,
RIADS,
----
,
,
----
,
,
----
,
,
----
,
VILLAS,
----
,
,
----
,
APPARTEMENTS,
----
,
,
----
,
,
</td>
<td width="666" valign="top"> ----
<? $con=mysql_connect("localhost","root","");
$base=mysql_select_db("mabase");
//-------------------------------------------------------------------------
if(!isset($_GET['pg']))
{
$pg = 1;
}
else
{
$pg = $_GET['pg'];
}
if(!is_numeric($pg))
{
$pg = 1;
}
$con=mysql_connect("localhost","root","");
$base=mysql_select_db("mabase");
$enreg_par_pg = 3;
function pgs($enreg_par_pg, $pg, $con){
$res = mysql_query("SELECT * FROM reference",$con);
$nb_enreg = mysql_num_rows($res);
$nb_pg_rounded = ceil( $nb_enreg / $enreg_par_pg );
$pp = $pg - 1;
$ps = $pg + 1;
if($pg <= 1)
{
echo " || $nb_pg_rounded || page suivante";
}
elseif(($pg >= 1) and($pg <8))
{
echo " page précédente";
echo " page suivante";
}
else
{
echo " page précédente page suivante ";
}
}
$limit = $enreg_par_pg*$pg-$enreg_par_pg;
$remp = mysql_query("SELECT txt1,img1,id FROM reference order by id desc LIMIT $limit, $enreg_par_pg");
//$remp = mysql_query($req4);
//$req4 ="select txt1,img1,id from reference order by id desc";
//$remp = mysql_query($req4);
echo "
";
pgs($enreg_par_pg, $pg, $link);
//-------------------------------------------------------------------------
//$req4 ="select txt1,img1,id from reference order by id desc";
//$remp = mysql_query($req4);
////////////////////////////////////////////////////////
//$count = mysql_num_rows($remp);
////////////////////////////////////////////////////////
$a = 0;
echo '<table>----
';
while ($count = mysql_fetch_array($remp)) {
echo ', </td>';
echo '';
$k="aaaa";
echo "";
echo'
';
echo'';
echo '
'.$count['txt1'].'
';
echo'
';
echo', ';
echo ' , ';
$a++;
if ($a == 1) {
echo '----
';
$a = 0;
}
}
echo '
';
///////////////////////////////////////////////////// ?></td>
</tr>
</table></td>
</tr>
</table>
----
,
,
|,
Accueil,
|,
Qui sommes nous?,
|,
Formulaire d'offre,
|,
Contact,
|,
,
,
----
,
</html>
Afficher la suite