Help with mysql rowpointer

From: Date: Wed, 22 Aug 2001 10:17:59 +0000
Subject: Help with mysql rowpointer
Groups: php.windows 
Request: Send a blank email to php-windows+get-8992@lists.php.net to get a copy of this message
Hey there. I realize this is a forum for php-windows users,but knowing that most of you guys run a mysql db as backend i have a question for you.. I know there is a way to return the amount of records in the db by using the mysql_num_rows($resultid). My problem is that it only returns the total number of records from my query I have seen that there is a function called mysql_data_seel(par,par), but i am not sure how it works. My problem is the following> i want to do a print out of each record in the db , but the HTML code (to be exact the positioning of the HTML table should be different depending on the number of record printed out. To illustrate this is more or less what i want > i want to print out record 1 in one style , then i want to next record to be printed out in a different way. Is there a way to do a check on which number of record is printed out. I realize i cannot use the id simply because if i do a printout of total 4 records and i want to use a record with id = 100 e.g then it won't do me any good. Basically is there a way for me to check the number of record is printed out on a page. If i want to print out 4 records then the first row should be 1..Regardless of the ID stored in the db. I hope you understand me .if now i would be happy to reply with a more detailed instruction on my problem. in ODBC db i know one can use the rs.next object and method, but is there an equivalent to this in MYSQL.. Thanks everyone Lars Eirik

« previous php.windows (#8992) next »