|
WHAT:
|
$article_sql = "select id,section_id,title,blurb from document where published_flag = 'Y' and author_id = '$author->id'";
$article_select = mysql($db, $article_sql);
while ($article = mysql_fetch_object($article_select))
{
$section_sql = "select title from section where id = $article->section_id";
$section_select = mysql($db,$section_sql);
$section = mysql_fetch_object($section_select);
$date_sql = "select date_format(submit_date, '%m.%d.%y') from document where id = $article->id";
$date_select = mysql($db,$date_sql);
$date = mysql_fetch_row($date_select);
print " $date[0] | $section->title - title.hellyeah.com/display_doc.phtml?id=$article->id\">$article->title ";
print "$article->blurb ";
}
?>
|