power search?

[inspireme]

How do I filter results, in power_search.php I added the following :

$query .= " WHERE '$d_arriving' > $d_open AND '$d_arriving' < $d_closed " ;

where: d_arriving = 1-02
and d_open is 1-01 and d_closed is 1-12

it shows up no results, i remove the line and it lists everything... therfore it seems to add the WHERE to the query, so I think I need to do something to get hte variables $d_open $d_closed from the database? how do i make reference to these variables?

[dody]

You should add that line in correct order, please post your code.
Try to remove "WHERE" and repleace it with AND

$query .= " AND '$d_arriving' > $d_open AND '$d_arriving' < $d_closed " ;

Still it depend on your position where you insert the code.

[inspireme]

Hey Dody, nice meeting you

the code in context

  // filter unhide
  $i=0;
  while($i<count($c)) { 
    $query .= " and category_id != $c[$i]";
    $i++;
  }  
  

  // filter member only
  if(!$users_obj->GetUserAuthentication()==0) {

    $i=0;
    while($i<count($c2)) { 
      $query .= " and category_id != $c2[$i]";
      $i++;
    }  
  }  
  // filter by date
 $query .= " WHERE '01-01'  > $d_open  AND '01-02' < $d_closed " ;

I hard coded the date while i was testing it... is the position correct? its where all all the other ammendments to the query happened so i shoved it in

[dody]

the problem is that you add WHERE statement, the above your code, indexu already include WHERE, so the query become incorrect if you add WHERE again.
Please try to replace WHERE with AND as I mention before.

$query .= " AND '01-01' > $d_open AND '01-02' < $d_closed " ;

I do not know what is the field type (mysql) of d_open and d_close, if they're date then you need to compare as date format yyyymmdd.

[inspireme]

the problem is that you add WHERE statement, the above your code, indexu already include WHERE, so the query become incorrect if you add WHERE again.
Please try to replace WHERE with AND as I mention before.

$query .= " AND '01-01' > $d_open AND '01-02' < $d_closed " ;

I do not know what is the field type (mysql) of d_open and d_close, if they're date then you need to compare as date format yyyymmdd.

the type is varchar(5) I tried AND, this does not work. I added the variables to the reuslts page but they dont show up, so i thought that maybe the problem.
I will play around with it a bit more and see if I can get it working, I didnt notice that it was WHERE above as well.

[dody]

since it's a date, you can't compare it with string.
You need to convert the field to date type and compare with the input from web form.

[inspireme]

okay, well i think the problem is that i cant compare the values like i am

1-12 < 1-13 it does not know how to compare like this. I did it this way as zubby said it was the best way for me (i did not need the year) now I have no idea what to do ...

[inspireme]

hey 2 minutes quicker than me

I dont actually need the year information, If i used the year it would need to be always the current year and i didnt think this would be possible without making everybody update the listigns each year ( thats never going to happen!) If i change to date field, then how will I make the year always current?

anybody got a clever suggestion for this little problem

[dody]

Email back zubby at zubby@nicecoder.com to discuss this problem

[inspireme]

Zubby for president!

Works now: http://www.bigfreeguide.com/camping/...arch.php?cat=1
Choosing a date after 01/10 removes my example listing.

thanks for helping

[dody]

great.

[Frank71]

May be you should do my next site !!!!

Frank

[inspireme]

May be you should do my next site !!!!

Frank

Well Im happy to help anybody, if somebody sees something they dont know how to do that i have done on my site, then just PM me. Frank, if you want me to do the thumbnail changes on your new site then I said i would do it . no charge.

The powersearch has a little bug in it (i have the fields stored DD-MM) so it thinks days are more important than months at the moment. I can fix that though.

[dody]

??

[Frank71]

Hm, my problem is the time to setup the new site
Still searching someone for the complete job (install and template changing)
The flag mod is also nice and I like your checkboxes !

Do you have a good idea for a travel design ?

Frank