On Sunday 18 August 2002 17:45, Jean-Marc Godart wrote:
> I have a MySQL database (called "sessions") with a auto-increment INT field
> called "sessionID". I try to check if there is already a record in this
> database with a given sessionID, which is called $sessionID in PHP. I use
> this query, which must be wrong (but I cannot find out why !!!) :
>
> SELECT * FROM sessions WHERE sessionID = $sessionID
>
> Even though there is already a record with the right sessionID, my program
> does not find it (I always get 0 when using mysql_num_rows() after the
> query). Though, if I replace "$sessionID" by, for example 4, then that
> works and it says there is already a record with that ID.
>
> I guess the problem comes from comparing two different kinds of variables,
> but I can't fix it ... Could anyone please help ? By advance, thank you !!!
Have you tried printing out $sessionID to see whether it contains what you
think it contains?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Under capitalism, man exploits man. Under communism, it's just the opposite.
-- J.K. Galbraith
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
