#1 Search-Bug

[Barnabas Crockre]

On Apache 2.0.46 (Win XP) with PHP 4.3.2 and MySQL
4.0.13 I get following error message when searching for
a title in all classes:

Database error: Invalid SQL: select accession_no,
class_no, isbn, book_name, authors from book where 1 =
1 and ( or book_name like '%test%');
MySQL Error: 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 'or
book_name like '%test%')' at line 1)
Session halted.

I enteres test in the title search-field. This does not
happen when you select a class and this does not happen
if you are searching for an author (code seems to be
the same).

[Daniel Czarkowski]

Logged In: YES
user_id=888985

True, there is a bug. Someone fixed that?