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

Kirk, First, I'd recommend troubleshooting this function by doing the following: > [code snippet] > function getEditData($email,$zipcode) { > $sql = "SELECT * FROM contact_info WHERE zipcode='$zipcode' AND > email=\"{$email}\""; echo $sql; //ADD THIS LINE > // $query = mysql_query($sql); > // if (mysql_affected_rows()=="0") { > // $this->sendResult("Fail","We do not have the given > //email and zipcode > //on file. Please go to the menu and start again."); > } > [end snippet] It SHOULD, repeat, SHOULD, depending on how you have your function implemented, just spit out the query string in the browser window for you. From there you can determine if the proper query string is being sent by the function. My guess would be that you need to add periods (concatenate) around the $email variable in the query string, but I'm not certain because I'm unfamiliar with how the curly braces are used in your code. $sql = "SELECT * FROM contact_info WHERE zipcode='$zipcode' AND email=\".{$email}.\""; Hope this helps. > -----Original Message----- > From: Kirk Babb [mailto:kbbabb@ualr.edu] > Sent: Wednesday, October 15, 2003 2:38 PM > To: php-db@lists.php.net > Subject: [PHP-DB] problem - query inside a function > > > 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}\""; > $query = mysql_query($sql); > if (mysql_affected_rows()=="0") { > $this->sendResult("Fail","We do not have the given > email and zipcode > on file. Please go to the menu and start again."); > } > [end snippet] > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >