Dreaweaver PHP: Problem with recordset navigation
Posted: Sun Feb 06, 2005 8:25 am
Hello, this is my last resort to try and figure out this problem.
I have a page that has been working famously for the last several months. My host updated to 'the latest stable version' of either PHP or mySQL or both. (They have been avoiding a direct answer). Anyway the current versions are PHP 4.3.10 and MySQL 4.0.22
Ever since about a week ago, the most inportant page in my site has been broken. The recordset navigations do not function and the main recordset seems to be cleared somehow when trying to move to the next page.
You can see the problem here>>
http://www.chirowebjapan.com/lang_japan ... C%E3%83%81
I've included the GET data in the URL it is utf-8 encoded as are all the pages on the site.
You will notice that the first page loads apparently fine. But, if you try to go to the next page, you don't get the other record, and the 'previous' and 'first' page indicators do not show up at all. It seems as if my recordset is getting cleared out somehow.
I've spent 4 days now trying to figure this out with zero progress. And, I am hoping that someone can clue me in as to what is happening here. I personally think that the host's updates have broken my PHP.
FYI: My PHP experience is ~~beginner to intermediate~~ I guess, I can understand what the code does in most cases and make it do what I want. But, I am at a loss to do coding work totally independent of Dreamweavers code view and snippets.
You can get the page code here if you are so kind as to take a look.
http://www.chirowebjapan.com/_code/ All three files contain the same data.
ANY help at all is monstrously appreciated as it just may preserve my sanity for the next crisis.
Thank you for your time,
Ken (SteedVLX)
I have a page that has been working famously for the last several months. My host updated to 'the latest stable version' of either PHP or mySQL or both. (They have been avoiding a direct answer). Anyway the current versions are PHP 4.3.10 and MySQL 4.0.22
Ever since about a week ago, the most inportant page in my site has been broken. The recordset navigations do not function and the main recordset seems to be cleared somehow when trying to move to the next page.
You can see the problem here>>
http://www.chirowebjapan.com/lang_japan ... C%E3%83%81
I've included the GET data in the URL it is utf-8 encoded as are all the pages on the site.
You will notice that the first page loads apparently fine. But, if you try to go to the next page, you don't get the other record, and the 'previous' and 'first' page indicators do not show up at all. It seems as if my recordset is getting cleared out somehow.
I've spent 4 days now trying to figure this out with zero progress. And, I am hoping that someone can clue me in as to what is happening here. I personally think that the host's updates have broken my PHP.
FYI: My PHP experience is ~~beginner to intermediate~~ I guess, I can understand what the code does in most cases and make it do what I want. But, I am at a loss to do coding work totally independent of Dreamweavers code view and snippets.
You can get the page code here if you are so kind as to take a look.
http://www.chirowebjapan.com/_code/ All three files contain the same data.
ANY help at all is monstrously appreciated as it just may preserve my sanity for the next crisis.
Thank you for your time,
Ken (SteedVLX)