20+ queries when posting

[chAos]

Code: Select all

<?php $sql1 = "SELECT userid, username FROM phpbb_users";

#- OR -#

$sql2 = "SELECT userid FROM phpbb_users";
$sql3 = "SELECT username FROM phpbb_users"; ?>

In this case the first one is more practical, although you already knew that.

PS. i'm already loving the syntax highlighting.

[psoTFX]

In this case the first one is more practical, although you already knew that.

Really?! My God, I'll rewrite all our sql immediately ... That's obviously not what I or indeed SHS` were saying. You can have multiple joins on tables doing complex comparisons across multiple fields which take an age to complete even with appropriate indexing ... meanwhile, the same query broken down into two or more queries may execute faster.

[chAos]

You know more about SQL than me, so i trust you.

On a lighter note, i've just been learning about the more advanced sql queries, like:

Code: Select all

SELECT w.*, u.* FROM phpbb_warnings w, phpbb_users u WHERE w.warn_userid = u.user_id

I think that should work.

Anyway, i've been proven wrong.

[dhn]

If you call that advanced Chaos, you still have a lot to learn (not meant as an insult). Wait till you get to joins.

[Aexoden]

At this point, when I write queries, I tend to write simple ones and then do processing in PHP. Of course, this isn't because that method isn't inherently better, but because the only SQL I know is what I learned from phpBB and a brief exposure to some kind of JOIN when I was doing something that I can no longer recall. I have yet to see the power of some of the more advanced SQL queries. Shame that the advanced queries tend to be the ones I remember phpBB naysayers complaining about. e.g. "Oh no! You're using a JOIN on your posts table. Ahhhh!" etc. So I really have no idea whether JOINS are useful to be used in the real-world environment. Must be time for a relational database theory book or something.

[Darkshines]

If you call that advanced Chaos, you still have a lot to learn (not meant as an insult). Wait till you get to joins.

That is a join, isn't it?

The thing that had me confused first time I had to do it was "Group by". Not that you need to use it all that much though.