Re: Re: [PEAR] HTML_Table question

> > Below I first have standard PHP combining/rendering two tables and > > possibly multiple records, below that I have HTML_table code that I want > > to have render the same data but the problem is that [in the "standard" > > php] I've embedded a query/loop inside another query loop in order to > > get the data I want. How do I do it with the HTML_Table object? > > I'd expect within the page_url table cell I'd have the multiple urls > > from the inner query. Hope you understand what I'm asking. Thanks, Lee G. > > .....so why don't you do it? Is it that easy? I'm sorry i'm not seeing it. Could you give me a snipet or an example? Thanks! > > > > > $query = "SELECT page.* FROM page LEFT JOIN > > keywords USING > > (page_id) WHERE MATCH > > (keywords.keyword_txt) AGAINST > > ('$radio_keyword' IN BOOLEAN MODE)"; > > > > $result = mysql_query($query); > > > > for( $i = 1; $row = mysql_fetch_array($result); $i++ ) > > { > > echo "$i. Title: <b> > > ".$row['title']."</b><br>"; > > $query1 = "SELECT url_pages.page_url FROM url_pages WHERE > > page_id=$row[page_id]"; > > $result1 = mysql_query($query1); > > for( $j = 1; $row1 = mysql_fetch_array($result1); $j++ ) { > > echo "URL: ".$row1['page_url']."<br>"; > > $row['page_url'] .= $row1['page_url'].'<br/>'; > > > } > > echo "Description: ".$row['descrip']."<p>"; > > > > $table -> > > addRow(array($row["title"], $row["page_url"], > > $row["descrip"])); > > > > } > > ... > > echo $table->toHTML(); > > .... > > > > -- > paperCrane --Justin Patrin-- >