Loop Resize

NZ_Kiwis

This only shows one image. How I can get it to loop and show all it's images

<?php
mysql_connect (**, **, **);
mysql_select_db (**);
$result = mysql_query ("SELECT * from **_trips where trip_id = $trip_id"); 
while ($row = mysql_fetch_array($result)) {

$pid = $row[id];
$result5 = mysql_query ("SELECT * from **_trips where id = $pid"); 
$row5 = mysql_fetch_array($result5);

$filename = $row5["url"]; 
$percent = 0.12;


// Get new sizes
list($width, $height) = getimagesize($filename);
$newwidth = $width * $percent;
$newheight = $height * $percent;

// Load
$thumb = imagecreatetruecolor($newwidth, $newheight);
$source = imagecreatefromjpeg($filename);

// Resize
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);

// Output
imagejpeg($thumb);
}
?>

ednark

first off, why do you need two sql statements? It should be possible to combine them into one. depending on what you are trying to do you may just be able to use an 'AND' if accessing the same table, or possibly join the table to itself if your query is more complicated. If you are pulling from two different tables you could join them...

and when you call imagejpeg() the function is writing output directly to the browser. so it may be that it is successfully looping through and just displaying the first item.

do some debugging with print_r() on your $result variable to see if your code is doing what you think it is doing. and read up on imagejpeg() to make sure it is doing what you think it is doing.

NZ_Kiwis

I did two SQL lines to make it easier for me to read.... if i echo $row[id]; it prints all the id's but only one picture.....

i want it to reszie the picture which is under $row5[url];

any more ideas?

NZ_Kiwis

I've looked everywhere... I want to resize these photos and show them everytime the pages loads... can this even be done??

Weedpacket

You need a page which provides <img> tags for all of the images, each with a src= attribute that calls this script with the appropriate IDs for it to generate the appropriate image.

But why on Earth would you want to do all this every time the page is loaded? Don't you think it would make a lot more sense to do all the thumbnailing once and file those thumbnails for use whenever they're needed?

NZ_Kiwis

Well what I have is a bunch of pics... I want to display them in different galleries... I have the URL stored in my SQL data but i'm sick of resizing them everytime i store more and have a thumb URL... is there a better way??

NZ_Kiwis

anyone?

ednark

why not, after you have added a new line to your sql, have the same file autogenerate the thumbnail files for you, and save it in the same directory as the file. the you know the file and the path, and don't need to alter your sql any, since the path to the main file will reveal the path to the thumbs. I think at this point im not quite understanding what your question is however, and I may not be answering it.

I originally thought that your script was trying to create and output several images at one all in the same file, which wouldn't work. If Weedpacket and I have not gotten you the answer you want then try explaining again very slowly what our problem is.

Weedpacket

ednark wrote:
If Weedpacket and I have not gotten you the answer you want then try explaining again very slowly what our problem is.

Which would be more polite than just a queue-jumping "Anyone?".