How to do a MySQL query with multiple WHERE requirements

[champbronc2]

I have this:

 

$checkpemaile = mysql_query("SELECT * FROM users WHERE referer=''");

$pemail_existe = mysql_num_rows($checkpemaile);

 

What I want is this (roughly, since the problem is that I do not know how to code it correctly!)

 

$checkpemaile = mysql_query("SELECT * FROM users WHERE referer=''");

AND WHERE visits>='4*(currentdate-joindate)'")

$pemail_existe = mysql_num_rows($checkpemaile);

 

So what I want it to do is make $checkpemaile not just the number of users whose referer is blank but also must have their visits greater than or equal to the number of days they have been a member.

 

So I need the script to $checkpemaile to meet both requirements.

 

So, if anyone can re-write it correctly it'd be greatly appreciated.

 

I have JUST started php and MySql.

[paulim]

What you need is something like this :

 

select * from users where 
referer='' and 
DATEDIFF(NOW(),joindate) > 0

[champbronc2]

If I am correct, all that means is that their days are more than 0.

 

That's not the issue.

[fenway]

Say what?