From:             [EMAIL PROTECTED]
Operating system: Debian
PHP version:      4.0.6
PHP Bug Type:     Arrays related
Bug description:  Problem with array_diff()

My site is a series of questions that users answer.  In order to track
which questions are answered and which are not I've developed two mysql
tables:

inever_statements which contains all the questions and their
"statement_id"
inever_answers which contains all the answers for each question from each
user

Because mysql doesn't have a method for doing isin queries I've instead
loaded two arrays.  One array contains the ids for all the possible
questions, the second array contains all the ids for the questions the
current user has answered.  By running array_diff() on these two arrays I
should be able to create a list of ids for questions the current user
hasn't answered.

This worked perfectly for quite a while.  However, the number of questions
is now near 600....  I can load both arays and use print_r() to verify the
contents of each.  However, running array_diff() fails if the user has
answered a single question.

Is this due to the large number of questions?  Is there perhaps a better
way to accomplish the same thing?

One thought I had was to break down the process into a number of smaller
comparisions, say limiting the query to 50 or 100 records.  Any other
suggestions would be appreciated.
-- 
Edit bug report at: http://bugs.php.net/?id=13169&edit=1


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to