Martin Norland wrote:
Jochem Maas wrote:

Martin Norland wrote:


while (($row = mysql_fetch_row($result)) || ($row = mysql_fetch_row($result2)))
// just do it. â

.. work (due to shortcircuiting)? and how ugly is it?

    // foo

That would work if you just wanted to iterate over both resultsets and do the same thing, yes. Say, if you had lists of users who signed up for something in two separate databases, you could print them all out with that. Since he said union and not join - that is probably his intention.

that was what I had in mind when it popped into my head :-)

I can't decide if that code is beautiful or horribly ugly though... I would have to say it's beautiful so long as the 'just do it' is very short - if the 'just do it' should be a function - then you should just suck it up and do two while's. Also, for every result in $result2, you have to poke at the first database and say "any more yet?", which is hackish.

slick 'obfuscated perl' entry type fix though :) [okay, it's not obfuscated in the traditional sense]

ok, I apprieciate your comments - its always good to get a experienced 'hackers' view on things. thank you Martin!


-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to