[resolved] PHP echos table. How to automatically number rows?

JsteRmX · 09-03-2007, 11:23 PM

So I pulled some data from a mysql database and have it echoed into an html table. How can i make the HTML table automatically number the rows? I want the row #s to be independent from the mysql data so that i can sort by different variables.

Here is the code:

Code:

echo "<table border='0' p class ='style15' align='left'>
<tr>
<th>Student Name</th>
<th>Speech Title</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['speech'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

help is appreciated. Thank yoU!!

RegFee · 09-04-2007, 12:14 AM

PHP Code:

  echo "<table border='0' p class ='style15' align='left'>

????: NamePros.com http://www.namepros.com/programming/369966-php-echos-table-how-automatically-number.html
<tr>

<th>ID</th>

<th>Student Name</th>

<th>Speech Title</th>

</tr>";

 
//set counter variable

$counter = 1;

 
while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $counter . "</td>";

  echo "<td>" . $row['name'] . "</td>";

  echo "<td>" . $row['speech'] . "</td>";

  echo "</tr>";

  $counter++; //increment counter by 1 on every pass

  }

echo "</table>";

JsteRmX · 09-04-2007, 01:45 AM

sweet! thank you. that was simple, eh? rep+

09-03-2007, 11:23 PM	THREAD STARTER #1 (permalink)
JsteRmX NamePros Regular Join Date: Dec 2005 Posts: 208	[resolved] PHP echos table. How to automatically number rows? So I pulled some data from a mysql database and have it echoed into an html table. How can i make the HTML table automatically number the rows? I want the row #s to be independent from the mysql data so that i can sort by different variables. Here is the code: Code: echo "<table border='0' p class ='style15' align='left'> <tr> <th>Student Name</th> <th>Speech Title</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['speech'] . "</td>"; echo "</tr>"; } echo "</table>"; help is appreciated. Thank yoU!! __________________ + Domains I have for sale here Last edited by JsteRmX; 09-11-2007 at 08:59 PM.

09-04-2007, 12:14 AM	#2 (permalink)
RegFee DNOA Certified Seller Join Date: Apr 2005 Location: Arizona Posts: 3,680	PHP Code: echo "<table border='0' p class ='style15' align='left'> ????: NamePros.com http://www.namepros.com/programming/369966-php-echos-table-how-automatically-number.html <tr> <th>ID</th> <th>Student Name</th> <th>Speech Title</th> </tr>"; //set counter variable $counter = 1; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $counter . "</td>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['speech'] . "</td>"; echo "</tr>"; $counter++; //increment counter by 1 on every pass } echo "</table>"; __________________ Nombrex.com

09-04-2007, 01:45 AM	THREAD STARTER #3 (permalink)
JsteRmX NamePros Regular Join Date: Dec 2005 Posts: 208	sweet! thank you. that was simple, eh? rep+ __________________ + Domains I have for sale here

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)