Display database fields in Table

[FJW]

Could anyone help with this 'trivial' problem?
I wat to display from my database 3 fields in a checkerboard type display of pictures. Heading, Pic and Location should appear in each square.
I can get the data to display one under the other without a problem but next to each other, hmmm

Best regards
Fred

[bad76]

Hi,
you can't directly, because the html draw from top to bottom.
You can do something using a temporary array of N position, where N is the num of pic per line. (It's not easy to tell...)

You can look in db for N row, memorize the string to echo in 3 array of N position, then echo it on screen. And repeat all for each row in db.

...hmm ... this helps? 😃

If you don't understand me, ask more, I'll try to do an example...

[bubblenut]

<?php
for($i=0;$row=mysql_fetch_array($res);$i++) {
  if($i%3==0) {
    ?>
  </tr><tr>
    <?php 
  }
  if($i%6<3) {
    ?>
    <td></td>
    <td><?=$row['details']?></td>
    <?php
  } else {
    ?>
    <td><?=$row['details']?></td>
    <td></td>
    <?php
  }
}
?>

I Think that would work. Haven't tested it though.
Good Luck
Bubble

[FJW]

Thanks for replies guys.
Bad76 I like the idea, can you send me an example please.
Bubblenut will try yours but I think have been there and failed already. Have tried to find a working example of this apparently simple code, but its not so easy.
:-)

[bad76]

Ok, I try "on the fly"...

 
$_NUM=5; //row per line
$num=mysql_num_rows($result);
while($j=0; $j<$num; $j+=$_NUM)
{
  for($i=$j; ($i<$_NUM) && ($j+$i<$num); $i++)
  {
    $row=mysql_fetch_array($result);
    $head[$i]=$row["Head"];
    $pic[$i]=$row["Pic"];
    $loc[$i]=$row["Location"];
  }
  echo "<tr>";
  for($i=$j; ($i<$_NUM) && ($j+$i<$num); $i++)  echo "<td>".$head[$i]."</td>";
  echo "</tr>";
  echo "<tr>";
  for($i=$j; ($i<$_NUM) && ($j+$i<$num); $i++)echo "<td>".$pic[$i]."</td>";
  echo "</tr>";
  echo "<tr>";
  for($i=$j; ($i<$_NUM) && ($j+$i<$num); $i++)echo "<td>".$loc[$i]."</td>";
  echo "</tr>";
}

Get NRow from DB and put it in array, then echo the array in one line...

[mrhappiness]

$result=mysql_query('SELECT ...');
while ($rows[]=mysql_fetch_assoc($result));
array_pop($rows);
echo '<table>';
$count=0;
foreach ($rows as $value)
{
  if ($row%4==0)
    echo '<tr>';
  $row++;
  echo '<td>';
  output_array($value); //non-existent function, just to give you a hint
  echo '</td>';
  if ($row%4==0)
    echo '</tr>';
}
if ($row%4!=0)
  echo '</tr>';
echo '</table>';

try this

edit:
or bad76's one 🙂

[bad76]

Originally posted by mrhappiness
try this
edit:
or bad76's one 🙂

A sametime post, eh? 😉

[FJW]

Now this looks better, will make coffee, then back to work.
2 lumps or 3?

F

[tekky]

Something like this could work.... (code from a question I helped with last night --- butchered and modified severly since last night)

//query would happen up here....
if($count = mysql_num_rows($result) > 0) { 
	/* If we have results, loop through them */ 

$max=3; /* number of columns before starting new set of data*/ 
/* popuplate an array with the image info */
while($images[] = mysql_fetch_assoc($result))
$count = count($images);

/* pad array to a number that fully populates the table with an array so the check doesnt error*/
if ($count % $max)
{
	$images = array_pad($images, $count + ($max - ($count % $max)), array(1));
	$count = count($images);
}
/* create table and first row */ 
echo '<table border=1><tr>';
for($i=0;$i<$max;$i++)
{
	echo "<td>Column $i+1</td>";
}
echo "</tr>\n";
for($i=0;$i<$count;$i+=3) /* loop through and build the table */
{ 
	for($j=0;$j<$max;$j++)
	{
		if ($j == 0)
		{
			$headings = $pics = $locations = '<tr>'; 
		}
		if ($j == $max-1)
		{
			$headings .= "</tr>\n";
			$pics .= "</tr>\n";
			$locations .= "</tr>\n";
		}
		$image = $images[$i+$j]; //now an array matching the rows from the SQL Query
		if(isset($image['some_column_from_db_thats_never_null'])) /* due to this check, we had to pad the array, with an array */
		{
			$headings .= '<td>' .$image['heading_column']. '</td>';
			$pics .= '<td><img src="' .$image['path_to_pic_for_img_src']. '"></td>';
			$locations .= '<td>' .$image['location_pic']. '</td>';
		}
		else
		{ 
			$headings .= '<td>&nbsp;</td>';
			$pics .= '<td>&nbsp;</td>';
			$locations .= '<td>&nbsp;</td>';
		}
	}
	echo $headings;
	echo $pics;
	echo $locations;
}
echo '</table>'; //close the table...
}

[FJW]

My sincer thanks for the time taken guys.
I love commented code.
Have got it working already so thanks once again.

Hope in the future I may be able to reciprocate:-)
F