= works fine but != messed up the query?

[sabret00the]

this is the query

PHP Code:

    $grps_newestmembers = $DB_site->query("
        SELECT grps_user.groupid,grps_user.userid, user.username, grps_user.join_date,grps_user.mod_queue
        FROM grps_user
        LEFT JOIN user ON (user.userid = grps_user.userid)
        WHERE grps_user.groupid = $groupid AND grps_user.mod_queue != 1
        ORDER BY grps_user.join_date DESC
    "); 


has php stopped supporing != overnight or am i just being stupid and doing something wrong?

[Natch]

PHP is fine with it, but SQL prefers NOT (iirc)

[Marco van Herwaarden]

Try "<>" instead of "!="

Lol a lot of different answers

IIRC "<>" is the official SQL notation, "!=" is added later i think (MySQL only???, what version??).

But what happens, you get an error, it don't function like expected?

[sabret00the]

Originally Posted by MarcoH64

Try "<>" instead of "!="

Lol a lot of different answers

IIRC "<>" is the official SQL notation, "!=" is added later i think (MySQL only???, what version??).

But what happens, you get an error, it don't function like expected?

still returning nothing

the table looks like this

groupid   	  userid   	  username   	  join_date   	  mod_queue
7 	10 	sabret00the 	1106842883 	1
7 	64 	user2 	1106661929 	NULL

so it should return the one with NULL in it, shouldn't it?

Originally Posted by MarcoH64

But what happens, you get an error, it don't function like expected?

no error it just returns no data

[Marco van Herwaarden]

Are you 100% sure that $groupid contain "7"?

What are the fieldtypes?

Are these userid's in the user table?

PS you could try running it without the test on mod_queue to find where the error is.

Edit try changing that NULL value to 0.

[sabret00the]

groupid is definately 7
fieldtypes, oh mod_queue is set at tinyint(4)
the userid's are in the grps_user table
it works without the mod_queue clause, it's just that that's causing the problem?
even with NULL set as 0 it don't work?

[Dean C]

Change this:

PHP Code:

 $grps_newestmembers = $DB_site->query("
        SELECT grps_user.groupid,grps_user.userid, user.username, grps_user.join_date,grps_user.mod_queue
        FROM grps_user
        LEFT JOIN user ON (user.userid = grps_user.userid)
        WHERE grps_user.groupid = $groupid AND grps_user.mod_queue != 1
        ORDER BY grps_user.join_date DESC
    "); 


To this:

PHP Code:

 echo("
        SELECT grps_user.groupid,grps_user.userid, user.username, grps_user.join_date,grps_user.mod_queue
        FROM grps_user
        LEFT JOIN user ON (user.userid = grps_user.userid)
        WHERE grps_user.groupid = $groupid AND grps_user.mod_queue != 1
        ORDER BY grps_user.join_date DESC
    "); 


Show us what it outputs to the browser

[sabret00the]

SELECT grps_user.groupid,grps_user.userid, user.username, grps_user.join_date,grps_user.mod_queue FROM grps_user LEFT JOIN user ON (user.userid = grps_user.userid) WHERE grps_user.groupid = 7 AND grps_user.mod_queue != 1 ORDER BY grps_user.join_date DESC

[Dean C]

Ok we have some issues with your database model here. You have some data redundancy in the fact you have the username column in this grps_user table. Drop that column as you can get the users username via a join on the userid column. Also change the fieldtype of the mod_queue column to smallint, lenth 1, unsigned and default 0. Then try your query :up:

[sabret00the]

oops, that username was never apart of the grps_user column

here's the table straight from phpmyadmin

 recordid   	  groupid   	  userid   	  join_date   	  mod_queue
Edit 	Delete 	4 	3 	10 	1102848936 	NULL
Edit 	Delete 	3 	2 	10 	1102848632 	NULL
Edit 	Delete 	13 	6 	10 	1106781470 	NULL
Edit 	Delete 	12 	3 	64 	1106777848 	NULL
Edit 	Delete 	9 	2 	64 	1106568571 	NULL
Edit 	Delete 	10 	7 	64 	1106661929 	NULL
Edit 	Delete 	14 	6 	64 	1106781499 	0
Edit 	Delete 	16 	7 	10 	1106842883 	1

now i just ran a query to change al them nulls to 1 and it never worked, i think theirs something seriously wrong with the mod_queue column

i'm gonna try and delete it and reinstall it, as i have no idea why it won't work still.

works fine now changed it to in_mod_queue just to be safe and it's working fine.

thank you everyone, sorry to waste your time.