Hey everyone,
We have an image module on our site: www.stonybrookmsa.com
But I need one that can randlomly choose one from a specific folder...because we have several ads we want to display. Anyone know how to do this?
- Farooq
Random Image Generator...H-E-L-P!!!
**unknown user**
- Rank: Registered User
- Registered: Mar 16, 2002
- Last visit: Oct 17, 2003
- Posts: 5
Posted: Oct 17, 2003 - 10:27 AM
- Rank: Registered User
- Registered: May 31, 2003
- Last visit: Oct 21, 2009
- Posts: 30
Posted: Dec 23, 2003 - 08:11 PM
I used the core block "Core/PHP".
My photo album script from smartor.
My photo album script from smartor.
Code
$query = "SELECT * FROM nuke_phpbb_album";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
$start = "1";
$random = mt_rand($start, $numrows);
echo "<table align=\"center\" cellspacing=\"2\" border=\"0\"/><tr/><td align=\"center\"/>";
echo "<a href=\"http://www.sgwutan.com/modules.php?op=modload&name=PNphpBB2&file=album\"/><img src=\"index.php?name=PNphpBB2&file=album_thumbnail&pic_id=$random\"/></a/>";
echo "</table/>";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
$start = "1";
$random = mt_rand($start, $numrows);
echo "<table align=\"center\" cellspacing=\"2\" border=\"0\"/><tr/><td align=\"center\"/>";
echo "<a href=\"http://www.sgwutan.com/modules.php?op=modload&name=PNphpBB2&file=album\"/><img src=\"index.php?name=PNphpBB2&file=album_thumbnail&pic_id=$random\"/></a/>";
echo "</table/>";
- Rank: Softmore
- Registered: Feb 07, 2003
- Last visit: Jun 11, 2008
- Posts: 225
Posted: Dec 24, 2003 - 04:51 AM
You might want to take a look at the MultiImage module at:
http://noc.postnuke.com/projects/multiimage/
Allows you to have a random image block.
http://noc.postnuke.com/projects/multiimage/
Allows you to have a random image block.
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 292
Posted: Dec 24, 2003 - 10:37 AM
You could streamline that code a bit as well:
This allows the mysql server to do the work of finding a random row. Not sure if it is really more or less effecient, just a different way of doing it.
Code
$query = "SELECT * FROM nuke_phpbb_album ORDER BY RAND(MD5(NOW))) LIMIT 1";
$result = mysql_query($query);
$picrow = mysql_fetch_assoc($result);
$picid = $picrow['id']; //I don't know what the column name is so you would need to insert that here instead of 'id'
echo "<table align=\"center\" cellspacing=\"2\" border=\"0\"/><tr/><td align=\"center\"/>";
echo "<a href=\"http://www.sgwutan.com/modules.php?op=modload&name=PNphpBB2&file=album\"/><img src=\"index.php?name=PNphpBB2&file=album_thumbnail&pic_id=$picid\"/></a/>";
echo "</table/>";
$result = mysql_query($query);
$picrow = mysql_fetch_assoc($result);
$picid = $picrow['id']; //I don't know what the column name is so you would need to insert that here instead of 'id'
echo "<table align=\"center\" cellspacing=\"2\" border=\"0\"/><tr/><td align=\"center\"/>";
echo "<a href=\"http://www.sgwutan.com/modules.php?op=modload&name=PNphpBB2&file=album\"/><img src=\"index.php?name=PNphpBB2&file=album_thumbnail&pic_id=$picid\"/></a/>";
echo "</table/>";
This allows the mysql server to do the work of finding a random row. Not sure if it is really more or less effecient, just a different way of doing it.
**unknown user**
- Rank: Registered User
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 8
Posted: Feb 11, 2004 - 03:44 AM
Hi,
Is it possible to create a "Recent Picture" block for Smartor's album with something like what you have here for "random block"? Can anyone please post code for it here? Your help will be greatly appreciated.
TIA
Is it possible to create a "Recent Picture" block for Smartor's album with something like what you have here for "random block"? Can anyone please post code for it here? Your help will be greatly appreciated.
TIA