real_escape_string($_GET['key']); } else { $key_id = 'LG_0001'; } if ($debug) { logMessage(LOG_REDWOOD, "$script_name : Key id - $key_id\n"); } $query = "SELECT * FROM genre WHERE genre_id = \"$key_id\";"; if ($debug) { logMessage(LOG_REDWOOD, "$script_name: Query - $query"); } $res = $dbh->query($query); if ($res) { if ($debug) { logMessage(LOG_REDWOOD, "$script_name : Query #1 passed"); } } else { if ($debug) { logMessage(LOG_REDWOOD, "$script_name : Query #1 failed"); } } // End of isResult while ($row = $res->fetch_assoc()) { $name = $row['genre_name']; $name = strtoupper($name); echo "
"; echo ""; echo "$row[4] | \n"; } else { if ($j <= $to) { for ($k = $j; $k <= $to; $k++) { echo "\n"; } } } // End of if } // End of for loop echo " |