Re: a weired query issue

At 1:35 PM +0530 1/8/09, viraj wrote:

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

As Nate said, that's normal. However, what I noticed was a query that is more complicated than it could be, try this: $sql = "SELECT id FROM modules_permissions WHERE id = '$permissionId' "; That should work, it does for me. If it doesn't, I would like to know why? Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com