Johnster

Mark – You’re right. Slash is not the problem. I found the problem!!! The reason I was not able to run my custom query page was the “s” query string parameter. Just to expand so other people can understand.

http://www.sitename.com/search/?s=search+phrase doesn’t work but try renaming your query string “s” = “somethingelse” (i.e sitename.com/search/?phrase=search+phrase) works beautifully. I’m not sure whether its due to the wordpress or my customised theme. I was just trying various things to get this working and just renaming the search text field name in search form made it work.

Thanks your patience Mark and if it wasn’t for your point on 404 behaviour, i wouldn’t have harded coded my custom query to isolate parts and eventually got where I’m now!

Thanks Mark. But it doesn’t work.

Even if i try directly put this URL in the browser address, wordpress still redirects me to the above slashed version.

for example: wwww.mysite.com/dc – works fine.
if use http://www.mysite.com/dc?s=search+phrase it redirects to http://www.mysite.com/dc/?s-search+phrase which results in 404! May be i’ve change something else in the wordpress url rewrite class for search functionality?

Any idea?

Many Thanks,
S

thanks David. But my query is complex than that. Let me explain:

I’m modifying the search form, so users can submit a post code along with their search phrase. And i need to display all the posts matching to the phrase ordered by distance. I.e All the posts currently has post code and its geo-coordinates (longitude / latitude)- custom fields. My simplified raw query will look like this:

“SELECT p . * , d.Distance FROM wp_posts p INNER JOIN ( SELECT pm_lat.post_id, “
. “ROUND((((ACOS( SIN( ( 61.4124777 * PI( ) /180 ) ) * SIN((pm_lat.meta_value * PI( ) /180 ) ) + “
. “COS( ( 61.4124777 * PI( ) /180 )) * COS((pm_lat.meta_value * PI( ) /180 ) ) “
. “* COS( ( (- 0.0802669 – pm_lng.meta_value) * PI( ) /180 )))) *180 / PI( )) *60 * 1.1515)) AS distance FROM “
. “wp_postmeta pm_lat INNER JOIN wp_postmeta pm_lng ON pm_lat.post_id = pm_lng.post_id AND “
. “pm_lng.meta_key = ‘lng’ WHERE pm_lat.meta_key = ‘lat’) d “
. “ON p.ID = d.post_id WHERE d.Distance <10000 and post_title LIKE ‘%searchphrase%’ ORDER BY d.Distance LIMIT 0 , 1000 ” ;

So its not the matter of adding filters and modifying the query by Join or providing custom where clause. Its the entire query. So i wrote a custom search results page with custom query and that works – problem solved but I can’t get my search form to submit to this custom page – different problem :).

My original search form tag “<form action=”<?php bloginfo(‘url’); ?>” method=”get” id=”searchform” class=”form_search”>”

My new search form tag below: Please note the “/dc” which is the custom page.
<form action=”<?php bloginfo(‘url’); ?>/dc” method=”get” id=”searchform” class=”form_search”>

but above strangely submits to http://www.sitename/dc/?querystrings instead of wwww.sitename/dc?querystrings. Note the “/” slash!

I hope this gives a rough idea of my problem?

Thanks,
S