test
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
test
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
If you want power take a look at Metabase, it covers most major DBs with a
single interface.
If you want simple, but functional, contact me offlist and I will send you
mine, which works well.
Peter
---
Excellence in internet and open source
I would like to allow articles to be searched and
returned in grouped categories - similar to cnet.com
See example here:
http://cnet.search.com/search?timeout=3q=php
Grouping is not a problem - but it becomes a problem
when there are thousands of results and I only want to
display the first
resource *odbc_primarykeys* ( resource connection_id, string qualifier,
string owner, string table)
resource *odbc_foreignkeys* ( resource connection_id, string
pk_qualifier, string pk_owner, string pk_table, string fk_qualifier,
string fk_owner, string fk_table)
int *odbc_tables* ( resource
If your articles are in an SQL database uses the LIMIT clause on your SQL
statement.
Adam
On Fri, 16 Aug 2002, olinux wrote:
I would like to allow articles to be searched and
returned in grouped categories - similar to cnet.com
See example here:
Thank you but this is not what I am looking for.
LIMIT will limit the overall results but I need to
limit the number of matches to each category 'type'
example: for the data below there may be 1000 news
story matches - I want to return the user the top 5
news stories - the top 5 feature matches
I am just trying to return a few results from each
category. like this:
http://cnet.search.com/search?timeout=3q=php
sql query example:
SELECT id, article_date, category, region, title FROM
articles WHERE MATCH (title,article) AGAINST
('$search_word');
There are 20 possible categories that may