Hello,
$a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query
$b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } }
Not tested and might need some tweaking in the where clause, but should be at least close to what you need:
select t2.* from t t1, t t2 where t1.category=1 and t2.subcategory = t1.a
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
