[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

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

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

[PHP-DB] What's wrong with my function? :(

2001-10-30 Thread TorrentUK
Please could some take a look at this code and tell me why when I take my IF statements out of the function and put in them in the same place where I call the function from they work, but as soon as I replace them with the function name they don't? Appreciate any help. torrent Here's the code...

Re: [PHP-DB] What's wrong with my function? :(

2001-10-30 Thread TorrentUK
Yep, that'll be it. Thanks for the help. :) torrent "Charles F. McKnight" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > On Tue, 30 Oct 2001, TorrentUK wrote: > > > > you either need to pass the variable

[PHP-DB] Problem with include()

2001-11-13 Thread TorrentUK
Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: If I call poll.php?id=KnChooseBoots from the browser i

[PHP-DB] Re: Pass var from JavaScript to PHP

2001-11-13 Thread TorrentUK
err...what javascript the form is HTML? Try... Then in your page have a php tag that checks for the presence of $Find (in your case), e.g. if ($Find) { sql = (SELECT * FROM table WHERE $criteria = "value"); then the rest... } -torrent "George Lioumis" <[EMAIL PROTECTED]> wrote in message

Re: [PHP-DB] Problem with include()

2001-11-13 Thread TorrentUK
in the path. OK on a webpage, but > not directly into the filesystem? > > Peter > > > -Original Message- > > From: TorrentUK [mailto:[EMAIL PROTECTED]] > > Sent: 13 November 2001 12:47 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Problem with include()

Re: [PHP-DB] Problem with include()

2001-11-13 Thread TorrentUK
he > parameter if the variable id is already set? > > Bruno. > > - Original Message - > From: "TorrentUK" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 13, 2001 11:24 AM > Subject: Re: [PHP-DB] Problem with include() > &

Re: [PHP-DB] Problem with include()

2001-11-13 Thread TorrentUK
$foo; > > $bar = $foo." working"; > > I think this example will help... > > Bruno. > > - Original Message - > From: "TorrentUK" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 13, 2001 1:16 PM > Subject: Re: [PHP-DB

[PHP-DB] Re: php/mysql error

2001-11-20 Thread torrentUK
I think you can get this error when you sql query fails. Try copy and pasting the $sql query to the mysql command line and see what response you get (it looks as though this would work though unless you haven't got a table called "test"). I guess it might be that you are not successfully logging o

[PHP-DB] Trapping and masking errors

2001-12-02 Thread TorrentUK
Hi, I have written a simple form emailer for my site. In it I check to see if the mail was sent successfully and if not I write some variables to an error log. My question is, I would also like to write any php errors to the log file, e.g. Warning: Failed to Connect in d:\WWW\htdocs/RND_ski-info-

[PHP-DB] Re: Trapping and masking errors

2001-12-03 Thread TorrentUK
e a way of preventing the php errors from appearing in the broswer window. I'll take a look at the ob_start and ob_end_clean though,thanks. -torrent "Yasuo Ohgaki" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Torrentuk wrote: > >