do..While (condition)

yoni

I'm a REAL newbie !

I have began php through Dreamweaver.

I want :

Town 1
ggg - town1

Town 2
xxx - town2
yyy - town2

I have done

<?php do { ?>
Town

<?php do { ?>
address data
<?php } while ($row_rs_adrshow = mysql_fetch_assoc($rs_adrshow)); ?>
<?php } while ($row_rs_ville = mysql_fetch_assoc($rs_ville)); ?>

The output is (http://www.israelfr.com/adr/adr_country.php)

Town 1
ggg - town1
xxx - town2
yyy - town2

Town 2

.... And that's it ! 🙁

I'm looking for a kind of

<?php } while ($row_rs_adrshow = mysql_fetch_assoc($rs_adrshow)); ?> as long as town = address data town

Any clue ???

OhLordy

Not quite sure I understand. Could you post the whole of your code please so I can see the context.

Cheers
Rob

yoni

Here it comes...

        <tr>
          <td colspan="3" valign="top" bgcolor="#000066"><font color="#FFFFFF" size="2">
		  <a name="<?php echo $row_rs_ville['ville']; ?>">&nbsp;&nbsp;<?php echo $row_rs_ville['ville']; ?></a></font>			  </td>
        </tr>

		<?php do { ?>	
        <tr>
          <td width="28%" valign="top"> <b><font color="#0033FF"><?php echo $row_rs_adrshow['nom']; ?></font></b><br>
              <font size="2"><?php echo $row_rs_adrshow['desc']; ?></font> </td>
          <td width="62%" valign="top"> <font size="2"> <?php echo $row_rs_adrshow['adresse']; ?> - <?php echo $row_rs_adrshow['code']; ?> <?php echo $row_rs_adrshow['ville']; ?> <br>
                <br>
  Tel : <?php echo $row_rs_adrshow['tel']; ?><br>
  Fax : <?php echo $row_rs_adrshow['fax']; ?><br>
  Email : <a href="mailto:<?php echo $row_rs_adrshow['email']; ?>"><?php echo $row_rs_adrshow['email']; ?></a></font></td>
          <td width="10%" valign="middle"><center>
              <?php
			if ($row_rs_adrshow['website']=="oui")
				{
				echo "<a href=\"http://www.israelweb.co.il\" target=\"_blank\">
					<img src=\"../images/goline.gif\" border=\"0\" alt=\"Website disponible sur Israelweb le moteur de recherche sur Israel et le Judaisme\" longdesc=\"http://www.israelweb.co.il\"></a>";
				}
			elseif ($row_rs_adrshow['website']=="non")
				{
				echo "";
				}
			?>
            </center>
          </td>
        </tr>
        <tr bgcolor="#0066CC">
          <td height="2" colspan="3" valign="top"></td>
        </tr>
      <?php } while ($row_rs_adrshow = mysql_fetch_assoc($rs_adrshow)); ?>


	 <?php } while ($row_rs_ville = mysql_fetch_assoc($rs_ville)); ?>
      </table>

    </div>
  </td>
</tr>

</table>

Is it enought or you need all the page ? (thanks of course 🙂)
Yoni

OhLordy

What are the sql queries you are using.
Cheers
Rob

PS
putting your code in [ php ][ /php ] tags (minus the spaces between the ['s and the php's) highlights the code and makes it a lot easier to read.

yoni

Ok, here it comes...

I have clean all the code to keep only the php part
I hope i have well placed the [ php ] stuff.

<?php require_once('../Connections/Israelfr.php'); ?>
<?php
$colcategorie_rs_adrshow = "adrc";
if (isset($HTTP_GET_VARS['categorie'])) {
  $colcategorie_rs_adrshow = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['categorie'] : addslashes($HTTP_GET_VARS['categorie']);
}
$colpays_rs_adrshow = "France";
if (isset($HTTP_GET_VARS['pays'])) {
  $colpays_rs_adrshow = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['pays'] : addslashes($HTTP_GET_VARS['pays']);
}
mysql_select_db($database_Israelfr, $Israelfr);
$query_rs_adrshow = sprintf("SELECT * FROM adr_data WHERE categorie = '%s' AND pays = '%s'", $colcategorie_rs_adrshow,$colpays_rs_adrshow);
$rs_adrshow = mysql_query($query_rs_adrshow, $Israelfr) or die(mysql_error());
$row_rs_adrshow = mysql_fetch_assoc($rs_adrshow);
$totalRows_rs_adrshow = mysql_num_rows($rs_adrshow);

$colcategorie_rs_ville = "adrc";
if (isset($HTTP_GET_VARS['categorie'])) {
  $colcategorie_rs_ville = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['categorie'] : addslashes($HTTP_GET_VARS['categorie']);
}
$colpays_rs_ville = "France";
if (isset($HTTP_GET_VARS['pays'])) {
  $colpays_rs_ville = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['pays'] : addslashes($HTTP_GET_VARS['pays']);
}
mysql_select_db($database_Israelfr, $Israelfr);
$query_rs_ville = sprintf("SELECT DISTINCT ville FROM adr_data WHERE categorie = '%s' AND pays = '%s' ORDER BY ville ASC", $colcategorie_rs_ville,$colpays_rs_ville);
$rs_ville = mysql_query($query_rs_ville, $Israelfr) or die(mysql_error());
$row_rs_ville = mysql_fetch_assoc($rs_ville);
$totalRows_rs_ville = mysql_num_rows($rs_ville);

$colcategorie_rs_villeliste = "adrc";
if (isset($HTTP_GET_VARS['categorie'])) {
  $colcategorie_rs_villeliste = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['categorie'] : addslashes($HTTP_GET_VARS['categorie']);
}
$colpays_rs_villeliste = "France";
if (isset($HTTP_GET_VARS['pays'])) {
  $colpays_rs_villeliste = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['pays'] : addslashes($HTTP_GET_VARS['pays']);
}
mysql_select_db($database_Israelfr, $Israelfr);
$query_rs_villeliste = sprintf("SELECT DISTINCT ville FROM adr_data WHERE categorie = '%s' AND pays = '%s' ORDER BY ville ASC", $colcategorie_rs_villeliste,$colpays_rs_villeliste);
$rs_villeliste = mysql_query($query_rs_villeliste, $Israelfr) or die(mysql_error());
$row_rs_villeliste = mysql_fetch_assoc($rs_villeliste);
$totalRows_rs_villeliste = mysql_num_rows($rs_villeliste);
?>

  <?php
			if ($HTTP_GET_VARS['categorie']=="adrc")
				{
				echo "<font color=\"#000099\" size=\"4\" face=\"Times New Roman, Times, serif\"><b>Les adresses des organismes et associations culturelles juives et israéliennes</b></font>";
				}
			elseif ($HTTP_GET_VARS['categorie']=="adrr")
				{
				echo "Les adresses des synagogues et organismes religieux juifs";
				}
			elseif ($HTTP_GET_VARS['categorie']=="mouvjj")
				{
				echo "Les adresses des mouvements de jeunesse juifs";
				}
			elseif ($HTTP_GET_VARS['categorie']=="adrsp")
				{
				echo "Les adresses des écoles et services éducatifs juifs";
				}
			elseif ($HTTP_GET_VARS['categorie']=="adrrc")
				{
				echo "<font color=\"#000099\" size=\"4\" face=\"Times New Roman, Times, serif\"><b>La liste de restaurants et pâtisseries</b></font><br><br><br>Nous mettons &agrave; votre disposition une liste de restaurants et pâtisseries francophones et/ou francophones.";
				}
			?>

<P><font size="2" face="Arial, Helvetica, sans-serif"><a href="addadr.php" target="_top">Vous
connaissez un établissement qui n'apparait pas ici ?</a></font>
<table width="85%" border="0">
<caption> 
</caption>
<tr>
<td><P align="center"><font size="5"><b><?php echo $row_rs_adrshow['pays']; ?></b></font>
<P align="left"><font face="Times New Roman, Times, serif" size="3"><b>Villes</b></font>
<ul>

        <?php do { ?>
        <li><a href="#<?php echo $row_rs_villeliste['ville']; ?>"><?php echo $row_rs_villeliste['ville']; ?></a> </li>
        <?php } while ($row_rs_villeliste = mysql_fetch_assoc($rs_villeliste)); ?>

</ul>
<table width="100%" border="0" cellspacing="5">

        <?php do { ?>
        <tr>
          <td colspan="3" valign="top" bgcolor="#000066"><font color="#FFFFFF" size="2"> <a name="<?php echo $row_rs_ville['ville']; ?>">&nbsp;&nbsp;<?php echo $row_rs_ville['ville']; ?></a></font> </td>
        </tr>
        <?php do { ?>
        <tr>
          <td width="28%" valign="top"> <b><font color="#0033FF"><?php echo $row_rs_adrshow['nom']; ?></font></b><br>
            <font size="2"><?php echo $row_rs_adrshow['desc']; ?></font> </td>
          <td width="62%" valign="top"> <font size="2"> <?php echo $row_rs_adrshow['adresse']; ?> - <?php echo $row_rs_adrshow['code']; ?> <?php echo $row_rs_adrshow['ville']; ?> <br>
            <br>
            Tel : <?php echo $row_rs_adrshow['tel']; ?><br>
            Fax : <?php echo $row_rs_adrshow['fax']; ?><br>
            Email : <a href="mailto:<?php echo $row_rs_adrshow['email']; ?>"><?php echo $row_rs_adrshow['email']; ?></a></font></td>
          <td width="10%" valign="middle"><center>
              <?php
				if ($row_rs_adrshow['website']=="oui")
					{
					echo "<a href=\"http://www.israelweb.co.il\" target=\"_blank\">
						<img src=\"../images/goline.gif\" border=\"0\" alt=\"Website disponible sur Israelweb le moteur de recherche sur Israel et le Judaisme\" longdesc=\"http://www.israelweb.co.il\"></a>";
					}
				elseif ($row_rs_adrshow['website']=="non")
					{
					echo "";
					}
				?>
            </center>
          </td>
        </tr>
        <tr bgcolor="#0066CC">
          <td height="2" colspan="3" valign="top"></td>
        </tr>
        <?php } while ($row_rs_adrshow = mysql_fetch_assoc($rs_adrshow)); ?>
        <?php } while ($row_rs_ville = mysql_fetch_assoc($rs_ville)); ?>

</table>
</div>
</td>
</tr>
</table>
</BODY>
</HTML><?php
mysql_free_result($rs_adrshow);

mysql_free_result($rs_ville);

mysql_free_result($rs_villeliste);
?>

TTT

well use mysql_fetch_row() not do...while.
ex. do while is usefull when looping
for
if ...
do
while
...;
else
.... basic routines