Search/Results Page Problem

I have an Events DB, one table has the parent fields: date_1, date_2, category, event. I then have a second table for id & dates ie 3rd July 2010 till 18th July 2010. Most events have just one date, though a few have more than one. I have created a results page with the parent columns. I have also a search page to search the events based on a date from a dynamic dropdown list. I want it to search for only events on the eg. 7th July 2010 and not any other date. Currently, if I search for all events on the 7th July it also displays the other date eg 6th July because the event is on both dates and I have two table columns date_1 and date_2.

Check out link and do search on 7th July:

search.php

Any help is much appreciated.

Thanks.

If you set the search to use both columns, date_1 and date_2, this is the correct result.

you would need to configure the search to only look in one of those columns to be able to get the result you are looking for.

Jason, any idea how I would go about configuring the search to show only one? My skills are quite basic when it comes to this kinda thing.

Thanks for any help in advance.

in the data assist search wizard, for the keyword search, you have selected both the date_1 and date_2 columns.

You should edit this and select only 1 of the date columns.

Jason,

problem is, I have have about 6 columns for date_1, date_2, date_3 etc because a few of the events are on more than one date. See attachment. On one of the events the 7th July is in column date_1, whereas it may be on column date_2 on another event. But I want it to search though all the date columns but only display the event from say the 7th July and not showing the date of 6th July from 1st Column. I know this must sound confusing but I just can't think of any other method to do this and deadline is looming.

Thanks

Well, you could put an if statement around the date date display so it will only show if that column is equal to the searched date:

<?php if($row_rsResults['date_1'] == $_POST["searchForm"]) echo $row_rsResults['date_1']; ?>



<?php if($row_rsResults['date_2'] == $_POST["searchForm"]) echo $row_rsResults['date_2']; ?>

Jason,

My knowledge of PHP is practically zero. Any idea of where I would put this IF statement on the page. I attached the results page as attachment on the first post here, does it go on that page?

Thanks

yes, on the results page you sent me, you are displaying the date using:

<td><p><?php echo $row_rsResults['date_1']; ?>,<?php echo $row_rsResults['date_2']; ?></p></td>

change that to:

<td><p><?php if($row_rsResults['date_1'] == $_POST["searchForm"]) echo $row_rsResults['date_1']; ?>,<?php if($row_rsResults['date_2'] == $_POST["searchForm"]) echo $row_rsResults['date_2']; ?></p></td>

Jason,

Thank so much for that - will replace the text and see how it goes.

Jason,

That PHP code worked perfect.

Issue now is that if I don't select any item from dropdown list, it shows ALL categories ok on results page, but no dates are showing.

See link - press submit with no selection:

search.php

Results page is attached too.