A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/directory_listings.php

Line Number: 64

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 65

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 71

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 71

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 71

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 89

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 90

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/directory_listings.php

Line Number: 90

Database Error

A Database Error Occurred

Error Number: 1064

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 u.user_type=2 and u.active=1 group by u.id order by c.company_name limit 2' at line 1

select u.id, u.user_type, u.profile_name, u.date_created, u.questions, u.answers, u.rate_up, u.rate_down, i.first_name, i.last_name, i.address1, i.address2, i.city, i.state, i.postal_code, i.email, c.company_name, c.contact1, c.contact2, c.address1 as c_address1, c.address2 as c_address2, c.city as c_city, c.state as c_state, c.postal_code as c_postal_code, c.email as c_email, c.url, c.phone_work, c.phone_work2, c.phone_fax, c.phone_mobile, c.category, c.contractor_number, group_concat(cu.category_id separator '|') as categories from user u left join user_info i on u.id=i.user_id left join user_contractor c on u.id=c.user_id left join category_to_user_map cu on u.id=cu.user_id where c.postal_code in () and u.user_type=2 and u.active=1 group by u.id order by c.company_name limit 20