[RESOLVED] help me out with this galer script

[donkru]

i have this script what i want to do is make a 4 x inf gallery. what i mean is like this
[image1] [image2] [image3] [image4] and then on the next line
[image5] [image6] [image7] [image8] and so on. here is my script. what i am curently getting is
[image1] [image1] [image1] [image1]
[image2] [image2] [image2] [image2] and so on. can you help me out thanks

{
$query = "SELECT *
FROM users
WHERE privelages > 80 <100
ORDER BY privelages DESC";
$result = mysql_query($query); 
$staffcount = mysql_num_rows($result);

if(!$result){
	echo mysql_error();}

for ($count = 0; $count < $staffcount; $count++) {
	$stafflist = mysql_fetch_array($result);
    $name = $stafflist['first_name'];
    $title = $stafflist['title'];
	$picture = $stafflist['avatar'];
$output .= '<table width="100%" border="0">
  <tr>
    <td width="25%">'.$picture.'</td>
    <td width="25%">'.$picture.'</td>
    <td width="25%">'.$picture.'</td>
    <td width="25%">'.$picture.'</td>
  </tr>
  <tr>
    <td><p>'.$name.' \ '.$title.' </p>
    </td>
    <td>'.$name.' \ '.$title.' </td>
    <td>'.$name.' \ '.$title.' </td>
    <td>'.$name.' \ '.$title.' </td>
  </tr>
</table>';
}
echo $output;
}

[leatherback]

Almost...

Something like:

{
$query = "SELECT *
FROM users
WHERE privelages > 80 <100
ORDER BY privelages DESC";
$result = mysql_query($query);

if(!$result){
    echo mysql_error();}
else
  {
  $i=1;
  $output .= '<table width="100%" border="0">';
  while($stafflist = mysql_fetch_array($result))
    {
    $j = $i%4   // What is left when we remove al multitudes of 4 from $i
    if($j == 1) // First run: Add <tr>
      {
       $output .= "<tr>";
      }    $name = $stafflist['first_name'];
    $title = $stafflist['title'];
    $picture = $stafflist['avatar'];
    $output .= "<td width=\"25%\">".$picture."<br />".$name." \ ".$title." </td>";
    if($j ==0)  // Last of row: Add </tr>
      {
       $output .= "</tr>";
      }
    $i++;
  }

for($j = $i%4; $j<4;$j++)  // Finish the table
  {
  $output .= "<td></td>";
  }

$output .= "</table>";

echo $output;
} 

[donkru]

hey, your a life saver, thanks, there were some small parse errors but doesnt matter i patched up and worked great, its the same script but had like a ; and a } missing, hey at least its only 2 when i code i have like an error on every line. THANK YOU!!! 😃 😃 😃
heres the script with the parse corrected

{
$query = "SELECT *
FROM users
WHERE privelages > 80 <100
ORDER BY privelages DESC";
$result = mysql_query($query);

if(!$result){
    echo mysql_error();}
else
  {
  $i=1;
  $output .= '<table width="100%" border="0">';
  while($stafflist = mysql_fetch_array($result))
    {
    $j = $i%4;   // What is left when we remove al multitudes of 4 from $i
    if($j == 1) // First run: Add <tr>
      {
       $output .= "<tr>";
      }    $name = $stafflist['first_name'];
    $title = $stafflist['title'];
    $picture = $stafflist['avatar'];
    $output .= "<td width=\"25%\">".$picture."<br />".$name." \ ".$title." </td>";
    if($j ==0)  // Last of row: Add </tr>
      {
       $output .= "</tr>";
      }
    $i++;
  }

for($j = $i%4; $j<4;$j++)  // Finish the table
  {
  $output .= "<td></td>";
  }}

$output .= "</table>";

echo $output;
}

[leatherback]

Good to hear it worked for you, glad to be of help.. please mark the thread resolved (Under thread tools)