Export search results to csv?

Hi, I've set up a search form that returns results for a 'status' field containing Yes, No & Maybe values. The search results page works great. I'm just trying to get a download button to export only the status=Yes entries if that's what someone searched for. I have created an export button for all entries and that works great. I thought it would be as simple as adding some queries to the export.php URL, but that's rather noob of me. ;-)

Do I need to add something to the export.php file that recognizes the search term and only exports those rows? I'm clearly outta my league. Thanks in advance!!

You should be able to use the same search code from your results page and add it to your export page. Is your export page built with a recordset like your results?

Thanks, Ray. Export page attached.

I'll need to see a copy of the results page. Then I can probably advise on adding the search from the results into the export.

Results page attached!

Try this

Hey Ray, this is still exporting all entries. Any other thoughts?

Line 57 should have been:

setQueryBuilderSource($sqlStatement,$WADbSearch1,false);

Nailed it! So I see that you added the WADbSearch code from the search page and then included these two lines to the 'fetch data' sql statement:

setQueryBuilderSource($sqlStatement,$WADbSearch1,false);
$rows = mysql_query($sqlStatement);

So simple - thanks again, Ray!