[Resolved] Break after certain number of pictures...

[mscreashuns]

Okay, I have a website for my machinima series, Summerbreeze.

I have a page for the cast, and I have the entire cast stored in a MYSQL database, with four columns:

ID
Name
Picture
Bio

I figured out how to get them added, but I need some help getting them to be displayed. You see, I have it so that all of the pictures show, and then I'm going to link them to their individual page each. That's fine. But how can I insert a break into the code after a certain number of pictures without having to manually put in images and everything?

Here's the page I'm working on:

http://mscreashuns.savefile.com/summerbreeze/cast.php

You can see they go

Picture
Picture
Picture
...

I want them to go

Picture Picture Picture
Picture Picture Picture
...

Here's the code I am using now for the above page:

<? include("header.inc"); 

// Make a MySQL Connection
mysql_connect("HOST", "USERNAME", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE_NAME") or die(mysql_error());
// Get all the data from the "cast" table
$result = mysql_query("SELECT * FROM cast") 
or die(mysql_error()); 

echo "<table align=center cellspacing=7 cellpadding=0 border='0'>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td><img src='";
echo $row['picture'];
echo "' width=111 height=300 ALT='";
echo $row['name'];
echo"'></td></tr>";
} 
echo "</table>"; 


 include("footer.inc"); ?>

The headers and footers aren't an issue, just the stuff in between. If you can tell me how I can make it break after three pictures. Right now I have it breaking after each picture. Thanks!

[leatherback]

Hi
like this:

$i=1;
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table

echo "<tr><td><img src='";
echo $row['picture'];
echo "' width=111 height=300 ALT='";
echo $row['name'];

if($i <= 3)
  {
   echo "</td><td>";
  }
else
  {
  echo"'></td></tr>"; 
  $i = 0;
  }
$i++

}

[mscreashuns]

Okay, I put that code into my first code and I get this error:

Parse error: parse error, unexpected '}' in /home/auxjatrg/public_html/summerbreeze/cast.php on line 33

Here's my full code with the code that you gave me inserted.

<? include("header.inc"); 

// Make a MySQL Connection
mysql_connect("HOST_NAME", "USERNAME", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE_NAME") or die(mysql_error());
// Get all the data from the "cast" table
$result = mysql_query("SELECT * FROM cast") 
or die(mysql_error()); 

echo "<table align=center cellspacing=7 cellpadding=0 border='0'>";

// keeps getting the next row until there are no more to get
$i=1; 
while($row = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 

echo "<tr><td><img src='"; 
echo $row['picture']; 
echo "' width=111 height=300 ALT='"; 
echo $row['name']; 

if($i <= 3) 
  { 
   echo "</td><td>"; 
  } 
else 
  { 
  echo"'></td></tr>";  

  $i = 0; 
  } 
$i++ 

}
echo "</table>"; 


 include("footer.inc"); ?>

Did I put it in the wrong place? Did I overwrite something I needed? Perhaps if you could give me the full code with the code you gave me it would help...

[leatherback]

Hey,

You need a ; after the $i++. that will prob. solve the problem

[mscreashuns]

Yep, that was it. Thanks. 😃