Skip to main content
A
Anonymous
January 10, 2008
Question

recordsets....

  • January 10, 2008
  • 14 replies
  • 2166 views
Hello. I know this may be simple to many but I am going to ask it anyways because I am stumped badly. Ok I need to be able to pull up info from a database with people and info from each county in each state, do I have to create a recordset for each county selected? Do you have to create one for each time you try to display the details page also? Is there another way to do this? Please help! Sorry if this seems stupid to some but I am trying here!

Thanks!!!!
This topic has been closed for replies.

14 replies

Show previous replies
A
Anonymous
February 13, 2008
yeah after they pay, it goes to a page (still on securepay) that says it was approved, and below it has a link that takes them to the form... which all works fine, but if they were to pick up on the address up top, they can retype it in there next time and bypass the payment.

i can put in the page or url, that the go to after the payment, which is the form. its a written out code from secure pay with my id and etc. but do i need to write this in the url or the actual form page?
N
Newsgroup_User
Inspiring
February 12, 2008
lilbodi wrote:
> i am following you but i dont know how to find out witht the secure pay. it
> just has a set up where after the payment, you set the page it goes to.

Don't you get any type of acknowledgement from the payment system that
payment has been authorized?

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
A
Anonymous
February 12, 2008
will do by telling people, i actually recommended it to a few people stuck on the same thing i was...

i am following you but i dont know how to find out witht the secure pay. it just has a set up where after the payment, you set the page it goes to. with what you wrote, is that to go on my page in dreamweaver or do i need to get that on the after payment page??
N
Newsgroup_User
Inspiring
January 10, 2008
lilbodi wrote:
> Hello. I know this may be simple to many but I am going to ask it anyways
> because I am stumped badly. Ok I need to be able to pull up info from a
> database with people and info from each county in each state, do I have to
> create a recordset for each county selected?

One recordset will do. You order the results by state and county using
an ORDER BY clause in your SQL. A simple example:

SELECT id, name, county, state
FROM myTable
ORDER BY state, county, name

> Do you have to create one for
> each time you try to display the details page also?

The details page needs just one recordset that uses a URL parameter
(usually the record's primary key) as a filter.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
N
Newsgroup_User
Inspiring
January 10, 2008
lilbodi wrote:
> ah ok makes much more sense now. when they click a state, they are sent to
> that states page. from there they can select a county to pull up the
> information, what is the best way to present the counties? drop down/menu
> list? list them on the page?

Most states are likely to have a lot of counties, so a drop-down would
probably be more sensible.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
N
Newsgroup_User
Inspiring
January 13, 2008
lilbodi wrote:
> select l_name, f_name, street, comment
> from my_table
> where county=' (this is where i need the help, how can you put this where it
> wont bring up all but just the one selected???)

Pass the name of the county to the page through a query string like this:

results.php?county=Orange

You normally do this by submitting a form using the GET method, although
you can also add it to a URL in a link.

In the Recordset dialog box, select URL parameter as the filter, and set
its value to $_GET['county'].

<shameless plug>If you're struggling with all this, you might find my
book, "The Essential Guide to Dreamweaver CS3 with CSS, Ajax, and PHP",
answer a whole pile of questions. As well as covering all the PHP server
behaviors in Dreamweaver, I have an entire chapter devoted to different
search techniques. You can find more details by following the link in my
sig.</shameless plug>

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

lilbodi wrote:
> so with the results.php?county=Orange would you place that on like this?
> select l_name, f_name, street, comment
> > from my_table
> > where county=results.php?county=orange
>
> is that how you would place it?

No. In the Recordset dialog box, select Simple mode, and set Filter to

county =
URL parameter $_GET['county']

--
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