HTML_Table question

From: Date: Thu, 14 Oct 2004 03:51:15 +0000
Subject: HTML_Table question
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-14907@lists.php.net to get a copy of this message
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. $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>";
} echo "Description: ".$row['descrip']."<p>"; $table -> addRow(array($row["title"], $row["page_url"], $row["descrip"])); } ... echo $table->toHTML(); ....

« previous php.pear.general (#14907) next »