Date: 11/29/05 (PHP Community)    Keywords: php, sql

I've been working on a random sql row script, but I am sort of stumped at the last part...

Since I am not familiar with php, I have been trying to learn by reading up on the functions, and looking at the code for different scripts that sort of do what I want, and seeing if I can merge them together to fully do what I want (I apologise if this is a bad thing, but it helps me learn ... u_u)

Anyway, the script is pretty much a "random cast"... Similar to how the Livejournal Quizzes are (only this will be used with vBulletin). Type in how many fields you want, type in the name of the characters/whoever, select their gender, and it results in randomly selecting a person from the appropriate table. I have the first two, but I haven't attempted to do the gender specification yet -- however, the last one is what gives me trouble. It will display a random entry, but it will be the same entry for all the fields, like this:

Boogeyman is played by: Name#1
Scarecrow is played by: Name#1
Dorothy is played by: Name#1

I found a way to display three different entries, however, it will display the three different entries beside just one name/custom field like this (as an example):

Boogeyman is played by: Name#1Name#2Name#3
Scarecrow is played by:
Dorothy is played by:

I apologise if this seems vague, but since I am not very knowledgable I'd feel stupid trying to explain myself like I'm an expert D: I have been trying to figure this out on my own for a few days and seem to keep hitting the same dead ends. Does anyone have any ideas?

I appreciate any help. Thank you in advance. :)

Source: http://www.livejournal.com/community/php/371094.html