| Message Text |
Well, the gallery is up and running, thanks for the encoder help!
My problem now is with searches. I enabled all search fields in the admin panel and, I can search by title and description but, most other searches (such as xwidth) are returning errors of:
Performing query: SELECT id FROM members_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND (()) ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ~my path~/classes/database.php on line 82
Number of rows is for 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 '))' at line 1
It is not passing the field name to the query for some reason. My ultimate goal is to create several custom searches on fields that are unique to my database. To that end, I edited the Advanced Search template from:
<input type="text" size="{STANDARDSIZE}" name="namesearch">
to
<input type="text" size="{STANDARDSIZE}" name="user_namesearch">
which is my field name.
This seemed like it almost worked, instead of the:
'syntax to use near '))' at line 1' error I now get"
'Performing query: SELECT id FROM users WHERE (validated=1) AND ((user_name 'es')) ;'
It seems the < > like etc., are not being included in these queries.
So, I guess I have two problems. The first being that fields such as xwidth are not being passed to the query and the second being that the comparison operators are not being passed.
Am I doing/not doing something that I should be?
|
