clause
| From: | Jeremy Morano | Date: | Mon, 27 Aug 2001 18:52:54 +0000 |
| Subject: | clause | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64678@lists.php.net to get a copy of this message | ||
Hi,
Can somebody help me out?
My where clause is completely being ignored.
More specifically the <>. I tried to use != and that didn't work either.
However, when I substitute it with an = , It fuctions correctly.
Right now, the output is all the users.uid and all the users.username from
the table users.
H E L P !
$connection = @mysql_connect("l", "c", "c") or die("Couldn't
connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
$sql = "SELECT distinct users.uid , users.username
FROM users, picks
WHERE picks.users_uid <> users.uid
";
$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$uid = $row['uid'];
$username = $row['username'];
$option_block .= "<option value=\"$uid\">$username</option>";
}