View Single Post
  #2 (permalink)  
Old 03-11-2008, 04:42 PM
activeco activeco is offline
WebProWorld Veteran
 

Join Date: Jul 2004
Posts: 972
activeco RepRank 2
Default Re: mysql php - help needed

SELECT * from MyTable where date_of_birth = CURDATE() and where EXISTS (SELECT email FROM mytable);

should work.
Also you could try ...and where email <>"";

or something in that line.
__________________
Vote Hussein, vote humanity

Last edited by activeco : 03-11-2008 at 04:49 PM.
Reply With Quote