Richard,

Many thanks for that.
I was reading about the for statement in a book earlier today and wondered
if I could implement it in some way.

Looks so simple now I've been shown how :)
Thanks again.

"Richard Chauvaux" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> first, the select tag in your form should be setup as an array: <select
> name="country[]" ... >
> then the array $country[] will be available to your script on submittal.
> a simple way to build your sql where clause would be to iterate through
> the array using a subscript variable:
> $sql = "select * from tbl where ctry='$country[0]'";
> for ($n=1; count($country) > $n; $n++) {
> $sql.= " or ctry='$country[$n]'";
> }
>
> richard
>
> TorrentUK wrote:
>
> > I am designing  a ski web site and am presently trying to put together a
> > resort database. I started the search script tonight and am quite
pleased
> > that it works. Where I am struggling is that I would like my visitors to
be
> > able to select multiple countries from the drop down list and for my
query
> > to pull back info on all those selected. When I try it it only pulls
back
> > the last one (naturally).
> >
> > Please advise on what would be the most efficient way of constructing
the
> > query. Please talk in easy speak as I am real new at this and am not a
> > developer by any stretch of the imagination.
> >
> > Many Thanks
> > Torrent
> >
> > Here is a cut down version of my code, the html form is at the bottom.
> >
> > <?php
> >
> > if ($search) {
> >
> >  $sql = "SELECT rst_name, cty_name FROM resort_tbl WHERE
> > cty_name='$country'";
> >
> >  $result = mysql_query($sql);
> >
> >  if ($row = mysql_fetch_array($result)) {
> >   echo "<center><table border=1>\n";
> >     echo "<tr><td>Name</td><td>Country</td></tr>\n";
> >
> >   do {
> >      printf("<tr><td>%s</td><td>%s</td>\n", $row["rst_name"],
> > $row["cty_name"]);
> >      } while ($myrow = mysql_fetch_array($result));
> >   echo "</table></center>\n";
> >  }
> > }
> >
> > ?>
> >
> > <form name="resort" method="post" action="<?php echo $PHP_SELF?>">
> >      <p> Select country </font><br>
> >                 <select name="Country" size="5" multiple>
> >                   <option value="Andorra">Andorra</option>
> >                   <option value="Austria">Austria</option>
> >                   <option value="Bulgaria">Bulgaria</option>
> >                   <option value="Finland">Finland</option>
> >                   <option value="France">France</option>
> >                   <option value="Italy">Italy</option>
> >                   <option value="North America">North America</option>
> >                   <option value="Norway">Norway</option>
> >                   <option value="Romania">Romania</option>
> >                   <option value="Slovenia">Slovenia</option>
> >                   <option value="Spain">Spain</option>
> >                   <option value="Sweden">Sweden</option>
> >                   <option value="Switzerland">Switzerland</option>
> >                 </select>
> >                 <br>
> >                    <input type="submit" name="search" value="Search">
> >               </p>
> >             </form>
> >
> >
> >
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to