|
|
Posted by Rik on 07/22/07 11:17
On Sun, 22 Jul 2007 07:46:10 +0200, zach <wackzingo@gmail.com> wrote:
> Hi,
>
> I'm struggling to figure something out. What I have are thousands of =
=
> questions from 5 books of the bible in a database. The questions are =
> labeled with the book name, chapter, verse and type of question as =
> follows: X, B, G, A, M, R. I need to be able to select 11 questions of=
=
> the G type, 5 of A, 1 M, 1 R, 1 X, AND 1 B. I need to select them all =
=
> randomly and display them randomly. I want to give user the option to =
=
> change the range of books and chapter from which the questions are dra=
wn =
> from and the number of each type they want.
>
>
> I have this mysql code:
>
> "SELECT * FROM questions WHERE book IN ('Galatians', =
> 'Ephesians','Philippians') AND chapters IN ('G1', 'G2', 'G3', 'E1', =
> 'E5', 'P1') type=3D'G' ORDER BY RAND() LIMIT 11)"
Are you sure? I miss an ' AND ' before 'type'?
It should work IMHO, if it doesn't, ask in comp.databases.<name of your =
db>
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|