Thanks Robert
-Original Message-
From: Van Andel, Robert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 27 November 2002 11:43 AM
To: Peter Houchin; php_gen
Subject: RE: [PHP] displaying record number in a cell in a table
$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++) {?
tddiv 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php