Item Search
Posted: Fri Apr 02, 2010 6:46 pm
Tossing php error:
items.php
MYSQL_QUERY
SELECT items.id,items.name FROM items WHERE (items.hp >= 200),merchantlist AND merchantlist.item=items.id AND (items.itemtype=54) GROUP BY items.id ORDER BY items.Name LIMIT 101
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 'merchantlist AND merchantlist.item=items.id AND (items.itemtype=54) GROUP BY it' at line 1
Have you sourced the eqbrowser tables in your database ?
items.php
MYSQL_QUERY
SELECT items.id,items.name FROM items WHERE (items.hp >= 200),merchantlist AND merchantlist.item=items.id AND (items.itemtype=54) GROUP BY items.id ORDER BY items.Name LIMIT 101
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 'merchantlist AND merchantlist.item=items.id AND (items.itemtype=54) GROUP BY it' at line 1
Have you sourced the eqbrowser tables in your database ?