Including standard biographies in articles

Hi,

What you can do is create a section called Authors. In that section you can have the author's name, Bio, image, etc.

In your article section, you can have an author drop down that pulls information from the authors table. You can use any field you like for the label, but use num for the value.

Then, in your detail page, after you've selected your article, you can do a second query to retrieve your author record.

In this example, it's assumed that your using a variable called $article to store your article record on the detail page.

list($authorRecord,$authorMetaDate)=getRecords(array(
'tableName' => 'authors',
'allowSearch' => false,
'limit' => 1,
'where' => "num = '".intval($article['author'])."'",
));

if($authorRecord){
$author = $authorRecord[0]; //get first record
}
else{
$author=array();
}

At the end of this code, you have everything from the author table for the author associated with that article stored in $author.

You'll have to do a check to see if an author was returned before outputting information (in case no author is associated with the record).

example:

<?php if($author):?>
** OUTPUT AUTHOR INFORMATION **
<?php endif ?>

Hope this helps get you started. Give this a try and let me know if you run into any problems.