query results in multiple columns

SnowCrash · #1 (**permalink**) 10-08-03, 10:06 AM

I currently have a database which contains a series of image file names. Currently I can produce a single column of thumbnails without any problems. However, what I would like to do is have the data in 2 columns rather than one.

Here is a page with both examples http://www.c3s.co.uk/temp01.php

PHP Code:


			
<?php require_once('Connections/main.php'); ?>

<?php

$maxRows_test = 10;

$pageNum_test = 0;

if (isset($_GET['pageNum_test'])) {

  $pageNum_test = $_GET['pageNum_test'];

}

$startRow_test = $pageNum_test * $maxRows_test;



mysql_select_db($database_main, $main);

$query_test = "SELECT * FROM work_in_progress";

$query_limit_test = sprintf("%s LIMIT %d, %d", $query_test, $startRow_test, $maxRows_test);

$test = mysql_query($query_limit_test, $main) or die(mysql_error());

$row_test = mysql_fetch_assoc($test);



if (isset($_GET['totalRows_test'])) {

  $totalRows_test = $_GET['totalRows_test'];

} else {

  $all_test = mysql_query($query_test);

  $totalRows_test = mysql_num_rows($all_test);

}

$totalPages_test = ceil($totalRows_test/$maxRows_test)-1;

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>



<body>

<table width="300" border="0" cellspacing="0" cellpadding="0">

  <?php do { ?>

  <tr>

    <td><img src="http://www.c3s.co.uk/wip/<?php echo $row_test['wip_image']; ?>_tn.jpg"></td>

  </tr>

  <?php } while ($row_test = mysql_fetch_assoc($test)); ?>

</table>

</body>

</html>

<?php

mysql_free_result($test);

?>

This has all been done in Dreamweaver. Can anyone help with this (I hope the question is clear)

Thxs

Chroder · #2 (**permalink**) 10-08-03, 02:14 PM

Change this:

Quote:

<?php do { ?>
<tr>
<td><img src="http://www.c3s.co.uk/wip/<?php echo $row_test['wip_image']; ?>_tn.jpg"></td>
</tr>
<?php } while ($row_test = mysql_fetch_assoc($test)); ?>

To something like this:

PHP Code:


			
<tr>



<?php

$perrow = 2;

$counter = 0; 



do {

$counter++;

if($counter > $perrow)

{

    echo "</tr><tr>";

    $counter = 0;

}



 ?>

    <td><img src="http://www.c3s.co.uk/wip/<?php echo $row_test['wip_image']; ?>_tn.jpg"></td>

  <?php } while ($row_test = mysql_fetch_assoc($test));?>



</tr>

SnowCrash · #3 (**permalink**) 10-09-03, 03:08 AM

Fantastic - this works an absolute treat.

Many Thanks