Is there a way to use count a recordset in php.
I realize ASP has a seperate object which is called recorset and then you
can run thruogh all the records before it reaches the end
I have successfully done this with while looping through the record. Is
there a way to say that the next page should contain the next row in a
recordset.
if i loop through the table and currently am at position 2. Is there a way
to set the pointer to 1 more and automatically subdiving the webpages so
that page 1 = row 2 and the next row should be page 2. (i hope you
understand me)
lars E
Sir, in PHP, the results of a query are stored in a resource which your code refers to with an integer. This resource is very much like a recordset, e.g you can do something similar to the VB code
Do Until rst.EOF
...
Loop
by using code that refers to the resource's integer inside a while loop. Exactly which functions are used depends on which database you are calling. With ODBC, I think the resource is created with
$int_variabel = odbc_exec($tilknytning_id, $sql_streng)
The functions intended for your database will run a lot faster than the ODBC functions. Check the documentation at php.net for the functions that work with your database.
If you post to the php-db list, you'll get help from people who know a lot more about using PHP with databases than I do.
Lykke til,
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak