voila je suis un debutant et je suis en train de faire un site de contenu, j'ai un probleme de requete pr afficher le contenu:
<?php
$sql = 'SELECT count(*) FROM `ma_table`';
$sql=$sql/8;
$cpt1=0;
$cpt=0;
$u_page=0;
while($cpt1<$sql)
{$cpt++;$cpt1++;
if(($u_page%20)==0){echo'</td></tr><tr><td>';}
if($cpt=1)
{$cpt=0;$u_page+=1;$u_debut=(($u_page-1)*8);
echo' <A style="TEXT-DECORATION: none"
href="test3.php?u_debut='.$u_debut.'"><FONT
face=Verdana size=3><b>'.$u_page.'</b></FONT></A>';}}
?>
ceci est mon script de pagination; et maintenant l'affichage:
<?php
$debut=$_GET['u_debut'];
if(isset($nb_page)){$sql1 = 'SELECT `id`,etc FROM `ma_table` ORDER BY `date_ajout` DESC LIMIT'.$debut.',8';}
else{$debut=0;$sql1 = 'SELECT `id`,etc FROM `ma_table` ORDER BY `date_ajout` DESC LIMIT'.$debut.',8';}
$query1 = mysql_query($sql1);
while($videos = mysql_fetch_assoc($query1)) //ligne 128
{
echo' <tr><td> '.id.' etc.... </td></tr> ';}
?>
et il me sort comme erreur:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home5/sub001/sc12050-CYYB/fastx/videosebb.php on line 128.
si quelqu'un pouvai m'aider sa serai sympa. merci d'avance!
<?php
$sql = 'SELECT count(*) FROM `ma_table`';
$sql=$sql/8;
$cpt1=0;
$cpt=0;
$u_page=0;
while($cpt1<$sql)
{$cpt++;$cpt1++;
if(($u_page%20)==0){echo'</td></tr><tr><td>';}
if($cpt=1)
{$cpt=0;$u_page+=1;$u_debut=(($u_page-1)*8);
echo' <A style="TEXT-DECORATION: none"
href="test3.php?u_debut='.$u_debut.'"><FONT
face=Verdana size=3><b>'.$u_page.'</b></FONT></A>';}}
?>
ceci est mon script de pagination; et maintenant l'affichage:
<?php
$debut=$_GET['u_debut'];
if(isset($nb_page)){$sql1 = 'SELECT `id`,etc FROM `ma_table` ORDER BY `date_ajout` DESC LIMIT'.$debut.',8';}
else{$debut=0;$sql1 = 'SELECT `id`,etc FROM `ma_table` ORDER BY `date_ajout` DESC LIMIT'.$debut.',8';}
$query1 = mysql_query($sql1);
while($videos = mysql_fetch_assoc($query1)) //ligne 128
{
echo' <tr><td> '.id.' etc.... </td></tr> ';}
?>
et il me sort comme erreur:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home5/sub001/sc12050-CYYB/fastx/videosebb.php on line 128.
si quelqu'un pouvai m'aider sa serai sympa. merci d'avance!