Skip to main content
E
Eiolon
Known Participant
June 13, 2006
Question

Querying data

  • June 13, 2006
  • 1 reply
  • 275 views
I am using Dreamweaver 8 with PHP/MySQL.

When you create a new recordset in Dreamweaver, you are able to select the columns you want to have queried. What I want to do is query a particular value instead.

So I have a column called "Status" with the different values "Open, Approved, Denied, Processed". I'd like to make a page to query the column status but only show items with the value "Approved". Is this possible in Dreamweaver?
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
June 13, 2006
Use the filter option on the recordset.

"Eiolon" <webforumsuser@macromedia.com> wrote in message
news:e6n32r$608$1@forums.macromedia.com...
>I am using Dreamweaver 8 with PHP/MySQL.
>
> When you create a new recordset in Dreamweaver, you are able to select the
> columns you want to have queried. What I want to do is query a particular
> value instead.
>
> So I have a column called "Status" with the different values "Open,
> Approved,
> Denied, Processed". I'd like to make a page to query the column status
> but
> only show items with the value "Approved". Is this possible in
> Dreamweaver?
>


E
EiolonAuthor
Known Participant
June 13, 2006
Doh! I can't believe I overlooked that. I interpreted that as showing everything under the status column, not a specific value.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices