Every Monday, I pick a piece of popular media -- a book, a movie, a TV show,
or even an album. You pick a roleplaying world and talk about how you'd
combine the two. Post on your blog or LiveJournal, and stick a pointer to
your post in the comments here; if you don't have a blog, then go ahead
and abuse my comments section for your own pleasure.
The list of Mashers to the right is a list of those who've participated in the
meme. Visit early and often.
$link = mysql_connect("localhost", "mt", "g@mm@r@y")
or die("Could not connect : " . mysql_error());
mysql_select_db("movabletype") or die("Could not select database");
/* Performing SQL query */
$query = "SELECT mt_entry.entry_title, mt_entry.entry_id, mt_entry.entry_status, mt_entry.entry_keywords, mt_entry.entry_created_on FROM mt_entry, mt_placement WHERE mt_placement.placement_category_id = 39 AND mt_entry.entry_id = mt_placement.placement_entry_id AND mt_entry.entry_status = 2 ORDER BY mt_entry.entry_id DESC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
print "
\n";
/* Printing results in HTML */
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$dir_title = ( $line["entry_keywords"] ? $line["entry_keywords"] :
$line["entry_title"] );
$dir_title = strtolower($dir_title);
$dir_title = preg_replace("/&[^;\s]+;/", "", $dir_title);
$dir_title = preg_replace("/[^\w\s]/", "", $dir_title);
$dir_title = str_replace(" ", "_", $dir_title);
print "";
print $line["entry_title"] . "
\n";
}
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
?>