sql query help!

[louphp]

Hi,
I'm trying to write a query that when a user enters a search term in a text box such as Computing, it will then check whether there are any adverts available with Computing in their title.

The tables are:

advert2
(advert_id, username, mod_book_id, asking_price, condition, description, date_added)

ts_module_books
(id, module_code, essential_useful, author, book_title, publisher, pub_year)

the query im using is:

"select * from ts_module_books inner join advert2 on advert2.mod_book_id = ts_module_books.id where ts_module_books.book_title LIKE '%$search%'"

However, what i want outputting to the page is

book_title, author and publisher from ts_module_books,
and also user from the advert2 table.

Is this possible? And if so, how do i do this?

Thanks.

Lou

[sid]

ok... what i would do is the following:

SELECT t.book_title, t.author, t.publisher, a.username
FROM advert2 a, ts_module_books t
WHERE a.mod_book_id = t.id
AND t.book_title LIKE '%$search%'";

OR, since you actually have unique field names, even

SELECT *
FROM advert2 a, ts_module_books t
WHERE a.mod_book_id = t.id
AND t.book_title LIKE '%$search%'";

should work...

retrieve the data with

while ($row = mysql_fetch_array($result)) {
    print $row[book_title] . ", " . $row[author] . $row[publisher] . ", " . $row[username] . "<BR>";
}