Re: [PHP] Page Numbering (To The Unsubscribe Guy)

Instruct ICC wrote: Just for grins, tell us the steps you took to unsubscribe. There is a link at the bottom of every email inviting you to unsubscribe. So I'm sure you began there. Tell us where it failed. _ Kick back and relax

RE: [PHP] Page Numbering (To The Unsubscribe Guy)

Just for grins, tell us the steps you took to unsubscribe. There is a link at the bottom of every email inviting you to unsubscribe. So I'm sure you began there. Tell us where it failed. _ Kick back and relax with hot games and co

RE: [PHP] Page Numbering

At 9:15 AM +1000 9/20/07, Andrew Wilson wrote: What do I have to do to get off this list. Murder someone? Please take me off the list as I have already tried to unsubscribe several times. Andrew: Just for my own amusement, who do you think you are talking to? Figuring out how to unsubscribe s

Re: [PHP] Page Numbering

: Thursday, September 20, 2007 4:03 AM To: Dan Shirah Cc: php-general Subject: Re: [PHP] Page Numbering Dan Shirah wrote: Whenever the query has the NOT IN included in it, I get the following error: Warning: mssql_query() [function.mssql-query<http://develop1/credit%20card%20processing/Process/

RE: [PHP] Page Numbering

4:03 AM To: Dan Shirah Cc: php-general Subject: Re: [PHP] Page Numbering Dan Shirah wrote: > Whenever the query has the NOT IN included in it, I get the following error: > > Warning: mssql_query() > [function.mssql-query<http://develop1/credit%20card%20processing/Process/fun ct

Re: [PHP] Page Numbering

Dan Shirah wrote: Whenever the query has the NOT IN included in it, I get the following error: Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'as'. (severity 15) yup, sorry, m

Re: [PHP] Page Numbering

Whenever the query has the NOT IN included in it, I get the following error: Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'as'. (severity 15) On 9/19/07, Jim Lucas <[EMAIL PROTEC

Re: [PHP] Page Numbering

Dan Shirah wrote: Hello all, I am having a problem with trying to display a set amount of records from my result. I have verified that the correct values for my variables are being passed to the query. The calculation for the records that should be displayed per page is correct. The total number

Re: [PHP] Page Numbering

2007. 09. 19, szerda keltezéssel 11.08-kor Dan Shirah ezt írta: > I have my query echoing out. Upon initial display it looks like this: > > SELECT DISTINCT * FROM ( SELECT TOP 10 Value1, Value2 FROM ( SELECT TOP 10 > Value1, Value2 FROM my_table WHERE my_table.column = 'P' ) as newtbl order > by P

Re: [PHP] Page Numbering

On Wed, 19 Sep 2007 10:48:20 -0400, "Dan Shirah" <[EMAIL PROTECTED]> wrote: > Actually, the query you mentioned will select records 11-20 because it > counts 10 records backwards starting with record 20. > > print_r($result) onyl returns "Resource id #3" and not the actual data. > > > On 9/19/07

Re: [PHP] Page Numbering

I found the easiest solution is to use the 'Pager' package in pear http://pear.php.net/package/Pager Ben On Wednesday 19 Sep 2007 15:45, T.Lensselink wrote: > On Wed, 19 Sep 2007 10:23:58 -0400, "Dan Shirah" <[EMAIL PROTECTED]> > wrote: > > Becase I am using MSSQL not MYSQL. MSSQL does not have a

Re: [PHP] Page Numbering

I have my query echoing out. Upon initial display it looks like this: SELECT DISTINCT * FROM ( SELECT TOP 10 Value1, Value2 FROM ( SELECT TOP 10 Value1, Value2 FROM my_table WHERE my_table.column = 'P' ) as newtbl order by PKEY desc ) as newtbl2 order by PKEY asc And then when I click on the link

Re: [PHP] Page Numbering

That gives me an array of the 10 records that are being displayed every single time. It's like even though the variables in my query are changing correctly from 0,10 to 10,20; the records being displayed are not updating. The URL is reflecting the changes from page 1 to 2 correctly also. On 9/1

Re: [PHP] Page Numbering

Actually, the query you mentioned will select records 11-20 because it counts 10 records backwards starting with record 20. print_r($result) onyl returns "Resource id #3" and not the actual data. On 9/19/07, T. Lensselink <[EMAIL PROTECTED]> wrote: > > On Wed, 19 Sep 2007 10:23:58 -0400, "Dan Sh

Re: [PHP] Page Numbering

On Wed, 19 Sep 2007 10:23:58 -0400, "Dan Shirah" <[EMAIL PROTECTED]> wrote: > Becase I am using MSSQL not MYSQL. MSSQL does not have anything easy to > use > like LIMIT in MYSQL. So, to achieve the same functionality you have to use > the subqueries. > > Having the largest number as the inner mos

Re: [PHP] Page Numbering

Becase I am using MSSQL not MYSQL. MSSQL does not have anything easy to use like LIMIT in MYSQL. So, to achieve the same functionality you have to use the subqueries. Having the largest number as the inner most subquery value tells the query to retrieve the records that are equal to that number m

Re: [PHP] Page Numbering

On Wed, 19 Sep 2007 10:05:40 -0400, "Dan Shirah" <[EMAIL PROTECTED]> wrote: > Hello all, > > I am having a problem with trying to display a set amount of records from > my > result. > I have verified that the correct values for my variables are being passed > to > the query. > The calculation for

[PHP] Page Numbering

Hello all, I am having a problem with trying to display a set amount of records from my result. I have verified that the correct values for my variables are being passed to the query. The calculation for the records that should be displayed per page is correct. The total number of records returned

[PHP] Page Numbering Search Results

Hi I am doing a search in the database and would like to limit the display to x numbers only. But would like to put two links next and previous. Where they click to goto next page. Say there were 28 results returned by query but i want to display 5 on first and subsequent pages. The way I do t