Login

04-13-2011, 01:51 AM

[eluser]j4zzyh4ck3r[/eluser]
How to get current row when displaying a table data ?

Code:
&lt;?php foreach ($result as $row): ?&gt;

    <tr>

        <td>1</td>

        <td>&lt;?php echo sprintf("USd", $row->user_id); ?&gt;</td>

        <td>&lt;?php echo $row->user_username; ?&gt;</td>

        <td>&lt;?php echo $row->user_password; ?&gt;</td>

    </tr>

 &lt;?php endforeach; ?&gt;

What code should I replace to '1' ? Thanks Smile

04-13-2011, 02:46 AM

[eluser]Johan André[/eluser]
Create a variable and increment it with every iteration.

04-13-2011, 03:23 AM

[eluser]j4zzyh4ck3r[/eluser]
[quote author="Johan André" date="1302702415"]Create a variable and increment it with every iteration.[/quote]

Is there any other solution other than iteration ?
I mean by using query object...

04-13-2011, 07:42 AM

[eluser]InsiteFX[/eluser]
Try this, not tested but would be something like that.

Code:
&lt;?php

$cnt = 1;

foreach ($result as $row): ?&gt;

    <tr>

        <td>&lt;?php echo $cnt;?&gt;</td>

        <td>&lt;?php echo sprintf("USd", $row->user_id); ?&gt;</td>

        <td>&lt;?php echo $row->user_username; ?&gt;</td>

        <td>&lt;?php echo $row->user_password; ?&gt;</td>

    </tr>

    &lt;?php $cnt++;?&gt;

 &lt;?php endforeach; ?&gt;

InsiteFX

04-13-2011, 07:52 AM

[eluser]j4zzyh4ck3r[/eluser]
[quote author="InsiteFX" date="1302720136"]Try this, not tested but would be something like that.

Code:
&lt;?php

$cnt = 1;

foreach ($result as $row): ?&gt;

    <tr>

        <td>&lt;?php echo $cnt;?&gt;</td>

        <td>&lt;?php echo sprintf("USd", $row->user_id); ?&gt;</td>

        <td>&lt;?php echo $row->user_username; ?&gt;</td>

        <td>&lt;?php echo $row->user_password; ?&gt;</td>

    </tr>

    &lt;?php $cnt++;?&gt;

 &lt;?php endforeach; ?&gt;

InsiteFX[/quote]

Ok... I got that, so we must use iteration, Thanks for your help Smile