I'm Not sure why i it is happening i have read some explanations on here but cant seem to find it my self.
On both my series and episodes lists for my site i am missing the first row when echoing the results. any help to fix this would be great.
heres the coding for the episode page
<?php include '../connect/dbseries.php' ?>
<?php $result2 = mysql_query("SELECT
seriesID,
seasonindex,
sortname,
thumbfilename,
CurrentBannerFilename,
PosterBannerFileName,
summary,
IMDB_ID,
episodename,
episodeindex,
compositeid
FROM Series
WHERE seriesid = '$_GET[id]'
order by Seasonindex, Episodeindex ASC;");
if (!$result2) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row2 = mysql_fetch_row($result2);
//setup array
$ID = $row2['0'];
$seasonindex = $row2['1'];
$Sortname = $row2['2'];
$thumb = $row2['3'];
$Bannerfilenames = $row2['4'];
$currentbanner = $row2['5'];
$Summary = $row2['6'];
$imdb = $row2['7'];
$EN = $row2['9'];
$Eid = $row2['9'];
$cid = $row2['10'];
while($row=mysql_fetch_array($result2)){
echo '<br /> <a href="seriesinfo.php?id='.$row['compositeid'].'"><img src="../images/series/'.$row['thumbfilename'].'" width="200" height="200"></a> "'.$row['summary'].'" "'. $row['episodename'] .'" "'. $row['episodeindex'] .'"' ;
}
?>
hopefully some one out there will take pitty and show me the error of my ways.
