Counting Query Problem

I have meeting minutes that need to be paged through via my website. I have
created a developer server on my local machine and when I run the PHP code
against the MySQL table that I imported from my ISP's website everything
works fine. However, when I upload the PHP pages to the ISP's server
everything connects but it doesn't page through anymore. It just sits on
the latest created page. I click the previous button and it shows it
reading but nothing happens.

So I know the code works from my local test so why does it not work when I
put it live? All this code worked prior to my ISP upgrading their MySQL and
phpMyAdmin software. Any ideas how to get everybody to talk again?

Here are some stats:

My ISP:
localhost
a.. Server version: 4.1.22-standard
b.. Protocol version: 10
c.. Server: Localhost via UNIX socket
d.. MySQL charset: UTF-8 Unicode (utf8)
e..
MySQL connection collation: utf8_unicode_ci

phpMyAdmin - 2.10.0.2
a.. MySQL client version: 4.1.22
b.. Used PHP extensions: mysql




My Developer Server:



Apache2Triad which includes Apache server, MySQL and PHP and is Windows
based.



Updates and versions for this Triad include:



fixed mod_perl 2.0.1 bug *
added apache SSL restart
optimised access.cgi to deal with huge logs
updated Apache to 2.2.0
updated OpenSSL to 0.9.8a
updated PHP to 5.1.2
updated Zend Optimizer to 2.6.2
updated Xdebug to 2.0.0 beta5
updated DBG to 2.18.5
updated SlimFTPd to 3.18
updated Xmail to 1.22
updated PostgreSQL to 8.1.2
updated pgAdmin to 1.4.1
updated phpPgAdmin to 4.0.1
updated MySQL to 5.0.18
updated MyODBC to 5.0.0
added MySQL Administrator 1.1.8
added MySQL Query Browser 1.1.20
updated PHPmyadmin to 2.7.0 pl2
updated UebiMiau to 2.7.9
updated AWStats to 6.5
security fix for CVE-2006-0144
added Apache2Triad Manager
reverted apache MaxRequestsPerChild to 0
INCLUDES filter removed issue adressed
added fix for VC80.CRT runtime libraries
updated mod_perl to 2.0.3
updated mod_ssl to 2.2.0
disabled mod_python 3.2.7 **

On 12 Sep, 06:37, "Cindy Chambers" <cchambers...@comcast.net> wrote:
> I have meeting minutes that need to be paged through via my website. I have
> created a developer server on my local machine and when I run the PHP code
> against the MySQL table that I imported from my ISP's website everything
> works fine. However, when I upload the PHP pages to the ISP's server
> everything connects but it doesn't page through anymore. It just sits on
> the latest created page. I click the previous button and it shows it
> reading but nothing happens.
>
> So I know the code works from my local test so why does it not work when I
> put it live? All this code worked prior to my ISP upgrading their MySQL and
> phpMyAdmin software. Any ideas how to get everybody to talk again?
>
> Here are some stats:
>
> My ISP:
> localhost
> a.. Server version: 4.1.22-standard
> b.. Protocol version: 10
> c.. Server: Localhost via UNIX socket
> d.. MySQL charset: UTF-8 Unicode (utf8)
> e..
> MySQL connection collation: utf8_unicode_ci
>
> phpMyAdmin - 2.10.0.2
> a.. MySQL client version: 4.1.22
> b.. Used PHP extensions: mysql
>
> My Developer Server:
>
> Apache2Triad which includes Apache server, MySQL and PHP and is Windows
> based.
>
> Updates and versions for this Triad include:
>
> fixed mod_perl 2.0.1 bug *
> added apache SSL restart
> optimised access.cgi to deal with huge logs
> updated Apache to 2.2.0
> updated OpenSSL to 0.9.8a
> updated PHP to 5.1.2
> updated Zend Optimizer to 2.6.2
> updated Xdebug to 2.0.0 beta5
> updated DBG to 2.18.5
> updated SlimFTPd to 3.18
> updated Xmail to 1.22
> updated PostgreSQL to 8.1.2
> updated pgAdmin to 1.4.1
> updated phpPgAdmin to 4.0.1
> updated MySQL to 5.0.18
> updated MyODBC to 5.0.0
> added MySQL Administrator 1.1.8
> added MySQL Query Browser 1.1.20
> updated PHPmyadmin to 2.7.0 pl2
> updated UebiMiau to 2.7.9
> updated AWStats to 6.5
> security fix for CVE-2006-0144
> added Apache2Triad Manager
> reverted apache MaxRequestsPerChild to 0
> INCLUDES filter removed issue adressed
> added fix for VC80.CRT runtime libraries
> updated mod_perl to 2.0.3
> updated mod_ssl to 2.2.0
> disabled mod_python 3.2.7 **

My crystal ball must be broken as it isn't showing me any of the code
that you used.

You say: "I click the previous button and it shows it reading"
What "shows it reading"?

On 12 Sep, 06:37, "Cindy Chambers" <cchambers...@comcast.net> wrote:
> I have meeting minutes that need to be paged through via my website. I have
> created a developer server on my local machine and when I run the PHP code
> against the MySQL table that I imported from my ISP's website everything
> works fine. However, when I upload the PHP pages to the ISP's server
> everything connects but it doesn't page through anymore. It just sits on
> the latest created page. I click the previous button and it shows it
> reading but nothing happens.
>
> So I know the code works from my local test so why does it not work when I
> put it live? All this code worked prior to my ISP upgrading their MySQL and
> phpMyAdmin software. Any ideas how to get everybody to talk again?
>
> Here are some stats:
>
> My ISP:
> localhost
> a.. Server version: 4.1.22-standard
> b.. Protocol version: 10
> c.. Server: Localhost via UNIX socket
> d.. MySQL charset: UTF-8 Unicode (utf8)
> e..
> MySQL connection collation: utf8_unicode_ci
>
> phpMyAdmin - 2.10.0.2
> a.. MySQL client version: 4.1.22
> b.. Used PHP extensions: mysql
>
> My Developer Server:
>
> Apache2Triad which includes Apache server, MySQL and PHP and is Windows
> based.
>
> Updates and versions for this Triad include:
>
> fixed mod_perl 2.0.1 bug *
> added apache SSL restart
> optimised access.cgi to deal with huge logs
> updated Apache to 2.2.0
> updated OpenSSL to 0.9.8a
> updated PHP to 5.1.2
> updated Zend Optimizer to 2.6.2
> updated Xdebug to 2.0.0 beta5
> updated DBG to 2.18.5
> updated SlimFTPd to 3.18
> updated Xmail to 1.22
> updated PostgreSQL to 8.1.2
> updated pgAdmin to 1.4.1
> updated phpPgAdmin to 4.0.1
> updated MySQL to 5.0.18
> updated MyODBC to 5.0.0
> added MySQL Administrator 1.1.8
> added MySQL Query Browser 1.1.20
> updated PHPmyadmin to 2.7.0 pl2
> updated UebiMiau to 2.7.9
> updated AWStats to 6.5
> security fix for CVE-2006-0144
> added Apache2Triad Manager
> reverted apache MaxRequestsPerChild to 0
> INCLUDES filter removed issue adressed
> added fix for VC80.CRT runtime libraries
> updated mod_perl to 2.0.3
> updated mod_ssl to 2.2.0
> disabled mod_python 3.2.7 **

Do not multi-post. Cross-post if you must but don't multi post
It wastes people's time.
http://www.blakjak.demon.co.uk/mul_crss.htm

The status line in the bottom left corner of the browser.


"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1189585581.279876.103530@r29g2000hsg.googlegr oups.com...
> On 12 Sep, 06:37, "Cindy Chambers" <cchambers...@comcast.net> wrote:
>> I have meeting minutes that need to be paged through via my website. I
>> have
>> created a developer server on my local machine and when I run the PHP
>> code
>> against the MySQL table that I imported from my ISP's website everything
>> works fine. However, when I upload the PHP pages to the ISP's server
>> everything connects but it doesn't page through anymore. It just sits on
>> the latest created page. I click the previous button and it shows it
>> reading but nothing happens.
>>
>> So I know the code works from my local test so why does it not work when
>> I
>> put it live? All this code worked prior to my ISP upgrading their MySQL
>> and
>> phpMyAdmin software. Any ideas how to get everybody to talk again?
>>
>> Here are some stats:
>>
>> My ISP:
>> localhost
>> a.. Server version: 4.1.22-standard
>> b.. Protocol version: 10
>> c.. Server: Localhost via UNIX socket
>> d.. MySQL charset: UTF-8 Unicode (utf8)
>> e..
>> MySQL connection collation: utf8_unicode_ci
>>
>> phpMyAdmin - 2.10.0.2
>> a.. MySQL client version: 4.1.22
>> b.. Used PHP extensions: mysql
>>
>> My Developer Server:
>>
>> Apache2Triad which includes Apache server, MySQL and PHP and is Windows
>> based.
>>
>> Updates and versions for this Triad include:
>>
>> fixed mod_perl 2.0.1 bug *
>> added apache SSL restart
>> optimised access.cgi to deal with huge logs
>> updated Apache to 2.2.0
>> updated OpenSSL to 0.9.8a
>> updated PHP to 5.1.2
>> updated Zend Optimizer to 2.6.2
>> updated Xdebug to 2.0.0 beta5
>> updated DBG to 2.18.5
>> updated SlimFTPd to 3.18
>> updated Xmail to 1.22
>> updated PostgreSQL to 8.1.2
>> updated pgAdmin to 1.4.1
>> updated phpPgAdmin to 4.0.1
>> updated MySQL to 5.0.18
>> updated MyODBC to 5.0.0
>> added MySQL Administrator 1.1.8
>> added MySQL Query Browser 1.1.20
>> updated PHPmyadmin to 2.7.0 pl2
>> updated UebiMiau to 2.7.9
>> updated AWStats to 6.5
>> security fix for CVE-2006-0144
>> added Apache2Triad Manager
>> reverted apache MaxRequestsPerChild to 0
>> INCLUDES filter removed issue adressed
>> added fix for VC80.CRT runtime libraries
>> updated mod_perl to 2.0.3
>> updated mod_ssl to 2.2.0
>> disabled mod_python 3.2.7 **
>
> My crystal ball must be broken as it isn't showing me any of the code
> that you used.
>
> You say: "I click the previous button and it shows it reading"
> What "shows it reading"?
>