[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 is:

[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
Original Message- From: Noam Giladi [mailto:[EMAIL PROTECTED]] Sent: woensdag 19 februari 2003 16:00 To: [EMAIL PROTECTED] Subject: [PHP-DB] LIMIT problem MSSQL I'm trying to split results into different pages and number the pages accordingly. I've been able to build a fairly intellig

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Noam Giladi
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 page numbering system which knows wh

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Noam Giladi
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 manual :) -Original Message- From: Noam Giladi [mailto:[EMAIL PROTECTED]] Sent: woe