2
Not guaranteeing this is going to work but give it a try.
AT line 28 of myalbum/index.php replace
Quote:
$prs = $xoopsDB->query( "SELECT l.lid, l.cid, l.title, l.ext, l.res_x, l.res_y, l.status, l.date, l.hits, l.rating, l.votes, l.comments, l.submitter, t.description FROM $table_photos l LEFT JOIN $table_text t ON l.lid=t.lid WHERE l.status>0 ORDER BY date DESC" , $myalbum_newphotos , 0 ) ;
with
Quote:
$prs = $xoopsDB->query( "SELECT l.lid, l.cid, l.title, l.ext, l.res_x, l.res_y, l.status, l.date, l.hits, l.rating, l.votes, l.comments, l.submitter, LEFT(t.description,100) FROM $table_photos l LEFT JOIN $table_text t ON l.lid=t.lid WHERE l.status>0 ORDER BY date DESC" , $myalbum_newphotos , 0 ) ;
Notice we changed the t.description to LEFT(t.description,100)
Report back here so others can share.
Regards
A
