Selecting multiple categories
Posted: Tue Jul 20, 2004 5:49 pm
I have my website listed as first category and I do have several other categories as well. What I want to do is no matter what the selected category is, I always want to go to the first category and display 3 results for the user query and after that display results for the user's selected category. What I want to know is:
sql="from html
where Title\Description\Keywords\Meta\Body " $liketype " $$q
and Title like $$tq
and Url matches $$uq
and Depth <= $$dq
and Catno matches $$cq
is this the sql to get results corrsponding to a category? How can I hard code first category into it. I tried replacing cq with 1 etc. but doesn't work.
sql="from html
where Title\Description\Keywords\Meta\Body " $liketype " $$q
and Title like $$tq
and Url matches $$uq
and Depth <= $$dq
and Catno matches $$cq
is this the sql to get results corrsponding to a category? How can I hard code first category into it. I tried replacing cq with 1 etc. but doesn't work.