Very simple, Spot the not.

[ok]

yo!

 

$query = "SELECT invited_by, COUNT(*) AS total FROM users WHERE total=$total AND invited_by!='' AND date_check='0000-00-00 00:00:00' GROUP BY invited_by ORDER BY total DESC LIMIT 1";	

 

i used two AND there.

 

is that correct?

 

what is the not?

 

thank you.

 

 

[GingerRobot]

Perhaps it's just me, but i've absolutely no idea what your question is. What is the problem?

[ok]

the error is this,

 

Problem with the query: SELECT invited_by, COUNT(*) AS total FROM users WHERE total=3 AND invited_by!='' AND date_check='0000-00-00 00:00:00' GROUP BY invited_by ORDER BY total DESC LIMIT 1 on line 79
Unknown column 'total' in 'where clause'

[Mchl]

Can't use aliases in WHERE clause

Use "HAVING total = 3"

[gevans]

You can't set an alias for use in the sql query.

 

I think you want to use LIMIT

 

or run the query and check the number of results afterwards