Salut j'ai essayer de faire une script qui affiche page par page des article que moi l'admin je poste sur ma partie index de mon site voici mes erreur:
1:Notice: Undefined variable: record in c:\mes_sites_web\cbc\article\index_article.php on line 139
2/Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\mes_sites_web\cbc\article\index_article.php on line 161
3:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\mes_sites_web\cbc\article\index_article.php on line 169
mon script est le suivant:
<?
$display=10;
if(isset($_GET['p']) && is_numeric($_GET['p']))
{
$page=$_GET['p'];
}
else{
include('config.php');
$q="SELECT count(id_article) from article";
$r=@mysql_query($q);
$row=@mysql_fetch_array($q);
$records=$row[0];
if($record>$display)
{
$page=ceil($record/$display);
}else{
$page=1;
}
}
if(isset($_GET['s']) && is_numeric($_GET['s']))
{
$start=$_GET['s'];
}
else{
$start=0;
}
$q=" SELECT titre,nom,texte,email,DATE_FORMAT(poster,%M %d,%Y) AS poster,id_article FROM article ORDER BY poster ASC LIMIT $start,$display";
$r=@mysql_query($q);
echo'<table align="center" cellspacing=0 cellpadding=5 width="550" height="351">
<tr>
<td>LISTE DES RESOUCES PAR ORDRE</td><tr>
<tr>
<td>COMPTE RENDU</td>
<td>POSTE LE</td></tr> ';
$dta=mysql_num_rows($r);
if($dta>0)
{
echo'<tr><td></td>
<td><em>'.$dta['texte'].'</em></td></tr>
<td>'.$dta['poster'].'</td>';}
$bg='#eeeeee';
while($row=mysql_fetch_array($r))
{
$bg=($bg=='#eeeeee'?'#E8E4BD':'#eeeeee') ;
echo'<tr bgcolor="'.$bg.'">
<td align="left"><a href="read_article.php?id='.$row['id_article'].'">LIRE</a></td>'.$row['poster'].'</td></tr>';}
echo'</table>';
mysql_free_result($r);
mysql_close();
if($page>1)
{
echo'<br/><p>';
$current_page=($start/$display)+1;
if($current_page != 1)
{
echo'<a href="index_article.php?s='.($start-$display).'$p='.$page.'">Precécédent</a>';
}
for($i=1;$i<=$page;$i++)
{
if($i!=$current_page)
{
echo'<a href="index_article.php?s='.(($display*($i-1))).'$p='.$page.'">'.$i.'</a>';
}
else
{
echo $i.'';
}
}
if($current_page != $page)
{
echo'<a href="index_article.php?s='.($start+$display).'$p='.$page.'">Suivant</a>';
}
echo'</p>';
}
?>