Hi All,
I tried to ask about this before but will try and re-phrase/simplify my question
Basically I have records with 5 data fields. I want to display this data in a nice table with the first row of the table holding four cells - which is where the first four fields are outputted to. There are a few blank rows for spacing following that first row. Then a nested table of just a single cell sits in the fourth row, that holds the output of the much larger "article" field.
Basically I'm using the following code to set things up:
<?php include_once("include/connect_sql.inc.php"); ?>
<?php
$sql = 'SELECT * FROM blogprofessional ORDER BY created DESC';
$result = mysql_query($sql) or die(mysql_error());
$i=0;
$article_id = mysql_result($result,$i,"article_id");
$issue_no = mysql_result($result,$i,"issue_no");
$issue_date = mysql_result($result,$i,"issue_date");
$focus = mysql_result($result,$i,"focus");
$toc = mysql_result($result,$i,"toc");
$article = mysql_result($result,$i,"article");
?>
In order to loop another table for each article I use:
<?php while($row = mysql_fetch_assoc($result)) { ?>
...placing this part of the while loop right before the opening table tag, and placing...
<?php } ?>
...after the closing table tag.
In each cell that I want my field's data to appear I use:
<?php echo $row['issue_no']; ?>
What I see in the browser is the first four data fields outputting into their respective cells of the first row. However my single cell nested table in row 4 is not producing the result of it's echo statement. The cell just appears blank.
Why is this happening?? I hope it isn't because of the nested table, i need it for layout purposes.
