Welcome Guest, Not a member yet? Register   Sign In
Simple query not working
#3

[eluser]mabright[/eluser]
I did that, both versions of the SQL string look fine and when I cut and paste the sql into my DB, I get results. It's real weird and driving me nuts.

When hard code or using variables both SQL strings look like below.
SELECT `region` FROM `my_region_table` WHERE UPPER(`country`) = 'US' AND UPPER(`description`) = 'GEORGIA'

However, the version that uses the variables doe not satisfy
Code:
if ($query->num_rows() > 0){...


Messages In This Thread
Simple query not working - by El Forum - 08-16-2010, 08:24 PM
Simple query not working - by El Forum - 08-16-2010, 09:51 PM
Simple query not working - by El Forum - 08-17-2010, 06:10 AM
Simple query not working - by El Forum - 08-17-2010, 08:30 AM
Simple query not working - by El Forum - 08-17-2010, 08:52 AM
Simple query not working - by El Forum - 08-17-2010, 09:22 AM
Simple query not working - by El Forum - 08-17-2010, 09:31 AM
Simple query not working - by El Forum - 08-17-2010, 03:07 PM
Simple query not working - by El Forum - 08-18-2010, 02:01 AM
Simple query not working - by El Forum - 12-06-2010, 04:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB