[Resolved] Automated Layout cells creation ;)

kikki

Hi guys!
I need help in viewing the categories in a proper way. My code is listing the categories in 3 cells but not properly... could someone please fix this table problem so it list the items properly on the 'left', 'center' and right cells?

Thanks!

 <?
//connect
include 'config.php';



<table width="100%" border="1" cellspacing="0" >  

// prepare the query string
$query = "SELECT id, category, DATE_FORMAT(date, '%d.%m.%Y') ". 
"FROM gallery_category ".
"ORDER BY id DESC ";

// execute the query
$result = mysql_query($query) or die('Error, query failed [$query]'); 

// get cate...
while($row = mysql_fetch_array($result))
{
// from an array values
list($id,$categories,$date) = $row; 

$categories = htmlspecialchars($categories);
$date = htmlspecialchars($date);

 ?>

 <tr>   <td rowspan="3" width="33%" height="20" align="center" valign="middle" bgcolor="#CCCCCC"> 
      <?
	echo $categories;
	echo '<br>';
	echo $date; 
	?>
    </td>  </tr>
  <?
}
?>

</table>  

</body>
</html>

Roger_Ramjet

Originally posted by kikki

 <?
//connect
include 'config.php';

<table width="100%" border="1" cellspacing="0" >  

  <?
// prepare the query string
$query = "SELECT id, category, DATE_FORMAT(date, '%d.%m.%Y') ". 
"FROM gallery_category ".
"ORDER BY id DESC ";

// execute the query
$result = mysql_query($query) or die('Error, query failed [$query]'); 

// get cate...
while($row = mysql_fetch_array($result))
{
// ******** just do this  **********

$categories = htmlspecialchars($row['categories']);
$date = htmlspecialchars($row['date']);

// WHAT ?? is this?? If you want 3 columns then this is not the html that will do that
 <tr>   <td rowspan="3" width="33%" height="20" align="center" valign="middle" bgcolor="#CCCCCC"> 
      <?
	echo $categories;
	echo '<br>';
	echo $date; 
	?>
    </td>  </tr>
  <?
}


// Try this

echo '<tr>
         <td width="33%">' . $row['id'] . '</td>
         <td width="33%">' . $categories . '</td>
         <td>' . $date . '</td></tr>';
?>


</table>  

</body>
</html>

[/B]

kikki

Hi Roger Ramjet,
thanks for the reply, still the tables are messed up. I don't want to show id, date and category titles in different cells.

I was trying to List only category titles in 3 columns, like this:

Category 1 Category 2 Category 3
Category 4 Category 5 Category 6
Category 7 Category 8 Category 9
Category 10 Category 11 Category 12
....... ...... .......

kikki

Anyone? 😕 😕

Roger_Ramjet

Sorry I did not get back to you sooner, been a bit lax lately.

Have a look at my posts in this thread

I cover this in both directions: 3 cols going across and 3 cols going down. Down is best using an ordered list (html tag <ol>). I have included a general purpose function to calculate the number of rows down for any number of item in any number of columns, that you then use to control the loops. Good luck with it.

kikki

Hi Roger Ramjet!
I've solved the problem already... but thanks man 🙂