|
|
Posted by kiqyou_vf on 01/09/06 04:06
I have a page that displays search results. With each entry returned, I
want to be able to display rows from 2 or more tables.
table.qcbd has a keywords column that I want to search and
table.qcbd_home has a description that I want to include in the search
results. So if a search for "cups" returned 8 results, I would want
each result to have information from table.qcbd AND table.qcbd_home.
I'm not exactly sure how to go about doing this. I've tried some really
messy coding, putting a query INSIDE of the while loop, lol- that
didn't work.
This is not the code, but I'll describe what I want to do like this:
SELECT * FROM qcbd, qcbd_ghours WHERE keywords = $_GET['search']
I would then do a loop and extract all of the returned rows from both
tables. The problem I'm running into is that the returned rows dont
line up.
Hope this clears things up. As for the code, I don't really have
anything of use to show you. Thanks!
Navigation:
[Reply to this message]
|