Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 fetching

Author  Topic 

alphando
Starting Member

1 Post

Posted - 2011-05-23 : 09:52:05
am working with mobile project (USING PHP,SQL),e.i if user request information with given keyword through their mobile their able to get content of a certain TABLE but only lets say ONLY TOP 2(up to now its working).The problem is i want from the same user if request again within a certain short of period to get the remaining content from the same TABLE

fd

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-23 : 10:16:22
You have a choice.
The client sends information about the previous extract so you can get the next data
The server holds information about the client session so knows what data was retrieved and can calculate what next to send.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -