two lines of photos

Lucifix

Can anyone please tell me how can i rebuilt this code, so that i could see two line of 12 photos together (1 line - 6 photos):

<?php 
// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie 
define('ROOT_PATH', './4images/'); 

include(ROOT_PATH.'config.php'); 
include(ROOT_PATH.'includes/db_mysql.php'); 
include(ROOT_PATH.'includes/constants.php'); 

$site_db = new Db($db_host, $db_user, $db_password, $db_name); 
function is_remote($file_name) { 
  return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0; 
} 

// NUMBER OF THUMBNAILS TO DISPLAY / NUMMER DER GEWÜNSCHTEN THUMBNAILS 
$num_images = 6; 

$sql = "SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_comments 
        FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b 
        WHERE a.image_active=1 
        AND a.cat_id = b.cat_id 
        AND b.auth_viewcat=".AUTH_ALL." 
        AND b.auth_viewimage=".AUTH_ALL." 
        ORDER BY image_date DESC 
        LIMIT $num_images"; 
$result = $site_db->query($sql); 

echo '<table align="center"><tr>'; 
while ($row = $site_db->fetch_array($result)){ 
  $image_id = $row['image_id']; 
  $cat_id = $row['cat_id']; 
  $image_name = $row['image_name']; 
  $image_comments = $row['image_comments']; 
  $thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : ROOT_PATH.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file']; 

  echo '<td align="center">'; 
  echo "<center><a href=\"/povezava"><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a><br></center>\n"; 
  echo "<b><center>$image_name</b><br></center>\n"; 
  echo "<center>Komentarjev: $image_comments</center>\n"; 
  echo '</td>'; 
} 
echo '</tr></table>' 
?>

You can see how this code looks like here:
http://slo-foto.portal.si/

coreyp_1

Perhaps this is a start...

 <?php  

// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie 
define('ROOT_PATH', './4images/');  

include(ROOT_PATH.'config.php');  

include(ROOT_PATH.'includes/db_mysql.php');  

include(ROOT_PATH.'includes/constants.php');  

$site_db = new Db($db_host, $db_user, $db_password, $db_name);  

function is_remote($file_name) {  

  return (preg_match('#^https?\:\/\/[a-z0-9-]+.([a-z0-9-]+.)?[a-z]+#i', $file_name)) ? 1 : 0;  

}  

// NUMBER OF THUMBNAILS TO DISPLAY / NUMMER DER GEWÜNSCHTEN THUMBNAILS 
// EDIT: $num_images changed from 6 to 12
$num_images = 12;  

$sql = "SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_comments 
        FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b 
        WHERE a.image_active=1 
        AND a.cat_id = b.cat_id 
        AND b.auth_viewcat=".AUTH_ALL." 
        AND b.auth_viewimage=".AUTH_ALL."  

        ORDER BY image_date DESC  

        LIMIT $num_images";  

$result = $site_db->query($sql);  

// EDIT: $count used as a counting variable to keep track
// of how many pictures to display in a row
$count = 0;
echo '<table align="center"><tr>';  

while ($row = $site_db->fetch_array($result)){  

  $image_id = $row['image_id'];  

  $cat_id = $row['cat_id'];  

  $image_name = $row['image_name'];  

  $image_comments = $row['image_comments'];  

  $thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : ROOT_PATH.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'];  

  echo '<td align="center">';  

  echo "<center><a href=\"/povezava"><img src="".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a><br></center>\n";
// EDIT: changed the order of HTML <b> and <center> tags
  echo "<b><center>$image_name<br></center></b>\n";  

  echo "<center>Komentarjev: $image_comments</center>\n";  

  echo '</td>';
// EDIT: Add a new row after 6 pictures
  if ($count == 6)
    echo '</tr><tr>';
  $count++;  

}  

echo '</tr></table>'  

?>

if you wanted three rows of four, you could change the if statement to

  if (($count == 4) || ($count == 8))
    echo '</tr><tr>';

It should be very simple to modify it however you want.

HTH

Lucifix

thanks, but saidly it doesnt work. you can check:

http://slo-foto.portal.si/random1.php

this is old one:
http://slo-foto.portal.si/random.php

coreyp_1

This is odd.

I'm assuming that http://slo-foto.portal.si/random1.php is the script we are testing, right?

It does not make sense that nothing would be printed out. At the very least, the script should produce this:

<table align="center"><tr>
</tr></table>

It would seem that something else is killing your script early. I think it might be your database connection.

At any rate, you'll have to get that straitened out before we can properly test the script, since the changes I made to the code (which are clearly marked) are not even being executed before the script dies.

HTH