[PHP-DB] "LIMIT" problem MSSQL

2003-02-19 Thread Noam Giladi
I'm trying to split results into different pages and number the pages accordingly. I've been able to build a fairly intelligent page numbering system which knows which rows it should pull (at least by numbering each row numerically) but I don't know how to construct a SQL query to pull 10 results

Re: [PHP-DB] "LIMIT" problem MSSQL

2003-02-19 Thread Noam Giladi
> > $sql = "SELECT * FROM bla Limit $start, $numbers_to_show"; > > > > or just go to mysql.com and use the manual :) > > > > -Original Message- > > From: Noam Giladi [mailto:[EMAIL PROTECTED]] > > Sent: woensdag 19 februari 2003 16:00 > >

Re: [PHP-DB] "LIMIT" problem MSSQL

2003-02-19 Thread Noam Giladi
page every time they hit next, and in lastid, put the last id of the results on that page. On Wed, 2003-02-19 at 09:59, Noam Giladi wrote: I'm trying to split results into different pages and number the pages accordingly. I've been able to build a fairly intelligent pa

Re: [PHP-DB] "LIMIT" problem MSSQL

2003-02-19 Thread Noam Giladi
rk Snijders" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED] ... > $start = 10; > > $numbers_to_show = 25; > > $sql = "SELECT * FROM bla Limit $start, $numbers_to_show"; > > or just go to mysql.com and use the manua

[PHP-DB] SQL server procedore how to

2003-02-23 Thread Noam Giladi
i have a aprocedure "simple_proc" i try to call her with mssql_query like this: $q="exec simple_proc"; $ret = mssql_query($q,$__["db connection"]); the result i get