hukadeeze

sorry, that was an error in the posting. even when the select and match statements are equal mysql returns the same error. I did some research and found a post where someone said you can't full-text search more than one table.

Is there another way to full-text search the same term against two tables?

I tried that, and I still get the same error.

I'm trying to run a full text search on two tables. One is a table populated with books, the other with cards. The term I'm using to search in the code below matches one record in the books table. When I run the first block of code, which queries just the books table, the correct record is returned. However, when I modify the query to include the cards table as well, mysql throws an error stating there are incorrent arguments for the MATCH clause (#1210 - Incorrect arguments to MATCH). Have I constructed this query incorrectly? This query works: SELECT Title, AuthorIllustrator, Form, MATCH(Title, AuthorIllustrator, ISBN10, ISBN13) AGAINST ('Amadito') AS score FROM books WHERE MATCH(Title, AuthorIllustrator, ISBN10, ISBN13) AGAINST ('Amadito') This query does not work: SELECT books.Title, books.AuthorIllustrator, books.Form, cards.Title, cards.Artist, cards.CardNumber, MATCH(books.Title, books.AuthorIllustrator, books.ISBN10, books.ISBN13, cards.Title, cards.Artist, cards.CardNumber) AGAINST ('Amadito') AS score FROM books,cards WHERE MATCH(books.Title, books.AuthorIllustrator, books.ISBN10, books.ISBN13, cards.Title, cards.Artist, cards.CardNumber) AGAINST ('Amadito')

My result was mysqli, not mysql, so the function didn't match the result. It works now. Man so much frustration over something so small. Gotta love it.

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource ??

does the record set begin at 0 or 1?

There is a lot of code. Each function is quite long. I read something about a pointer for the query results. When you loop all the way through a query, does the pointer reset, or stop at the end?

I'm running into problems using a single query more than once during the same request. I execute the query, pass it to one function where it is looped through, then pass it to another function where it is looped through again. When I loop through it the second time nothing is output. I checked from inside the second function to see if all the records were there, and they were. The loop is even executing the correct amount of times. It's just not outputting anything. Any idea?

bump!

I'm not using that variable name, I was just using it as a representation of the resultset.

'Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource' I tried both: mysql_data_seek($query,0); and $query = mysql_data_seek($query,0); I'm running the code directly after I exit a loop using the query.

Can you use a queries results only once? In this script I'm looping through a query and saving some values in an array. A little further through the script I need to use the same query for output. When I loop through nothing is echo'd to the browser. When I output a row count it shows that the correct number of records, so they must still be there.

I answered my own question. I used the combo assign operator to add everything I needed to one variable and then returned the variable. ... $var .= '<p>'.$title.'</p><br />'; $var .= '<p>'.$description.'</p><br />'; .... return $var;

I just got your response, but after I answered my own question. Instead of using the buffer I used the combo assign operator to add everything I needed to one variable and then returned the variable. ... $var .= '<p>'.$title.'</p><br />'; $var .= '<p>'.$description.'</p><br />'; .... return $var;