One. Order by RAND() is not right. That is most likely DBMS specific. You may be doing this for private use, so I'll let that go for now. However, what is wrong is that it is not in quotes, instead you are relying on the PHP function rand(). Which I am sure is not going to work, right? Ah-ha! I get...

Here are two examples. The first, I'm sure is a syntax error on my part, but I can't find it! Error: SQL ERROR [ mysqli ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g.group_id = 9 ORDER BY u.username ASC'...

I'm building my own custom CMS using the phpBB core across different sub-domains (actually set up as subdirectories under the phpbb root). I've tried using the sql_build_query in the sub-domain setups, and it doesn't return anything after being passed through sql_query. The majority of the other dba...

I've read all of the documentation on the dbal at wiki.phpbb.com, a bunch of topics at various support sites, and the MySQL documentation, itself, but I'm still having problems with SQL queries within phpBB3. For example, I cannot use build_sql_query (and certain other non-SQL related functions) on ...

Thanks, guys.
I will strive to live up to your expectations. lol

Once I'm familiar with the code, I can lend a hand where ever you guys might need one.

Hello, all. I have been persuaded to join up over here.