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.