hi wonder if anyone could help me 🙂 trying to write a script which will output links to authors columns, anyway here is the code
<?
include("php/newsconf.php");
$news_query = mysql_query("select * from col order by author desc")
or die("Query broke! $news_query");
while ($row = mysql_fetch_array($news_query))
{
$ID=$row["ID"];
$Title=$row["Title"];
$Text=$row["Text"];
$newsitem = nl2br(stripslashes($Text));
$DateSub=$row["DateSub"];
$author=$row["author"];
echo('<TABLE cellSpacing=0 cellPadding=6 width="100%" align=center border=0>');
echo('<DIV align=left>');
echo('<tr>');
echo('<td>');
print("<a href=\"columns.php?author=$author\">");
print("<b>$Title</b>");
echo('</a>');
echo('</td>');
echo('<td>');
echo('<p align="right">');
print "$DateSub";
echo('</td>');
echo('</tr>');
echo('</DIV>');
echo('</TABLE>');
}
?>
The problem i'm having is if anyone makes 2 entrys it ouputs 2 links to that users column and i only want it to output 1 link really regardless how many updates the user makes
thanks
