MySql select and insert

From: Date: Wed, 25 Apr 2001 18:34:11 +0000
Subject: MySql select and insert
Groups: php.db 
Request: Send a blank email to php-db+get-8884@lists.php.net to get a copy of this message
Ok here is my problem. I have this database and the key is comprised of two fields, filename and path to file. When I read based on this key, I get 0 records found. When I insert the same record, it will say that the key already exists.(which id does). Why can't MySql findthe record. Also when I log into MySql and type the search in manually, it doesnot find it, then when I put a wild card at the end of the path and use "like" MySql finds the record. The File name and Path are derived from the system so it is not atyping error. Any know what is up with it Thanks John

« previous php.db (#8884) next »