CodingForums.com - View Single Post

DanCorb · 11-24-2012, 10:06 PM

I have the following table:

ID Job Category
1 Clerk Admin
2 Secretary Admin
3 Typist Admin
4 Reception Admin

Now, I want to display 5 jobs within the Admin Category, but I want them pulled randomly from the database. ORDER BY RAND won't work because there are only 4 records. I need to display 5 records as it doesn't matter if the same record is displayed more than once. How do I do this?

11-24-2012, 10:06 PM	PM User \| #1
DanCorb New to the CF scene Join Date: Sep 2012 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts	Help with displaying random records I have the following table: ID Job Category 1 Clerk Admin 2 Secretary Admin 3 Typist Admin 4 Reception Admin Now, I want to display 5 jobs within the Admin Category, but I want them pulled randomly from the database. ORDER BY RAND won't work because there are only 4 records. I need to display 5 records as it doesn't matter if the same record is displayed more than once. How do I do this?