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
mysql query problem
Moderator: General Moderators
-
thewebdrivers
- Forum Commoner
- Posts: 41
- Joined: Fri Aug 17, 2007 3:32 pm
- Location: india
- Contact:
Make use of the mysql_error() function. And also, there could be a problem with your custom functions not returning anything.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
-
thewebdrivers
- Forum Commoner
- Posts: 41
- Joined: Fri Aug 17, 2007 3:32 pm
- Location: india
- Contact: