Displaying record fields in random cells of a table

doctortim

Hi there everyone.

I'm building my page that lists records present in the database.

This seems easy, but how do I put data from different fields of a record, into different cells of a multiple row table.

When I try to do this it fills the cells that are in the first row but none after this.
I am looping the table (for each record in the db), with echo statements placed in cells I want filled.

This seems like an everyday thing to want to do, especially for the presentation layer of a site, but all the examples out there just have the usual looping of a single row of results.

Kudose

Post some code

doctortim

OK well you asked for it...hehe

Here is the list file. Rather than looping a single row of each record, I want to loop a table, for each record, with the field results layed out in the table as I see fit.


<?php

include('include/connect_sql.inc.php');
// create database connection


$sql = 'SELECT * FROM blogprofessional ORDER BY created DESC';
$result = mysql_query($sql) or die(mysql_error());

?>




<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<style type="text/css">

#table_holder {
	font-family: Tahoma;
	font-size: x-small;
	letter-spacing: .16em;
	padding-right: 143px;
	padding-left: 160px;
}
body {
	background-color: #333333;
}
.style1 {color: #996666}
.style3 {font-family: Tahoma}
.style10 {color: #CCCC66}
.style3 {	font-family: Tahoma;
	font-size: small;
	letter-spacing: .2em;
}
.style4 {	letter-spacing: 0.4em;
	font-size: x-large;
	color: #99CC66;
}
.style9 {color: #009933}
.style7 {color: #FFFFFF}
.style8 {color: #FFFFFF; font-weight: bold; }

.style11 {	letter-spacing: 0.4em;
	font-size: large;
	color: #99CC66;
}
.style13 {color: #FFFFFF; font-size: small; }
</style>
</head>

<body>

<div id="table_holder">
<p align="center" class="style3"><br />
    <img src="tj_heading.png" alt="" width="573" height="66" /><span class="style11"><br />
      ADMINISTRATION SYSTEM [v1.0]</span><br />

</p>
<hr align="center" />
<p align="center" class="style3"><br />
</p>
<p align="center"><span class="style3">
  <label></label>
  </span></p>
<p align="center">&nbsp;</p>




<table width="856" height="478" cellspacing="3">



<tr>
  <td height="131" colspan="4" align="left" valign="top"><span class="style3"><span class="style4">BLOG - LISTING OF RECORDS</span><br />
    <br />
<span class="style9">Environment:</span> <span class="style10">Professional<br />
<br />
Search Records<br />
<br /> 
Result Display<br />
<br />
</span></span></td>
    </tr>

<?php while($row = mysql_fetch_assoc($result)) { ?>

<tr>
  <td height="15" colspan="4" align="left" valign="top">&nbsp;</td>
</tr>


<tr>
  <td width="87" height="26" align="center" valign="middle" bgcolor="#666666"><span class="style8">Issue #</span></td>
  <td width="147" align="center" valign="middle" bgcolor="#666666"><span class="style8">Issue Date</span></td>
  <td width= 230 align="center" bgcolor="#666666"><span class="style8">Focus</span></td>
  <td width= 227 align="center" bgcolor="#666666"><span class="style8">Contents</span></td>
</tr>


<tr>
  <td height="12" align="center" bgcolor="#FFFFFF"><span class="style1"><?php echo $row['issue_no']; ?></span></td>
  <td align="center" bgcolor="#FFFFFF"><span class="style1"><?php echo $row['issue_date']; ?></span></td>
  <td width="300" rowspan="2" bgcolor="#FFFFFF"><span class="style1"><?php echo $row['focus']; ?></span></td>
  <td width="300" rowspan="2" bgcolor="#FFFFFF"><span class="style1"><?php echo $row['toc']; ?></span></td>
</tr>
<tr>
  <td height="15">&nbsp;</td>
  <td>&nbsp;</td>
</tr>


<tr>
  <td height="18" colspan="6"></td>
</tr>
<tr>
  <td height="12" colspan="6" valign="top"><table width="845" border="0">
    <tr>
      <td width="531" height="22" align="center" bgcolor="#666666"><span class="style7"><strong>Article</strong></span><span class="style1"></span></td>
      <td width="164">&nbsp;</td>
    </tr>
    <tr>
      <td width="500" rowspan="4" bgcolor="#FFFFFF"><? echo $row['article']; ?></td>
      <td align="center"><span class="style13"><a href="pro_blog_edit.php?article_id=<?php echo $row['article_id']; ?>">Edit Record</a></span></td>
      </tr>
    <tr>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align="center"><span class="style13"><a href="pro_blog_confirm_delete.php?article_id=<?php echo $row['article_id']; ?>">Delete Record</a></span></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
    </tr>
  </table></td>
</tr>
<tr>
  <td height="12" colspan="6">&nbsp;</td>
</tr>
<tr>
  <td height="12" colspan="6">&nbsp;</td>
</tr>
<tr>
  <td height="12" colspan="6">&nbsp;</td>
</tr>
<tr>
  <td height="12" colspan="6">&nbsp;</td>
</tr>
<tr>
  <td height="12" colspan="6">&nbsp;</td>
</tr>
<tr>
  <td height="12" colspan="6" valign="top"><?php } ?></td>
</tr>
</table>
</div>
</body>

</html>

Kudose

Just a thought ...

Maybe you should get all of the data into a massive array or object and then use some loops to show the data.

Can you show me an example of how you want the data displayed?

doctortim

Well then save what I the code I gave you and run it in a browser, then you will see what I want it to look like.

Thanks