prepare('SELECT cat_path, name, gender FROM advice_cat ORDER BY gender'); $stmt->execute(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) printf("
• %s
\r\n", $myrow[2], $myrow[0], $myrow[1]); ?>

---

prepare('SELECT cat_path, name, gender FROM advice_cat WHERE gender = ? ORDER BY gender'); $stmt->bindParam(1, $gender); $stmt->execute(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) printf("
• %s
\r\n", $myrow[2], $myrow[0], $myrow[1]); ?>

---

Visitor-Submitted Advice:

prepare('SELECT title, body, name, location, date_added FROM advice WHERE cat_path = ? AND admin_flag = \'A\' ORDER BY date_added DESC'); $stmt->bindParam(1, $catpath); $stmt->execute(); $count = 0; while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { echo '

'; if ($myrow[0] != '') echo '' . $myrow[0] . '
'; echo '"' . $myrow[1] . '" -' . $myrow[2] . ', '. $myrow[3] .'

---

' . "\r\n"; $count++; } if ($count == 0) echo '

No advice has been posted in this section yet. You can be the first to submit advice, using the link below.

'; if ($gender == 'men') { echo '

Are You a Woman? Post Your Advice to this Section

'; echo '

Are You a Man? Give Some Advice to Women

'; } else if ($gender == 'women') { echo '

Are You a Man? Post Your Advice to this Section

'; echo '

Are You a Woman? Give Some Advice to Men

'; } ?>

---