Re: Probably a dumb question but I'm new to PEAR.

Now we are getting somewhere ! thanks for the help ! I'd already tried removing the ; from the query but that didn't help... but the point about the space between ) and { got me thinking... I changed $demoResult = $db->query($sql); to: $demoResult=$db->query($sql); // REMOVING THE SPACES which solved the problem. I guess I'm a newbie at PHP too.. BUT now when I test for an error after the I get one bugger... the error returned is : DB Error: unknown error very useful.. I shall keep playing Regards, Malcolm Turnbull Group IT Manager - Crocus.co.uk Ltd & Waterers Landscape PLC 01344 629661 07715 770523 www.crocus.co.uk - For all your Garden Needs www.stealthinventory.com - The Open Source Software Audit Tool ----- Original Message ----- From: "Jan Lehnardt" <jan@php.net> To: "Morgan Christiansson" <mog@linux.nu> Cc: <malcolm.turnbull@crocus.co.uk>; <pear-general@lists.php.net> Sent: Wednesday, March 20, 2002 4:18 PM Subject: Re: [PEAR] Probably a dumb question but I'm new to PEAR. > Hi, > On 20 Mar 2002 17:13:04 +0100 > Morgan Christiansson <mog@linux.nu> wrote: > > > The problem is obvious. =) > > > > Just remove ; from the SQL query. A ; is only used in SQL clients to > > separate queries, API's only permit one query per function call > (unless > > they have made their own support for ; as most clients have). > > this wouldn't cause a parse error in PHP but an error from MySQL. > > Jan > -- > Q: Thank Jan? A: http://geschenke.an.dasmoped.net/ >