[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] Search within search on multiple tables
Jason Currell <currell@nettwerk.com> writes:
> I'm wondering if anybody knows how to do multilevel searches.
> For example lets say I have a products table and a price table.
> How would I do a search on the description in the products table
> and use the results of that search to then search the product
> table (all in the same page).
I suggest to use joined SQL statements like
[sql type=list query="..."]
[sql-param 0]
[/sql]
Ciao
Racke
--
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Junior Officer of the MiniVend/Interchange Bug Patrol <---
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
