Adding numbered rows/serial numbers to database query result set

Question

Hello i'm having problems adding numbered rows/serial numbers to my database query result. I've used $number to collect the actual number of rows. Then another problem i'm trying to avoid is: Numbering of Column Headers.

Thanks for the help.

<?php
$number = mysql_num_rows($query);

for ($serial = 0; $serial < $number; $serial++)
{
    echo "<tr>". $serial ."</tr>";
}

for ($i = 0; $i < $number_cols; $i++)
{  
    echo "<th>" . mysql_field_name($query, $i) . "</th>\n";
}

while ($row = mysql_fetch_row($query))
{    
    echo "<tr align=center>\n";
    for ($i = 0; $i < $number_cols; $i++)
    {   
        echo "<td>";
        if (!isset($row[$i])) 
        {
            echo "NULL";
        }
        else
        {
            echo $row[$i];
        } 
        echo "</td>\n";
    }
    echo "</tr>\n";
}
echo "</table>"; 
echo "</span>";
echo "</div>";
?>

you are trying to avoid numbering of Column Headers? Do not number them. — Your Common Sense
– Your Common Sense, Commented Mar 3, 2012 at 6:30
@col. Shrapnel I'm not trying to number the Column Headers. It's part of the problem i'm facing. How do you advice i go about adding serial numbers to the dataset? — user1183307
– user1183307, Commented Mar 3, 2012 at 6:40
next time please post your WORKING code and ask a question "how to add some feature to it". Not the code you come to dead end with — Your Common Sense
– Your Common Sense, Commented Mar 3, 2012 at 6:48

Your Common Sense · Accepted Answer · 2012-03-03 06:46:40Z

3

trying my best to get something sane out of your terrific code.

<?php
$serial = 1;
while ($row = mysql_fetch_row($query))
{    
  echo "<tr align=center>\n";
  echo "<td>";
  echo $serial++;
  echo "</td>\n";
  foreach ($row as $value)
  {   
    echo "<td>$value</td>\n";
  }
  echo "</tr>\n";
}

answered Mar 3, 2012 at 6:46

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

2 Comments

user1183307 Over a year ago

Thanks, the code added a column (from the left) to the table with "1++" in each of the rows, also it shifted the column header to the left, thereby leaving leaving a column (extreme right) without any header. Thanks

Your Common Sense Over a year ago

I HOPE you can fix such a "problem"

Collectives™ on Stack Overflow

Adding numbered rows/serial numbers to database query result set

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related