[DeathByAnts]

First, a bit of an introduction. I am in the process of learning PHP and MySQL, so give me a bit of leeway. I picked up this site about 6 weeks ago. After changing hosts and the other issues associated with transferring a site, we noticed that when a person viewed an author's profile, not all of their book series are showing up.

Things I have concluded:
*It is not showing only series showing after a certain date
*It is not showing only series edited after a certain date
*It is repeatable with the same exact results
*Using the search function, the missing series do show up

As far as I can tell, there is no rule on PT that says anything about not posting your own URL.

Example author page: http://www.iblist.com/author45.htm
(note that is is a PHP page, but mod_rewrite is used to disguise it.)

Only the series Honor Harrington shows up. The series "Dahak" does not show up. The Dahak series is at http://www.iblist.com/series.php?id=1389

Now for the code. I am pasting all (I think) relevant code from author.php.

mysql_query("INSERT INTO tmp SELECT series.id,series.name FROM book_author LEFT JOIN book ON book_author.bookid=book.id LEFT JOIN series ON book.series=series.id WHERE book_author.authid=" . $showid . " AND series.id IS NOT NULL AND series.name IS NOT NULL");

$seriesresult = mysql_query($query) or die ("Error: Couldn't retrieve series data.");

if (mysql_num_rows($seriesresult)) {

print "\t\t\t\t\t<br><i>Series:</i>\n";

while($seriesline = mysql_fetch_array($seriesresult, MYSQL_ASSOC))

print "\t\t\t\t\t\t<LI><A HREF=\"series.php?id=$seriesline[id]\">$seriesline[name]</A></LI>\n";


Does anyone have any ideas about this issue?