Advanced Search Issues

Hi,
contruct URL with advanced search result and redirect to this URL.

Here is the "How to get the URL of advanced search results page" article:

http://www.asprunner.com/forums/index.php?showtopic=5704

Hi Jane,
Per the article i've changed the following:
Supplier Table | Visual Editor | advanced search page | HTML Mode
from:

<form method="POST" action="suppliers_list.php" name="editform">
to:

<form method="GET" action="suppliers_list.php" name="editform">
I'm not sure how to contruct the URL.

Here is the code that i have in the journey | Add page: After record added Event
$result = mysql_query("SELECT * FROM suppliers");

while($row = mysql_fetch_array($result))

{

if (code for town check){

header("Location: http://www.mywebsite.com/suppliers.php");

}

}
Further help & support would be greatly appreciated.
Thank you
Lisa

Hi,
just run advanced search, copy and paste the URL into your code.

Hi Jane,
I have copied the url generated after the search to the add page redirect. It works only for static entries.
I need to be able to pull the contents of journey table | begin_town field into the URL
suppliers_list.php?a=advsearch&type=and&asearchfield%5B%5D=begin_town&asearchopt_begin_town=Equals&display_value_begin_town=halesowen&value_begin_town=halesowen&display_value_begin_town=&value1_begin_town=&asearchfield%5B%5D=begin_city&asearchopt_begin_city=Equals&value_begin_city=&value1_begin_city=&asearchfield%5B%5D=finish_town&asearchopt_finish_town=Contains&value_finish_town=cannock&value1_finish_town=&asearchfield%5B%5D=finish_city&asearchopt_finish_city=Contains&value_finish_city=&value1_finish_city=
I've highlighted the presence of begin_town: halesowen in the URL to demonstrate that this is the static entry on the search page.
Again, more help and support needed.
Many thanks
Lisa

Hi Forum,
I've managed to figure it out.
Here's goes



$result = mysql_query("SELECT * FROM suppliers");

while($row = mysql_fetch_array($result))

{

if (code for town check){

$_SESSION["begin_town"] = $values["start_town"];

$_SESSION["begin_city"] = $values["start_city"];

$_SESSION["finish_town"] = $values["end_town"];

$_SESSION["finish_city"] = $values["end_city"];
header("Location:http://www.mywebsite.com/suppliers_list.php?a=advsearch&type=and&asearchfield%5B%5D=begin_town&asearchopt_begin_town=Equals&value_begin_town=."&value1_finish_town=&asearchfield%5B%5D=finish_city&asearchopt_finish_city=Contains&value_finish_city=&value1_finish_city=";);

}

}
Sorry for any confusion as the final solution now includes the existance of start & end cities.
Hope this helps anyone looking for a similar solution
Lisa

Hi Forum,
I have another question which relates to the solution to date.
Is there any way on the Advanced Search page to create an OR condition.
_Example
Data entered into Supplier Table Advanced Search:

_begin_town = solihull

begin_city = birmingham

finish_town = salford

finish_city = manchester
Lets say we have a record on the supplier table with the following criteria:
begin_town = solihull

begin_city = west midlands

finish_town = salford

finish_city = salford
I would like to show on the list page the above record details, given that the details are not identical. I've had a play with the different search types: contains, equals, etc. but cannot see a way of achieving this. Is there any way of comparing as follows:
if data entered begin_town (solihull) = preset data record begin_town (solihull)



OR
data entered begin_city (birmingham) = preset data record begin_city (west midlands)
Currently, the solution seems to work as an AND condition.
Your help would be much appreciated.
Lisa

Hi,
to use OR condition just select Any condition option on the Advanced search page.