<?
$pullauthors = mysql_query("SELECT * FROM article_authors where authorid=$author",$db) or die (mysql_error());
if ($row = mysql_fetch_array($pullauthors)) {
$authorid=$row["authorid"];
$authorname=$row["authorname"];
$authoremail=$row["authoremail"];
?>
<h1><?echo $authorname?></h1>
<?
}
?>
<?
$pullcolumns = mysql_query("SELECT * FROM article_columns where columnauth=$author",$db) or die (mysql_error());
if ($row = mysql_fetch_array($pullcolumns)) {
do{
$columnid=$row["columnid"];
$columndate=$row["columndate"];
$columntitle=$row["columntitle"];
$columnintro=$row["columnintro"];
list ($date_year, $date_month, $date_day) = explode ('-', $columndate);
$string = "$columndate";
$stringArray = explode("-", $string);
$date = mktime(0,0,0,$stringArray[1],$stringArray[2],$stringArray[0]);
$convertedDate = date("d/m/Y", $date);
?>
<p><a href="?viewarticle=<?echo $columnid?>"><?echo $columntitle?></a>
<br><?echo $columnintro?> - <?echo $convertedDate?></p>
<?
}while ($row = mysql_fetch_array($pullcolumns));
}
?>
Is there another way that this can be done which is nicer on the server load as this may get too chaotic if the number of authors builds up.
