Hello,
I am trying to make a fulltext search over columns from two tables.
The queer thing is: sometimes it works, but more often I get the error message:
Got error 28 from table handler (in mysql_error output).
I am not sure what error 28 is, I checked the manual but couldnt find anything.
The query is something like:
SELECT author, title, publ_desc, MATCH author, title AGAINST ('child') as
t, MATCH publ_desc AGAINST ('London Save') as s FROM books, publ WHERE
publ_id = pub_id ORDER BY t DESC, s DESC
author and title are the columns in table books, publ_desc a column in
table publ.
publ_id is the id referred to in table books by pub_id.
I checked that the indexes are correct, so I dont think thats the error.
If anyone has an idea on this Id be happy about any suggestions!!!
Or if anyone knows where to find script examples on this query on the net.
Cheers, Nessi :)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
