Querying data

[Eiolon]

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?

[Newsgroup_User]

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

[Eiolon]

Doh! I can't believe I overlooked that. I interpreted that as showing everything under the status column, not a specific value.