wierd date stuff

Discussion in 'PHP' started by red_fiesta, May 2, 2007.

0
  1. #1
    This returns the player ids but not the trainingdates, why?

    
   	<?

	    
		$strSQL5 = "SELECT  distinct Training_Date, Player_ID from trainingattendance WHERE Training_Date between '01/".date('m/y')."' and '31/".date('m/y')."'";
	
		$Conn=mysql_connect("localhost","*****","*****");
		mysql_select_db("*****",$Conn);
		$result5 = mysql_query($strSQL);	
		
	 			
?>
<? print $strSQL5; ?><br>
<? while($row5 = mysql_fetch_assoc($result5)){

 print $row5['Player_ID'];
 print $row5['Training_Date'];  ?>
<? 
}
	mysql_close($Conn); 
		    ?>
    Code (markup):

     
    red_fiesta, May 2, 2007 IP