photo display in Viewlisting

[bgordon]

Originally Posted by Bucketman

I've got it working now, but if no title data is entered by the user it just shows as NULL. I have set the default value to No Title, but if I set it in MySQL to not null, it doesn't set any value to it, and I get the funny photo display problems. When I set to NULL, it does work, but as I said it just displays NULL, not No Title.

You can see it working on my site GoBuyItBrisbane - I've done a little customising and think it looks much better than the default way to show images in another popup window.

I'm happy to leave it with the NULL value for now as at least it's working - if anyone has some ideas they'd be much appreciated.

I just added an initial value to the Title text form field "Image Title" so at very least it has a title when submitting from the two templates. Low tech but it works.

[juven14]

Here is what I ended up doing (it requires developer):

I removed the original call for images and then called it myself (viewlisting.php):

removed:

PHP Code:

//get the images
$image=$Listing->getImages($view);
$class_tpl->assign('data', $image);


replaced with:

PHP Code:

//get the images
        $sSQL='SELECT id, pid, title, image, rank FROM '.PREFIX.'prodimages WHERE pid = '.$view.' ORDER BY rank ASC';
        $result=$db->query($sSQL);
        
        $i=0;
        while ($rs=$result->fetch())
        {
            if($rs['title'] == '')
            {
                $imageTitle = ' ';
            }
            else
            {
                $imageTitle = $rs['title'];
            }
            $image['title']=$imageTitle;
            $image['image']=$rs['image'];
            $size = @getimagesize('photos/'.$rs['image']);
            $image['width']=$size[0];
            $image['height'] = $size[1];
            $data[]=$image;
        }
        $class_tpl->assign('data', $data);


[Acpjax]

Ive recently implimented this change and it works however i get the done with errors message when viewed. When i pull the error up it said its a "Unterminated string constant" error.... Anyone else run into this? or did i just mess something up along the way

[Lhotch]

Originally Posted by Acpjax

Ive recently implimented this change and it works however i get the done with errors message when viewed. When i pull the error up it said its a "Unterminated string constant" error.... Anyone else run into this? or did i just mess something up along the way

What version of 68C are you running?

[Acpjax]

3.1.5 dev im gonna start from scratch and re- do it tonight as i messed around alot with this page and very well could have created an issue while i was playing with something else...

http://www.recreationalrentalsource....ing.php?view=6

is the page

[Lhotch]

Originally Posted by Acpjax

3.1.5 dev im gonna start from scratch and re- do it tonight as i messed around alot with this page and very well could have created an issue while i was playing with something else...

http://www.recreationalrentalsource....ing.php?view=6

is the page

This is the ver 3.0 forum and Bucketman is running 68C ver 3.0. It may not work properly with 68C ver 3.1.X

[Acpjax]

Aye.... I actually found this post linked from one in the 3.1 forums... :-) no worries i was just curious if anyone had run into the same error..

[juven14]

Looks like you got it. Let me know if you still need help.

[spaceboy]

anyone know if this code is good for v3.1... or where I might find a thread explaining how to create one large listing image on the viewlisting page with smaller thumbnails to the side or underneath thelarge image?