Refilter results on same page?

[Guest]

I have a mysql db table with 3 columns

Name

Age

Sex

I inserted the data from the table onto the page with no problem (recordset and inserted dynamic table on page).

John        39      Male

Chris       22      Male

Sarah      25      Female

What i now want to do is have some buttons on the page so users can re-filter the results.  i.e. change the intial display from 'select all'  to  'select from all where sex equals female'.

Is there a option in dreamweaver to do this?.   I cant find any options under Insert>Data objects to do this.

TIA

[Rob Hecker2]

This is a SQL question. Give your query a WHERE clause, like this:

SELECT * FROM tablename WHERE SEX = 'female'

[Guest]

I understand the query.  I am asking about DW.

i.e.  as to whether dreamweaver can create the filter buttons needed i.e. perhaps a suitbale DW extension.  if not i will need to hire a php coder.