[RESOLVED] result movenext and table formatting...

jwmessiah

hey guys,

now this one's gotta be easy, i just can't figure it out off the top of my head! i've got a result set with 6 records which i'm trying to lay into a 2x3 table. now i'd have thought it'd be as easy as starting a loop, displaying the first record, then moving to the next record, displaying that, then continuing the loop.

when i try that however i just get every other record displayed in both sides of the table. here's my code if you could possibly tell me where it is i'm going wrong!

<? while($row = mysql_fetch_array($result))
			{ 
			?>
            <tr>
            <td width="550"><? echo $row['c_field1']; ?> - <i><? echo $row['c_field2']; ?></i></td>
            <? mysql_fetch_row($result); ?>
            <td width="550"><? echo $row['c_field1']; ?> - <? echo $row['c_field2']; ?></td>
            </tr>

        <tr>
        <td colspan="2"><hr /></td></tr>
		<? } ?>

many thanks in advance

bradgrafelman

With this code:

<? mysql_fetch_row($result); ?>

You fetch the next row but never do anything with it (such as overwrite the previous row's contents in $row).

Also note that you haven't done any error checking to see if there even is a next row at that point.

EDIT: Also note that the '<?' (and '<?=') PHP short tags have been deprecated for some time now and have been removed from future versions of PHP. For best portability of your code, you should ensure that all of your scripts use the full '<?php' opening tags.

Saviola

jwmessiah;10955995 wrote:
hey guys,

now this one's gotta be easy, i just can't figure it out off the top of my head! i've got a result set with 6 records which i'm trying to lay into a 2x3 table. now i'd have thought it'd be as easy as starting a loop, displaying the first record, then moving to the next record, displaying that, then continuing the loop.

when i try that however i just get every other record displayed in both sides of the table. here's my code if you could possibly tell me where it is i'm going wrong!
<? while($row = mysql_fetch_array($result))
			{ 
			?>
            <tr>
            <td width="550"><? echo $row['c_field1']; ?> - <i><? echo $row['c_field2']; ?></i></td>
            <? mysql_fetch_row($result); ?>
            <td width="550"><? echo $row['c_field1']; ?> - <? echo $row['c_field2']; ?></td>
            </tr>

        <tr>
        <td colspan="2"><hr /></td></tr>
		<? } ?>
many thanks in advance

P

Why you do this :

........
<td width="550"><? echo $row['c_field1']; ?> - <i><? echo $row['c_field2']; ?></i></td>
            <? mysql_fetch_row($result); ?>
            <td width="550"><? echo $row['c_field1']; ?> - <? echo $row['c_field2']; ?></td> 
............

Do you know what exactly happening. With mysql_fetch_row($result); you just move the loop pointer to next row but isn't using it, then on the next loop you move the pointer again and just miss one row. On this way you fetch and work with 1,3,5 ... result rows.

...now i'd have thought it'd be as easy as starting a loop, displaying the first record, then moving to the next record, displaying that, then continuing the loop....

try this :


<?php
while($row = mysql_fetch_array($result)) {
?>
  <tr>
    <td width="550"><?php echo $row['c_field1']; ?> - <i><?php echo $row['c_field2']; ?></i></td>
    <?php if ( $row = mysql_fetch_array($result)) {; ?>
            <td width="550"><?php echo $row['c_field1']; ?> - <?php echo $row['c_field2']; ?></td>
    <?php }?>
  </tr>
  <tr>
    <td colspan="2"><hr /></td>
  </tr>
<?php }?>

jwmessiah

sorry for the late reply guys, i've figured it out a different way, well, kinda. i've just got the items going into an unordered list, then i've used CSS to make sure that only three items will fit in the container and it cascades perfectly. almost. ha ha, off to make another thread to figure out why the css is giving me issues...

ta!