General Support: Plogger Random Image Display Script

Thanks for this script work theg3nius....I used your script to display Plogger thumbnail links within the http://www.squible.com/my-work/squible/ Squible theme instead of the native flickr feed.

below is the script
<?php
$host="hostname";
$username="username"; //Database username here
$password="dbpassword"; //Database password here
$database="dbname"; //Database name here
$amount="6"; //How many images do you want shown?
$siteurl="http://yoursite.com/ploggerdirectory"; //The URL of your Plogger directory E.G. http://yoursite.com/ploggerdirectory ***IMPORTANT*** DO NOT INCLUDE A TRAILING SLASH LIKE THIS http://yoursite.com/ploggerdirectory/

//Database Connection
$connection = mysql_connect($host, $username, $password);
$db = mysql_select_db($database);

$q = "SELECT * from plogger_pictures order by RAND() LIMIT $amount";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$path=$row["path"];

$number=strrpos($path, '/');
$number=$number+1;
$url=substr($path, $number);

?>
<a href="<? echo "$siteurl"; ?>/index.php?level=picture&id=<? echo "$id"; ?>"><img src="http://yoursite.com/ploggerdirectory/thumbs/<? echo "$id"; ?>-<? echo "$url"; ?>" border="1" style="border-color:black"></a>
<?php } ?>

the previous code is substituted for flickr.php in squible/elements/
in squible/inc.php you have to comment out the Flickr Integration variables

I too would like to add my thanks - I've used it at my home page, www.croila.net.

It was so easy to implement: brilliant! Thank you.

Great Script.Lot of thanks.Can we get this output as Mode Rewrite URL?

Thanks !!!
Pandian