Hi Guys,
Hoping someone can help me with this.. I have an artists script located on my site www.bangorfm.co.uk/artists.php - what i'm hoping to do is have the readartists.php have a PREVIOUS BIOGRAPHY / NEXT BIOGRAPHY ordered by ID
This is the code I have
<?
}
}
} else {
$sql="SELECT * FROM book1 WHERE newsid=$newsid ORDER BY newsname DESC";
$result=mysql_query($sql);
$myrow=mysql_fetch_array($result);
printf("<div align=left><font face=Verdana size=2><a href=artists.php><BR>BACK TO ARTISTS A/Z</a><br>");
printf("<Br><Br><font face=Verdana size=2><img src=%s border=1><BR>", $myrow["newsimage"]);
printf("<Br><font face=Verdana size=2><a href=%s target=blank>Visit Official Website</a><BR><BR>", $myrow["newsurl"]);
printf("<font size=3 color=#000000><b>%s</b></font> <font color=black size=1><b></b></font> <font color=#000000 size=1></font><font face=Verdana size=2> ", $myrow["newsname"], $myrow["newsby"]);
printf("<Br><Br><font face=Verdana size=2>%s", $myrow["newsbody"]);
printf("<Br><BR>Submitted By <B><font face=Verdana size=2>%s", $myrow["newsby"]);
}
?>
That displays what's currently on http://www.bangorfm.co.uk/readartists.php?&newsid=12
What I would like to have is a snippit of code at the bottom of that page that will link previous to the previous newsid= for example newsid=11 & next to link to newsid = 13 It's probably something really simple. I can't find it anywhere however!
Can anyone help :rolleyes: ?
