RE: [PHP-DB] problem - query inside a function

You guys might have valid points, but I think Kirk solved this problem to his satisfaction sometime yesterday. I can't speak for Kirk though. See: [PHP-DB] [CLARIFICATION on SOLUTION] Re: problem - query inside a function > -----Original Message----- > From: CPT John W. Holmes [mailto:holmes072000@charter.net] > Sent: Thursday, October 16, 2003 10:57 AM > To: lmorales@venezuelasite.net; php-db@lists.php.net > Subject: Re: [PHP-DB] problem - query inside a function > > > 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... > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >