[RESOLVED] what I´m doing wrong ?????? makes me crazy...

[lmcm2008]

Hi. I want to create a html table with php values
and I´m doing this dinamic code.

I´m doing something wrong, but don´t know what. Right now I have 2 images in the categoria APOLLO that I made to this code... but only see the first one.
Where is my mistake? How can I see not only 2...

Thanks a lot.

<?php

$cadena="SELECT * FROM fotografias WHERE CATEGORIA='APOLLO' ";
$result=mysql_query($cadena) or die(mysql_error());

$totalreg=mysql_num_rows($result);

$i=1;

?>

<table border=0>
<tr>

<?php

$camino="images/pictures/apollo/";

while ($fila=mysql_fetch_array($result))
	{
	$nompic=$fila['NOMFOTO'];
	$desc=$fila['DESCRIPCION'];

$foto="$camino$nompic.jpg";

list($ancho,$alto)=getimagesize($foto);

$nuevo_ancho=150;
$nuevo_alto=round($nuevo_ancho*$alto/$ancho);


if ( $i % 6 == 0 ) // 6 columns in my table...
	{
	if ( $i == 1 )
		{
		echo "<tr>";
		}
	  else
	  	  {
		  echo "</tr><tr>";
		  } 
	 }

  }	

echo "<td>";
echo "<img src=$foto width=$nuevo_ancho height=$nuevo_alto>";
echo "</td>";



?>


</table>

<?php
mysql_close();
?>

[leatherback]

Move this:

echo "<td>";
echo "<img src=$foto width=$nuevo_ancho height=$nuevo_alto>";
echo "</td>"; 

above the last curly bracket.

Now you end your while {} loop before you get to the printing of the actual output.

<?php

$cadena="SELECT * FROM fotografias WHERE CATEGORIA='APOLLO' ";
$result=mysql_query($cadena) or die(mysql_error());

$totalreg=mysql_num_rows($result);

$i=1;

?>

<table border=0>
<tr>

<?php

$camino="images/pictures/apollo/";

while ($fila=mysql_fetch_array($result))
    {
    $nompic=$fila['NOMFOTO'];
    $desc=$fila['DESCRIPCION'];

$foto="$camino$nompic.jpg";

list($ancho,$alto)=getimagesize($foto);

$nuevo_ancho=150;
$nuevo_alto=round($nuevo_ancho*$alto/$ancho);


if ( $i % 6 == 0 ) // 6 columns in my table...
    {
    if ( $i == 1 )
        {
        echo "<tr>";
        }
      else
            {
          echo "</tr><tr>";
          }
     }


echo "<td>";
echo "<img src=$foto width=$nuevo_ancho height=$nuevo_alto>";
echo "</td>";

}        

?>


</table>

<?php
mysql_close();
?>

[lmcm2008]

Hi. Great !!!... I was having a blue screen like microsoft !!.. jaja

Ok, now I see all the photos, but I would like to make a table where the images appears in 6 colums and the rows that depends on how many pics I have...

I mean.. I like to appear in this way in the table:
1-2-3-4-5-6
7-8-9-10-11-12
13-14... etc etc... depending on the number of images or records in my database.

Can you help me? What I have to change in the for secuence ( I thing is there ) to have this result??

Thanks a lot for your help.

Regards

[leatherback]

THat is something you should figure out yourself. Not to be harsh, but it is not coding dificulty, but pure logic that is required here. I know you can figure it out, as the code you have shown pretty much has all of it. Just note you need to set $i=0; before you enter the while() loop, and add one to the $i on each line like so: $i++;

Then all you need to do is count lines, loops and of course ensure you finalize the table.

Naturally, I would not use a table, but free-floating <div>'s which you stack using CSS.