Multiple Column Formatting

Bannockburn

i AM RACKING MY BRAINS(TO NO AVAIL) -
MY KNOWLEDGE OF PHP IS INCONSEQUENTIAL -
I GUESS I AM WHAT COULD BE DESCRIBED AS A
NOVICE. I WOULD REALLY APPRECIATE IF ONE OF
YOU GURUS COULD POINT ME IN THE RIGHT DIRECTION
VIS-A-VIS FORMATTING A QUERY RESULT. THE SITUATION
IS;

mysqlDB Snippet

1 | 100 |"" |Bland|0.7|

-> Desired Output WOULD BE A

HTML Table(4 COLUMNS - KEY-FIELD)
SUCH AS;

Boiling Point(key)|100(value) | Taste(key)| Bland(value)|

PH(key |0.7(value) | | |

_________________________________

Coding thusfar

db query etc etc etc......
$result = mysql_query($query,$connection) or die(mysql_error());
$row=(mysql_fetch_assoc($result));
while(list($key, $value) = each($row)){
if(is_null($value)){
echo "";
}
else {
echo "$key:$value <br>";
}
}

This will result in (REMOVING THE VOLATILES ELEMENT
FROM THE DISPLAY);

Boiling Point:100.
Taste:Bland

PH:0.7

The question is how do i separate the key/values
AND DISPLAY THEM IN THE HTML TABLE DESCRIBED ABOVE?

THANKS(OPTIMISTICALLY) IN ADVANCE

Bannockburn

wilbur

Try sometehing like this:

<?php require_once('Connections/lm_dbase.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_lm_dbase, $lm_dbase);
$query_Recordset1 = "SELECT * FROM photodb";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $lm_dbase) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>

<HTML>
<HEAD>
<META HTTP-EQUIV="Refresh" CONTENT="1;
<TITLE></TITLE>
</HEAD>
<BODY>
<?php
mysql_free_result($Recordset1);
?>
<p> </p>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>id</td>
<td>title</td>
<td>notes</td>
<td>location</td>
<td>type</td>
<td>year</td>
<td>month</td>
<td>day</td>
<td>thumb_loc</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['id']; ?></td>
<td><?php echo $row_Recordset1['title']; ?></td>
<td><?php echo $row_Recordset1['notes']; ?></td>
<td><?php echo $row_Recordset1['location']; ?></td>
<td><?php echo $row_Recordset1['type']; ?></td>
<td><?php echo $row_Recordset1['year']; ?></td>
<td><?php echo $row_Recordset1['month']; ?></td>
<td><?php echo $row_Recordset1['day']; ?></td>
<td><?php echo $row_Recordset1['thumb_loc']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

Easy!

Good luck.