Pull random images to php page...

[Daz wilde]

Is there a way to pull random images from my gallery to my home page which is a bog standard php page..

[Morgan]

http://www.photoplog.com/forum/showthread.php?t=10

[Daz wilde]

This is great but can i ......

Make them slightly bigger than what they display as?

Also grab them from a seperate category?

Cheers

[Morgan]

Please don't PM me support questions. Posting and PMing doesn't grab my attention or make me work any faster. As to your questions, change $photoplog_imgsize to medium or large and edit the query:
Content visible to registered users only.

[Daz wilde]

Apologies for the PM...

Great stuff it worked a treat.... how would these random images change though, or do they always stay to that image???

Also did you create this mod for cartplog???? I was wanting to do exactly the same for this mod also??

http://www.vbulletin.org/forum/showthread.php?t=161010

Thanks again

[Morgan]

1: Look for ORDER BY RAND() on this (http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html) page and edit the query.

2: You'll need to check the vBorg thread and see if there is anything there; nothing here for the cart.

[Daz wilde]

Sorry Morgan im not well up on sql querys i have tried several times could you help us edit this line so i can get the random working...

$query = "SELECT * FROM photoplog_fileuploads WHERE moderate = 0 AND catid IN (2) LIMIT 1";


I think thats the bit i need to edit.

[Morgan]

Add ORDER BY RAND() before LIMIT - there is an example on this (http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html) page.

[Daz wilde]

Morgan you are a legend!!!!!

Just need to try and do the same for the cartplog now!!!!!!

THANK YOU!!!

;)

[starmagh]

Content visible to registered users only.

+1
thanks !