'); $reel=0; while ($reel < 110) { $select= "SELECT * FROM `testTJG2` WHERE (reel=$reel)"; $result=@mysql_query($select) or die('The search on '.$reel.' failed; please try again in a minute or contact the webmaster.'); $reel++; $current = mysql_fetch_array($result); $title = $current["title"]; $date = $current["date"]; $description = $current["description"]; $desc = substr($description,0,80); $filename = $current["url"]; $tempname = split("-", $filename); print $tempname[0]; $firstbit = $tempname[0]; $firstchar = substr_replace($firstbit, "", -1); print $firstchar; $firstchar++; if($filename){ echo(' '); } } echo(' '.$filename.' '.$title.' : '.$date.' '.$desc.'...

'); ?>