$result = mysql_query("select * from [database table]");
echo "<table>";
while($data = mysql_fetch_array($result))
{
$count++;
echo "<tr>";
echo "<td>$count</td>";
echo "<td>$data[0]</td>";
echo "<td>$data[1]</td>";
...and so on....
echo "</tr>";
}
echo "</table>";
This will give you a row number for each row.
Robbert van Andel
-----Original Message-----
From: Peter Houchin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 4:49 PM
To: php_gen
Subject: [PHP] displaying record number in a cell in a table
howdy,
I've had a look around and haven't been able to find what I'm after..
What I'm trying to do is display the number of each individual record with
in a table in a db WITH OUT relying on the records id, here what I've come
up with so far:
//get and count the number of records in the table
$result = mysql_query("SELECT count(*) AS num FROM resellers");
$num = mysql_result($result,0,"num");
//display the number of records
for ($i = 1; $i <= $num; $i++) {?>
<td><div align='center'>
<font class="content"><?//=$myrow['id']
print $i;?>
</font>
</div></td>
<?}
now this all works except that it displays 12345etc in every cell of the
html table when i need it to display as
1
2
3
4
5
etc
with each number on a new row in the html table ..
TIA & I hope i've made what am after clear enough...
Cheers
Peter
"the only dumb question is the one that wasn't asked"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
