Re: problem - query inside a function
| From: | CPT John W. Holmes | Date: | Thu, 16 Oct 2003 14:57:27 +0000 |
| Subject: | Re: problem - query inside a function | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31079@lists.php.net to get a copy of this message | ||
From: "Luis M Morales C" <lmorales@venezuelasite.net>
> My Comment bellow:
>
> On Wednesday 15 October 2003 14:38, Kirk Babb wrote:
> > Hi,
> > I'm having trouble with a query inside a function. I thought I'd
written
> > this so that the function would fail if email and zipcode supplied were
not
> > in the same row (trying to use those two things to identify the user),
but
> > I don't think that is what is happening because I can enter the wrong
> > zipcode and it will return data based on the email. Any suggestions or
> > corrections? Thanks!
> > -Kirk
> >
> > [code snippet]
> > function getEditData($email,$zipcode) {
> > $sql = "SELECT * FROM contact_info WHERE zipcode='$zipcode' AND
> > email=\"{$email}\"";
>
> Change by
> $sql = "SELECT * FROM contact_info WHERE zipcode='{$zipcode}' AND
> email='{$email}'";
That's not causing the problem. Both methods are valid.
> > $query = mysql_query($sql);
> > if (mysql_affected_rows()=="0") {
mysql_affected_rows() does not apply to SELECT queries. Perhaps you're
meaning mysql_num_rows()?
> > $this->sendResult("Fail","We do not have the given email and
zipcode
> > on file. Please go to the menu and start again.");
> > }
---John Holmes...