Webmastersite.net
Register Log In

zipcode search sql error

Comments on zipcode search sql error

rdev
Beginner

Usergroup: Customer
Joined: Feb 13, 2010

Total Topics: 3
Total Comments: 5
rdev
Posted Feb 13, 2010 - 7:33 AM:

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Feb 16, 2010 - 7:16 PM:

Fixed for the next release.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.