Adding a filter button

Hi,
use custom event (Insert PHP code snippet on the Visual Editor tab) to add button.

Here is a sample:

$str = "<imput type=button class=button value=NewButton onclick=\"windiw.location.href='your url here'\">";

Replace url with your acxtual URL. To construct correct URL use Advanced search:

http://www.asprunner.com/forums/index.php?showtopic=5704
To select values from view page use this code:

global $conn;

I have edited the view page and added button as per your code. The only problem is it shows all the records, instead on only being based on two values from the current record being displayed. In the insert below I'm trying to get it to display using data from the current 'iFamily' field, ideally I would like it to display from the 'Piece' field as well. At the moment its just showing me all the records. It appears to be doing a blank search showing all records and not getting to the second part. Am I missing something obvious?

$str = "<input type=button class=button value='View Household' onclick=\"window.location.href='http://localhost/Yorkshire%20Indexers/census_1841_list.php?a=advsearch&type=and&asearchfield%5B%5D=Surname&asearchopt_Surname=Contains&value_Surname=&value1_Surname=&asearchfield%5B%5D=Forenames&asearchopt_Forenames=Contains&value_Forenames=&value1_Forenames=&asearchfield%5B%5D=Age&asearchopt_Age=Contains&value_Age=&value1_Age=&asearchfield%5B%5D=Born&asearchopt_Born=Contains&value_Born=&value1_Born=&asearchfield%5B%5D=Piece&asearchopt_Piece=Contains&value_Piece=&value1_Piece=&asearchfield%5B%5D=ED&asearchopt_ED=Contains&value_ED=&value1_ED=&asearchfield%5B%5D=Folio&asearchopt_Folio=Contains&value_Folio=&value1_Folio=&asearchfield%5B%5D=Page&asearchopt_Page=Contains&value_Page=&value1_Page=&asearchfield%5B%5D=Schedule&asearchopt_Schedule=Equals&value_Schedule=&value1_Schedule=&asearchfield%5B%5D=Street&asearchopt_Street=Contains&value_Street=&value1_Street=&asearchfield%5B%5D=Place&asearchopt_Place=Contains&value_Place=&value1_Place=&asearchfield%5B%5D=iFamily&asearchopt_iFamily=Contains&value_iFamily=&value1_iFamily='\">";;

Thanks for your assistance so far, this is all very new to me.
Regards

I'm not a PHP coder, but looking at you code further I presume the idea is to requery the table again using the primary key to retrive one record then use the results to get the variables that can be embedded into the URL?
With that in mind I altered my code to the following...

This returns an error as soon as you enter the view.
Technical information Error type 2 Error description Missing argument 2 for db_query(), called in C:\PHPRunnerProjects\Yorkshire Indexers\output\include\census_1841_events.php on line 44 and defined URL localhost/Yorkshire Indexers/census_1841_view.php?editid1=2 Error file C:\PHPRunnerProjects\Yorkshire Indexers\output\include\dbconnection.php Error line 22 SQL query SELECT `Ref`, Schedule, Forenames, Surname, Age, Page, Folio, Piece, ED, Place, Street, iFamily, iPageCount, Notes, Born FROM `census 1841` where `Ref`=2
Any ideas?

Sorry for my fault.

Here is teh correct code:

global $conn;

Thanks for the update. Still had a problem viewing the records I wanted, but once I turned AJAX off it work perfectly!. I think its due to the volume of data, but this is an excellent program.
With a few tweaks I should be able to have a site up and running. This would not have been possible without your kind help and program.
Regards

I've been playing with the code on another database again dealing with Family History.
This time, I only wanted the button to appear if there was a 'Grave' reference. Also, I wanted to put a count on the button of how many people had the same reference. Due to all the help I've received regarding this, I wanted to feed something back into the system. Hope someone finds it useful.
There is probably an easier way, but it works!

Also, I didn't include the full URL generated by the Advanced Search button, I only included the parts that related to the data being searched. This has cut the length of the string down.