zencart網站擷取所有產品ID和所屬分類的SQL語句

1. require("includes/configure.php");

2. $dbh = @mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);

3. if(!$dbh){die("error");}

4. @mysql_select_db(DB_DATABASE, $dbh);

7. $getCATIDsql = "SELECT categories_name,products_id FROM categories_description,products WHERE categories_description.categories_id = products.master_categories_id";

8. $query2 = mysql_query($getCATIDsql,$dbh);

9. echo '<table border=1><tr><td><strong>產品ID號</strong></td><td><strong>產品所屬分類</strong></td></tr>';

10. while($result = mysql_fetch_array($query2)){

11. echo '<tr><td>' . $result['products_id'] .'</td><td>'. $result['categories_name'] . '</td></tr>';

13. }

14. echo '</table>';

代碼用途：擷取當前網站所有產品的ID號，以及該ID號碼所屬分類。

本文出自 “電子商務解決方案” 部落格，請務必保留此出處http://wmrwx.blog.51cto.com/1418507/1301151