Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7FCA66340AA for ; Wed, 22 Jul 2009 17:13:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 28504-02-7 for ; Wed, 22 Jul 2009 17:12:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mail.postgresql.org (Postfix) with ESMTP id 7429D635483 for ; Wed, 22 Jul 2009 16:57:54 -0300 (ADT) Received: from vanquish.ws.pitbpa0.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTPSA id 334C9EBC0A; Wed, 22 Jul 2009 15:57:53 -0400 (EDT) Date: Wed, 22 Jul 2009 15:56:15 -0400 From: Bill Moran To: Carol Walter Cc: pgsql-php@postgresql.org Subject: Re: pg_query_params Message-Id: <20090722155615.ade61dd4.wmoran@potentialtech.com> In-Reply-To: <07E5D103-2E8F-48EE-868E-8DAD10BE0C80@indiana.edu> References: <889FC92A-B6F2-4276-BFD7-E0061ACC73B6@indiana.edu> <20090722152938.402f6228.wmoran@potentialtech.com> <07E5D103-2E8F-48EE-868E-8DAD10BE0C80@indiana.edu> X-Mailer: Sylpheed 2.6.0 (GTK+ 2.14.7; i386-portbld-freebsd7.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.458 tagged_above=-10 required=5 tests=AWL=-0.458 X-Spam-Level: X-Archive-Number: 200907/8 X-Sequence-Number: 4038 In response to Carol Walter : > > On Jul 22, 2009, at 3:29 PM, Bill Moran wrote: > > > In response to Carol Walter : > > > >> Does pg_query_params return a false if an item is not found in a > >> database? > > > > What's an item? That term is does not describe any type of standard > > database object. > > > > pg_query_params() will return false if the query was invalid for any > > reason. One such possible reason is that you tried to access a > > table that doesn't exist. > > > > If you're getting false as the return value, you should use > > pg_last_error() to discover the details of the error. > No, I mean if I select select a name from the database but the name > isn't found. I'm doing a log in form. I want to check to see if the > user that's logging in exists in my database. I can check the number > of rows returned or something like that, but I wondered if the > function returns a false. Please don't top-post. I assume that (for some reason) you're avoiding using the term "table" and that you're running a select query against a table and finding that a particular row is or is no in that table? If that's correct, you should work on communicating more clearly. Also, if that is correct, I already answered your question: "pg_query_params() will return false if the query was invalid for any reason." Meaning, "no, it won't return false if a matching row isn't found, because the query was still valid." -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/