[SOLVED] select query

[timmah1]

I have a table in the database named posted in the date format 0000-00-00

 

Is this possible to do?

<?php
$month = date("m");

$query = "SELECT * FROM charts WHERE username = 'admin' AND posted = '".date("m", strtotime($month))."'";
				$chart = mysql_query($query);
                                        $numorws = mysql_num_rows($chart);
					if($numrows == 0){
						echo "nothing";
					}
				while($charts = mysql_fetch_assoc($chart)){
				echo $charts['id']."<br />";
				}

?>

 

It is returning "nothing", even though there are two items in the db with the posted being

2009-01-14

2009-01-19

[JonnoTheDev]

Should be

$query = "SELECT * FROM charts WHERE username = 'admin' AND MONTH(posted) = '".date("m", strtotime($month))."'";

[timmah1]

It is still coming back with "nothing"

[timmah1]

I got it to work using

$query = "SELECT * FROM charts WHERE username = 'admin' AND MONTH(posted) = '$month'";

 

Since I already declared the month value above

 

Thanks niel

[JonnoTheDev]

Ah, you are using strtotime for no reason

use:

$query = "SELECT * FROM charts WHERE username = 'admin' AND MONTH(posted) = '".date("m", time())."'";

[phparray]

neil.johnson is correct you are using strtotime for no reason.

 

You also are using the wrong date parameter to set the month var.  Use

 

$month = date('n'); #this is the equivalent to mysql month()

$query = "SELECT * FROM charts WHERE username = 'admin' AND month(posted) = ".$month;

 

 

[timmah1]

phparray,

I'm using the correct var for the month

<?php
date("m");  #numerical representation of month WITH leading zeros
date("n");  #numerical representation of month WITHOUT leading zeros
?>

 

And if you look at my first post, there are leading zeros

 

Thanks Neil for the help

 

[phparray]

date("n");  #numerical representation of month WITHOUT leading zeros

And if you look at my first post, there are leading zeros

 

Exactly - using the mysql function month() will output from a date field WITHOUT leading zeros.  So using the php function date('n') will be a direct comparison to month(posted) on your table.