a weired query issue

From: Date: Thu, 08 Jan 2009 08:05:12 +0000
Subject: a weired query issue
Groups: php.general 
Request: Send a blank email to php-general+get-285642@lists.php.net to get a copy of this message
i have this query.. $sql = "SELECT id FROM modules_permissions WHERE id = '" . $permissionId . "';"; when i pass the value 31 to permissionid, it returns me the 31st row of the table. and it's fine. but when i pass '31asasa' as the permissionid it returns me the same row! how come this possible? id is a integer and the storage engine is myisam. i'm on debian and mysql version is 5.0.51a-15 ~viraj

« previous php.general (#285642) next »