Search

Ok after reading for a while I did make it works using the following code:

<form name="search" method="GET" action="/produits.php">
<input name="region,country,wines,producer,year,cepage,wine" type="text"/>
<select name="price_range">
<option value="" selected="selected">--- Par Prix ---</option>
<?php foreach ($price_rangeRecords as $record): ?>
<option value="<?php echo $record['num'] ?>"><?php echo $record['title'] ?></option>
<?php endforeach ?>
</select>
<input name="Recherchez" type="image" src="/images/search-btn.jpg" /> <span>OU</span> <a href="/produits.php?price_range=">>> Voir tous les vins</a>
</form>

Now I need to know how to prevent the drop down search to be affected by a previous search (make them display all the values all the time) and how to start with my results empty (and how to display all the wines when the user click the "Voir tous les vins" link.

Thanks!

Hi,

A couple of things for you to try.

First, if you want to search against the "title" field of all the tables, you need to change the name of your text field to "title" like this:
<input name="title" type="text"/>

Second, if you don't want any results to display when you first come to the page, try changing the code you use to output your wines to this:
<?php if($_REQUEST) : ?>
<?php foreach ($winesRecords as $record): ?>
<tr>
<td class="<?php if ($record['couleur'] == 'Blanc'): ?>white<?php endif; ?><?php if ($record['couleur'] == 'Rouge'): ?>red<?php endif; ?><?php if ($record['couleur'] == 'Rosee'): ?>rosee<?php endif; ?>">&nbsp;</td>
<td><?php echo $record['producer'] ?></td>
<td><?php echo $record['page_title'] ?></td>
<td><?php echo $record['country'] ?></td>
<td><?php echo $record['year'] ?></td>
<td><?php echo $record['origin'] ?></td>
<td><a href="<?php echo $record['_link'] ?>"><img src="/images/more.png" width="95" height="28" alt="Voir vin"/></a></td>
</tr>
<?php endforeach ?>
<?php endif ?>

This code should also display all the wines if a user clicks the ""Voir tous les vins" field.

The last problem is that you say you want to search against the region, country,wines,producer,year, and cepage tables, but when you output information, you only output records that come from the wines table. Are you going to change that, or do you only want to display wines?

Hope this helps.

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/