how to number mysql results

[MDanz]

how do i add numbering to mysql results?

 

e.g.

 

1. result

2. result

3. result

[vividona]

$i = 1;

while($row = mysql_fetch_array($q){

echo $i++;
}

 

It will count when fetch your records;

[MDanz]

what is $q... the query?

[MDanz]

i get this error

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

[vividona]

i get this error

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

 

Sorry

 

I forget something

$i = 1;

while($row = mysql_fetch_array($q)){

echo $i++;

}

 

[Redlightpacket]

Try this, this way works for me

 

$query = "SELECT * FROM  Cards";

$result = mysql_query($query)
or die("Query failed: " . mysql_error());


while ($row = mysql_fetch_assoc($result))
{


//Prints the id numbers in the table. The id numbers go from 1 and forever
//You will need to set a primary key and it will be the primary id number in your mysql table

echo $row['id'];
//Prints row numbers
}