[Koha] searching?

[Adam Thick]

haven't got any problems with the scripts themselves, so no,
don't have anything in the apache logs...
thought it might have more to do with the database,  extracted
some of the SQL from the Search.pm.


This one works fine, nice and simple :

"Select * from biblio
where ((title like 'adam%' or title like '% adam%'))
or ((author like 'adam%' or author like '% adam%'))
or ((seriestitle like 'adam%' or seriestitle like '% adam%'))
or ((notes like 'adam%' or notes like '% adam%'))
order by title limit 0,10"



Get no results from this query though.
There's no data in some of these tables.
I was wondering whether all data gets entered using the simple Acquistions
page?
Or is there extra data that I need to enter?

"Select * from biblio,bibliosubtitle,biblioitems
where biblio.biblionumber=biblioitems.biblionumber
and biblio.biblionumber=bibliosubtitle.biblionumber
and (((title like 'adam%' or title like '% adam%'))
or ((subtitle like 'adam%' or subtitle like '% adam%'))
or ((seriestitle like 'adam%' or seriestitle like '% adam%'))
or ((biblio.notes like 'adam%' or biblio.notes like '% adam%'))
or ((biblioitems.notes like 'adam%' or biblioitems.notes like '% adam%')))
group by biblio.biblionumber"



Cheers,
Adam Thick.