Re: [PHP] a weired query issue

2009-01-08 Thread Jason Pruim
On Jan 8, 2009, at 1:37 PM, Daniel Brown wrote: On Thu, Jan 8, 2009 at 12:18, tedd wrote: Hey, if I were you I wouldn't be taking about sanity now that you have a digestive system that has a two hour sleep cycle. :-) I still have seven months or so of relative calm, if all goes well

Re: [PHP] a weired query issue

2009-01-08 Thread Daniel Brown
On Thu, Jan 8, 2009 at 12:18, tedd wrote: > > Hey, if I were you I wouldn't be taking about sanity now that you have a > digestive system that has a two hour sleep cycle. :-) I still have seven months or so of relative calm, if all goes well. There isn't a moment that goes by that I don't ho

Re: [PHP] a weired query issue

2009-01-08 Thread Andrew Ballard
On Thu, Jan 8, 2009 at 12:18 PM, tedd wrote: > At 9:17 AM -0500 1/8/09, Daniel Brown wrote: >> >> On Thu, Jan 8, 2009 at 09:10, tedd wrote: >>> >>> $sql = "SELECT id FROM modules_permissions WHERE id = '$permissionId' "; >> >>I was going to ask something about sanity, but then I remembered >

Re: [PHP] a weired query issue

2009-01-08 Thread tedd
At 9:17 AM -0500 1/8/09, Daniel Brown wrote: On Thu, Jan 8, 2009 at 09:10, tedd wrote: $sql = "SELECT id FROM modules_permissions WHERE id = '$permissionId' "; I was going to ask something about sanity, but then I remembered with whom it is I'm speaking. ;-P That aside, don't forg

Re: [PHP] a weired query issue

2009-01-08 Thread Daniel Brown
On Thu, Jan 8, 2009 at 09:10, tedd wrote: > > $sql = "SELECT id FROM modules_permissions WHERE id = '$permissionId' "; I was going to ask something about sanity, but then I remembered with whom it is I'm speaking. ;-P That aside, don't forget your pre-database-interaction sanity. Even a

Re: [PHP] a weired query issue

2009-01-08 Thread Daniel Brown
On Thu, Jan 8, 2009 at 03:05, viraj wrote: > i have this query.. > > $sql = "SELECT `id` FROM `modules_permissions` WHERE `id` = '" . > $permissionId . "';"; While you are using PHP to develop your script, this is not at all a PHP question. Please keep MySQL questions such as this to the MyS

Re: [PHP] a weired query issue

2009-01-08 Thread tedd
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 ret

[PHP] a weired query issue

2009-01-08 Thread viraj
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 poss