|
|
Posted by zach on 07/22/07 11:35
Rik wrote:
> 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
>> drawn 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='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
Rick, your right, I should have copy and pasted but I was didn't feel
like opening the document again.
I added the 'AND' in there but notice how I run the same query but
change the "type='G'" to "type='A'" and I change the number "LIMIT" to
5. I then use a 'while loop' with 'mysql_fetch_array() to print out the
results to the screen. The problem I have is that I use a loop for each
query run and the result is 11 of type='G' printed followed by 5 of
type='A' printed to the screen, all in a row. I want the final result
from all the six queries to be printed to the screen in random order.
$sql = "SELECT * FROM questions WHERE book IN ('Galatians',
'Ephesians','Philippians') AND chapters IN ('G1', 'G2', 'G3', 'E1','E5',
'P1') AND type='G' ORDER BY RAND() LIMIT 11)"
$sql2 = "SELECT * FROM questions WHERE book IN ('Galatians',
'Ephesians','Philippians') AND chapters IN ('G1', 'G2', 'G3', 'E1','E5',
'P1') AND type='A' ORDER BY RAND() LIMIT 5)"
Navigation:
[Reply to this message]
|