>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

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to