Re: [PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-28 Thread TorrentUK
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 PROTECTE

Re: [PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-27 Thread Richard Chauvaux
first, the select tag in your form should be setup as an array: 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]

[PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-27 Thread TorrentUK
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