hi there,

im currently using some code from the website http://blog.ninedays.org/2008/03/04/...tions-library/ which writes functions for mysql queries. However I am having problems with a function in that a sql query has problems with the WHERE statement where i use a string rather than a number.

I have omitted a lot of code from this but this is function statement within the class called Query :

PHP Code:

        function Query($query,$sql) {
            $this->action = mysql_query($query,$sql);
            $this->connect = $sql;
        } 


and this is where I execute that in the page (again some code omitted) :

PHP Code:

    $selectQuery = 'SELECT * FROM `admin` WHERE `admin_password` = `freddy123`';

    $result = new Query($selectQuery,$sql); 


when executed i get the error "Error #1054: Unknown column 'gav' in 'where clause'" but if I chance the query to a number instead of a string so it reads :

PHP Code:

    $selectQuery = 'SELECT * FROM `admin` WHERE `admin_password` = 123'; 


then it executes fine without problems. However, I want to be able to use a string in my 'where' clause as needed, not a number!

Any suggestions why this is working with a number and not any other value such as a string?

Thanks

I don't see any reason for this error with what you gave us.
I've downloaded the class from the site, and looked at it, but a

PHP Code:

new Query() 


goes directly in a mysql_query(), no escaping nor replacement is done...
So, logically, it should be a problem of your query.
Or maybe the mysql table could be damaged, I don't know...

i did think that too about a problem with the tables as i can't see a problem with the query either.

i shall try looking into the table problem and even maybe try it on another database too to see what that results in.

thanks

strings HAVE to be enclosed in single quotes.

have just changed it to single quotes and it now works fine.

many thanks to every one for the help