Display mysql rows in html table

Question

So here is what I did so far: http://d.pr/i/c6z

Code:

<tbody>
<?php while ($row = mysql_fetch_assoc($result)): ?>
    <tr>
        <td><?php echo $row['id']; ?></td>
        <?php foreach ($row as $key): ?>
        <td><a href="#"><?php echo $key; ?></a></td>
        <?php endforeach; ?>
    </tr>
<?php endwhile; ?>
</tbody>

and my mysql table looks like that: id (PRIMARY KEY), fullname, username. As you can see, what i'm trying to do is to display all of these records in html table, but what I don't want is href link in first column, just a numbers. SSo, how to remove in foreach loop the first value from the array which is 'id' or maybe there is a better way to do this thing?

If you don't want to display a link in the first column, why have you wrapped it in an <a> tag? — andrewsi
– andrewsi, Commented Jul 2, 2013 at 13:23

Bastien D · Accepted Answer · 2013-07-02 13:27:24Z

1

try this :

<tbody>
<?php while ($row = mysql_fetch_assoc($result)): ?>
    <tr>
        <?php foreach ($row as $key): ?>
            <?php if($key === 'id'): ?>
               <td><?php echo $row['id']; ?></td>
            <?php else: ?>
               <td><a href="#"><?php echo $key; ?></a></td>
            <?php endif; ?>
        <?php endforeach; ?>
    </tr>
<?php endwhile; ?>
</tbody>

Two different views so you have two conditions. It is easier to read for a view.

answered Jul 2, 2013 at 13:27

Bastien D

1,4752 gold badges15 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jon · Accepted Answer · 2013-07-02 13:24:31Z

1

<tbody>
<?php while ($row = mysql_fetch_assoc($result)): ?>
    <tr>
        <td><?php echo $row['id']; unset($row['id']); ?></td>
        <?php foreach ($row as $key): ?>
        <td><a href="#"><?php echo $key; ?></a></td>
        <?php endforeach; ?>
    </tr>
<?php endwhile; ?>
</tbody>

answered Jul 2, 2013 at 13:24

Jon

13.1k4 gold badges34 silver badges44 bronze badges

Comments

Aleks G · Accepted Answer · 2013-07-02 13:25:49Z

1

Without commenting on the efficiency or otherwise of your code, you can always use unset to unset a specific element of your array, for example,

unset($row['id']);

will unset the element of $row array with key id - effectively removing that element from the array.

answered Jul 2, 2013 at 13:25

Aleks G

57.5k34 gold badges178 silver badges280 bronze badges

Collectives™ on Stack Overflow

Display mysql rows in html table

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related