real_escape_string($_GET['id']); }
$query = "SELECT * FROM genre WHERE genre_id = \"$genre_id\";";
$res = $dbh->query($query);
if ($res) {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 passed"); }
} else {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 failed"); }
} // End of isResult
while ($row = $res->fetch_row()) {
$name = $row['genre_name'];
$name = strtoupper($name);
}
?>
query($query);
if ($res) {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 passed"); }
} else {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 failed"); }
} // End of isResult
$count = $res->num_rows;
if ($debug) { logMessage(LOG_REDWOOD, "Count: $count"); }
if ($count >= 1) {
while ($row = $res->fetch_assoc()) {
$org_id = $row['client_id'];
$query2 = "SELECT * FROM orgs WHERE client_id = \"$org_id\";";
$res2 = $dbh->query($query2);
if ($res2) {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 passed"); }
} else {
if ($debug) { logMessage(LOG_REDWOOD, "Query #1 failed"); }
} // End of isResult
while ($row2 = $res2->fetch_assoc()) {
$org_name2 = $row2['org_name'];
$url = $row2['url'];
echo "- $org_name2\n";
}
} // End of while
} else { // End of if
echo "
Sorry, No entries found.
\n";
}
$dbh->close();
?>