While qui ne boucle pas
Résolu
hamidoo07
Messages postés
120
Statut
Membre
-
hamidoo07 Messages postés 120 Statut Membre -
hamidoo07 Messages postés 120 Statut Membre -
Bonjour,
voila j'utilise la boucle while pour copier le contenu d'une tab dans une autre tab
mais la boucle ne traite que le premier enregistrement
$req=mysql_query("select distinct catt from subcat");
while($res=mysql_fetch_row($req)){
$catt=$res[0];
echo $catt;
$req=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')");
}
svp j'ai pas pu trouver la solution
voila j'utilise la boucle while pour copier le contenu d'une tab dans une autre tab
mais la boucle ne traite que le premier enregistrement
$req=mysql_query("select distinct catt from subcat");
while($res=mysql_fetch_row($req)){
$catt=$res[0];
echo $catt;
$req=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')");
}
svp j'ai pas pu trouver la solution
A voir également:
- While qui ne boucle pas
- Xiaomi s'éteint tout seul et se rallume en boucle - Forum Xiaomi
- Application error: a client-side exception has occurred while loading www.leboncoin.fr (see the browser console for more information). - Forum Réseaux sociaux
- Mise à disposition de boucle locale dédiée ✓ - Forum Freebox
- Vlc lecture en boucle ✓ - Forum Lecteurs et supports vidéo
- Redémarrage en boucle Xiamo mi note 10 - Forum Xiaomi
2 réponses
C'est parce que lors de ta deuxième boucle, la valeur de $req a changé.
Remplace le : $req=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')"); par
$req1=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')");
Remplace le : $req=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')"); par
$req1=mysql_query("INSERT INTO `jos151_sections` ( `id` , `title` , `name` , `alias` , `image` , `scope` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `ordering` , `access` , `count` , `params` )values('','$catt','','$catt','','content','left','',1,0,'$date',1,0,0,'')");
