messinWifU

"(LQb)EP SW 1" that was an accident.

When I execute this code it pulls both rows twice. $q = ('SELECT count(*) FROM `shows`'); $num = mysql_query($q); $i=1; while($i<$num){ $query = sprintf("SELECT pid,epid,title FROM `shows` WHERE cid=" . $i); $result = mysql_query($query); while($ds = mysql_fetch_assoc($result)){ echo(' <ul id="' . $ds['pid'] . '" title="' . $ds['title'] . '"> '); $q = sprintf('SELECT episodes.pid,episodes.ptid FROM episodes JOIN shows ON episodes.epid="'. $ds['epid'] .'" ORDER BY episodes.ptid'); $res = mysql_query($q); while($ds1 = mysql_fetch_assoc($res)){ echo(' <li><a href="#' . $ds1['pid'] . '#_video">' . $ds1['ptid'] . '</a></li> '); } echo "</ul>"; } $i++; } Here is the output: <li><a href="#swid">SW</a></li> <li><a href="#bid">B</a></li> </ul> <ul id="swid" title="SW"> <li><a href="#sw1#_video">(LQb)EP SW 1</a></li> <li><a href="#sw1#_video">(LQ)EP SW 1</a></li> </ul> <ul id="bid" title="Bleach"> <li><a href="#b1#_video">(HQ)EP B 1</a></li> <li><a href="#b1#_video">(HQ)Ep B 1</a></li> </ul> I probably have a simple mistake but I cant find it, all help/suggestions are welcome