Numerous Questions Regarding MySQL and GD. Easy stuff I think...

[FoxhoundX]

Alright, I have two questions. One about MySQL, two about GD.

1. (MySQL) Is there a way to grab a random field from a database, where a certain clause is correct?

For Example, if I wanted this..

SELECT * FROM users WHERE posts='150'

Could I do that query, and return one RANDOM result?

2. (GD) How would I go about assembling numberous pictures together? They are the same size (Length and width), and I would like it so they are touching, and go one by one.

3. (GD) Is there a way to draw a border around an image through GD?

4. (GD) Also, is there an easy way to check if my host has GD Enabled? O.o

[mykg4orce]

RE: 1. You can get the id(s) of the rows that match your criteria then use a random routine to select a random number from the returned id(s). After your routine randomly picks a id number go back and fetch that row.

or you can do this:

SELECT * FROM users where post=150 ORDER BY RAND() LIMIT 1; (prolly a lot easeir) 😛

RE: 4. <?php phpinfo(); ?> will give you all the info you need about your php and all the different modules installed on your server.

[Weedpacket]

2) [man]imagecopyresampled[/man] will do resizing; it's up to you do do the programming to assemble the images.

3) Yes. One of the other listed [man]image[/man] functions is an obvious place to start.

PS: That's four questions 🙂