wsndirectory- When sponsored listings set to Yes in admin:
-Listing Type Sponsorship Settings --Separate sponsored listings from other types and don't count towards per page total? YES
if only zipcode is entered you get sql error:
'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/admindw/public_html/databases/mysqli.php on line 73. Last SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND type = 'featured' ORDER BY hits DESC LIMIT 0,5' at line 1
When sponsored listings set to No in admin it works.
Comments on zipcode search sql error
Beginner
Usergroup: Customer
Joined: Feb 13, 2010
Total Topics: 3
Total Comments: 5
wsndirectory- When sponsored listings set to Yes in admin:
-Listing Type Sponsorship Settings
--Separate sponsored listings from other types and don't count towards per page total? YES
if only zipcode is entered you get sql error:
'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/admindw/public_html/databases/mysqli.php on line 73.
Last SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND type = 'featured' ORDER BY hits DESC LIMIT 0,5' at line 1
When sponsored listings set to No in admin it works.
Thanks you
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Fixed for the next release.