Menu

#5 Shared

LearnLoop_1.x
open
nobody
None
5
2005-03-29
2005-03-29
Anonymous
No

There is a sql error on this command:

$users=mysql_query("SELECT DISTINCT u.* FROM
users u,wp WHERE u.active=1 AND u.id<> ".$person
["id"]." ORDER BY u.firstname ASC, u.surname ASC;");

Don't exists join on the tables: users and wp.
When this scritp is executed, my server was braked,
blocking others users for new connections.

These tables are the bigger tables from database, with
15,000 and 17,000 records, respectively...

My question: how is the purpouse with this command?

I'd looked for this command on all php files.
It's used on:
- calendars/shared/users.php
- groups/admin_users.php
- homepages/shared.php

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.