Skip to main content
S
Stefan_Heymans
Participant
January 7, 2008
Question

Showing records after search

  • January 7, 2008
  • 6 replies
  • 411 views
Hi everyone,
I have a site setup with MYSQL and PHP. Made a database with a few columns. Still using Dreamweaver 2004MX.
When I submit my searchpage it goes do resultpage with the known repeat region of 10 records and the navigationbar of MX2004. If I don't use any search variables, I get all my records and that is good and I can browse with the next and previous buttons between the pages. BUT if I make a recordset to filter the records and I pass a place or a name variable to search for something, I still get the results but only on the first page...when I press the "next" button the following page is empty ! Is this a bug ? The default value that Dreamweaver puts in the SQL-code
is "1" and it uses "POST"... If I change the default value in "%" then the first page is correct and the following pages show me all the records.. So I presume that it has something to do with this "default value" ?
Can anyone help me out with this ?
Thx
Stefan
This topic has been closed for replies.

6 replies

G
GEAtkins-dnA4Pf
Known Participant
January 7, 2008
David,

Thanks. Works for me as well. I also had to change a form variable to echo the search term from {Form.search} to {URL.search} by coding it as a "GET" too.

I figured that one out on my own. See, I'm trying.

Thanks again.

Glenn

S
Stefan_HeymansAuthor
Participant
January 7, 2008
Thx David. Your solution worked as foreseen ;)

grz

Stefan
G
GEAtkins-dnA4Pf
Known Participant
January 7, 2008
No apology needed. Thanks for the page references. Carry on!

Glenn
N
Newsgroup_User
Inspiring
January 7, 2008
GEAtkins wrote:
> I am having the exact same problem in DWCS3 and would love some help as well.

And what sort of help would you like? For someone to come round to your
place, and fix things for you?

If you want help, you need to say what the problem is, and what you have
done to fix it.

The basic fix was in my reply to the original question: use the GET
method in your search form.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
G
GEAtkins-dnA4Pf
Known Participant
January 7, 2008
David,

First of all a couple of qualifiers. I have only about 2 months of experience with DW. I have only about one month of experience of dynamic development. I have read both of your recent books.

Of course I would never expect anyone to come by my place and just fix it. I can't learn anything that way. But if I were going to ask someone to do that it would be you, given your level of expertise.

I must have missed the GET/POST difference in your books, an oversight of which I will rectify tonight during half-time.

Further, notwithstanding the time stamps on the forum messages, when I posted my reply mine was the only one and I could not see your response. Thanks Adobe for such screwed up forums.

Finally, I tried of couple of things, largely with techniques from your books. First I redid the existing search results page. Second I created a completely new search page, both prior to posting in this message.

So, my problem stems from several things: I am new with limited experience and I missed the GET/POST difference from your books. What page is it on? Again, when I posted your response was not there even though it's there now.

I know there are a lot of people on this forum who just repeatedly post for help without even trying on their own. I also know that you don't know for sure if I am one of them or not. For the record, I am not. I want to learn this stuff and I try to do it on my own before I post. In addition to your books I have most of the others on PHP/MySQL related to dynamic web development as well.

Come on over and I'll buy you a beer buddy! Thanks for all you do by helping folks here. Keep up the good work.

Glenn




quote:
Originally posted by: Newsgroup User
GEAtkins wrote:
> I am having the exact same problem in DWCS3 and would love some help as well.

And what sort of help would you like? For someone to come round to your
place, and fix things for you?

If you want help, you need to say what the problem is, and what you have
done to fix it.

The basic fix was in my reply to the original question: use the GET
method in your search form.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/


G
GEAtkins-dnA4Pf
Known Participant
January 7, 2008
I am having the exact same problem in DWCS3 and would love some help as well.

Glenn
N
Newsgroup_User
Inspiring
January 7, 2008
Stefan Heymans wrote:
> When I submit my searchpage it goes do resultpage with the known repeat region
> of 10 records and the navigationbar of MX2004. If I don't use any search
> variables, I get all my records and that is good and I can browse with the next
> and previous buttons between the pages. BUT if I make a recordset to filter the
> records and I pass a place or a name variable to search for something, I still
> get the results but only on the first page...when I press the "next" button the
> following page is empty ! Is this a bug ?

No, it's a mistake in the way you are creating the search form. Set the
method in the search form to GET. The search criteria used by recordset
navigation are all passed through the query string at the end of the
URL. By using POST for your search, the correct results will only ever
turn up on the first page.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices