mysql query problem
Posted: Wed Oct 03, 2007 2:22 am
Hello all
I am having some trouble in debugging a problem. My query returns results in mysql query browser and phpmyadmin but not when it is called from php page. It does not happen all the time but only under some conditions.
For example - select * from table where 'formz-6.1' = LCASE(strip_all_unsafe_chars(`title`)) returns result at mysql query browser but not when it is called from php page.
but
select * from table where 'usb-external-3.5-mac-hard-drive-kit'=LCASE(strip_all_unsafe_chars(`title`))
returns results both at mysql query browser and from php page.
strip_all_unsafe_chars() is a stored function that i have created in mysql.
I donot know if this is a common problem but this is the first time I have encountered such problem. Any help will be highly appreciated.
Regards
Mike
I am having some trouble in debugging a problem. My query returns results in mysql query browser and phpmyadmin but not when it is called from php page. It does not happen all the time but only under some conditions.
For example - select * from table where 'formz-6.1' = LCASE(strip_all_unsafe_chars(`title`)) returns result at mysql query browser but not when it is called from php page.
but
select * from table where 'usb-external-3.5-mac-hard-drive-kit'=LCASE(strip_all_unsafe_chars(`title`))
returns results both at mysql query browser and from php page.
strip_all_unsafe_chars() is a stored function that i have created in mysql.
I donot know if this is a common problem but this is the first time I have encountered such problem. Any help will be highly appreciated.
Regards
Mike