Hi,

I'm looking for some code to use on a gallery page. In a database, I have some data stored such as the article ID for the images, eg. "2607041" and there is also a number such as "19" which is the total number of images available.

Basically, I'd like to retrieve that number and use it to return 19 thumbnail images, incrementing for each. So the 1st thumbnail would be 001.jpg, the second 002.jpg up to the 19th thumbnail as 019.jpg.

Also, the table where the images are show would need to have no more than 5 images on each row and if the total number of images exceeds 25, I'd need a link to the next page, where it would start the thumbnails from no. 26. Then that would need a previous button etc.

Do you know what I mean?

If you can help, I'd much appreciate it.

Sam

This was discussed many times at this forum. Simple add the zerro before your numbers. And in sql request use LIMIT 0,25 next will be LIMIT 25,25.

That's not the big problem. The thing I don't have a clue to do is how to create 19 thumbnails with 5 on each row. Any ideas?

Thats simple

PHP Code:

$limit=5;
$files=19;
$cell=1;
echo "<table><tr>";
for($i=1; $i<=$files; $i++){
echo "<td><img src='yourimg'></td>";
if($cell!=$limit) {
$cell=$cell+1;
}else{
echo "</tr><tr>";
$cell=1;
}
}
echo "</tr></table>" 


Wow! That works great! Thanks.

Only thing is, it only returns the same image for each thumbnail. How can I make it return 001.jpg for thumbnail #1, 002.jpg for #2 etc. up to #19 for 019.jpg (keeping zero).

Thanks.

Have fun

PHP Code:

$limit=5; 
$files=19; 
$cell=1; 
echo "<table><tr>"; 
for($i=1; $i<=$files; $i++){ 
if ($i < 10) { $num = "00".$i; 
} else if($i < 100) {
 $num = "0".$i; 
}
echo "<td><img src='".$num.".jpg'></td>"; 
if($cell!=$limit) { 
$cell=$cell+1; 
}else{ 
echo "</tr><tr>"; 
$cell=1; 
} 
} 
echo "</tr></table>" 


Thanks Veter. That worked great! All I need to do now is integrate it with my pages and add a popup window javascript.

Your help is much appreciated.

Sam

The auto-generation of thumbnails works almost perfectly. The first row always seems to return 6 thumbnails despite being limited to 5. Any ideas?

Secondly, for some odd reason, my javascript window is ignoring 'status=yes,width=484,height=464' and opening a default window size with no status bar. I'm sure it has something to do with my placing of quotes but I've had quite a fiddle and had no luck. Anyone know what I'm doing wrong? The window launches fine it is just that the status and dimensions remain undefined.

PHP Code:

<?
$limit=5; 
$files=$gallery_total; 
echo "<table><tr>"; 
for($i=1; $i<=$files; $i++){ 
if ($i < 10) { $num = "00".$i; 
} else if($i < 100) { 
$num = "0".$i; 
} 
echo "<td><a href='javascript:'><img src='../images/thumb/".$fullid."/".$fullid."_".$num."th.jpg' alt='Click here to view larger image' width='80' height='80' border='1' onClick=\"MM_openBrWindow('../images/view-standard.php?id=".$fullid."&image=".$num."','".$fullid."".$num."','".$fullid."".$num."','status=yes,width=484,height=464')\"'></a></td>";
if($cell!=$limit) { 
$cell=$cell+1; 
}else{ 
echo "</tr><tr>"; 
$cell=1; 
} 
} 
echo "</tr></table>" 
?>

Thanks

Put $cell=1; right after $limit=5;

And try to put all options 'scrollbars=yes,toolbar=no,status=no,resizable=yes ,width=484,height=464'

Thanks, Veter.

The $cell=1 seemed to fix that but the javascript popup is still a problem. You can look at the offending page below.

The site is password protected whilst development is going on:

http://www.thecarfanatics.com/sam/ne...php?id=1407041

User: webtalk
Pass: opensesame

Click "Related Gallery" to see the problem here.

Oh yes
Look here:

('../images/view-standard.php?id=3003041&image=001','3003041001','3 003041001','scrollbars=yes,toolbar=no,status=no,re sizable=yes,width=484,height=464')

You have one extra '3003041001', in the function call. remove it and it will be fine.

Nice site btw.

Few advices:
Take out CSS in standalone file and do the same with java sript functions

Thank you VERY much, Veter. Not sure how I managed to add two in.

Thanks for the comment about the site. Much appreciated.

The CSS is included via PHP as a .css file - is that what you mean?

I mean all your stuff from <style type="text/css"> ... </style> section take out to the other file, called style.css.
And instead of the <style type="text/css"> ... </style> section
just put <link href="style.css" rel="stylesheet" type="text/css">