Posted: Tue Mar 03, 2009 7:22 am trying to display 2 rows of pictures
trying to display a row of pictures as 2 rows - someone elses code - its for a vbulletin chat board
you can define the number of pictures in a variable and it has been suggested that the single row can be split with a 'wrap' tag - but i am lost - i cannot programme - i sort of understand the logic but altering it is beyond me
the 3 elements of the program are a php file and 2 templates within the vb software
thanks in advance for any help
tony
Quote:
<?php
// set how many to display
$tot = '3';
//dateline
//rand(NOW())
// replace dateline below with rand(NOW()) if you want it random
$orderby = "rand(NOW())";
$lpictures = $db->query_read("
SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "albumpicture AS albumpicture
LEFT JOIN " . TABLE_PREFIX . "album AS album ON(album.albumid = albumpicture.albumid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = album.userid)
WHERE album.state = 'public'
ORDER BY $orderby DESC LIMIT 0, $tot
");
$cols = $db->num_rows($lpictures);
$albumpics
</tr>
</table>
</td>
</tr>
<td class="thead"><span class="mallfont"><strong><center>Click on any picture to see a larger view.</center></strong></span></td>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
HTML Help Forum
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
