This is the code that I've started with:
$book_id = $_GET['book_id'];
$query = "SELECT R_reviewerlnk
FROM reviewer LEFT JOIN book_reviewer USING (R_id)
WHERE book_reviewer.B_id = $book_id";
$result = mysql_query($query);
if (mysql_num_rows($result) >= 1) {
while ($rev_arr = mysql_fetch_array($result)) {
$rev_name[] = stripslashes($rev_arr['R_reviewerlnk']);
}
$reviewer = implode(', ', $rev_name);
} else {
echo mysql_error();
}
What I want to ultimately do is separate the results into independant links limiting the results to 5 reviewers. I've tried looking around and the closest thing I can think of doing is use a split() to separate the results and put separate html tags around them. Is there any way I can do this? Any help would be greatly appreciated.