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:[EMAIL PROTECTED]
> Sent: Wednesday, October 15, 2003 2:38 PM
> To: [EMAIL PROTECTED]
> 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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to