[Resolved] Unix Timestamp help??

furious5

I need to amend some existing code to search a table based upon the number of entries for that month and return a value e.g 300 jobs have been posted this month.

At the moment I am just returning the last date from the table, however I need to now look at this date and then create a variable and create a SQL statement to search inbetween the months.

Any ideas on how to best approach this?

The code I am using at the moment:

	// Connect To MySQL Server
	@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database
@mysql_select_db($database) or die("Couldn't Select Database");

$sql = "SELECT *, UNIX_TIMESTAMP(date) AS udate FROM job";

// Execute SQL and exit if failure
$sql_result = mysql_query($sql) or die('SQL Error');
$num_rows = mysql_num_rows($sql_result);
	if ($num_rows == 0){
		echo '<span class=general>Sorry your details did not match any of our records. Please return to the search page <a href=../login.php>here</a></span>';
		exit;
	}

	while ($row = mysql_fetch_array($sql_result)){
	$date = $row["udate"];
	}

	// Format & Print date
	echo date("d/m/Y",$date);

}

furious5

Ok seemed to have managed to sort the problem out, here is the code I am using

	// SQL query

$month = (int)date('m'); // Find the month

$sql = "SELECT COUNT(DISTINCT jobid) AS jobid FROM job WHERE MONTH(date)=$month";
echo $sql;

// Execute SQL and exit if failure
$sql_result = mysql_query($sql) or die('SQL Error');
$num_rows = mysql_num_rows($sql_result);
	if ($num_rows == 0){
		echo '<span class=general>Sorry your details did not match any of our records. Please return to the search page <a href=../login.php>here</a></span>';
		exit;
	}

	while ($row = mysql_fetch_array($sql_result)){
	$jobid = $row["jobid"];
	}

	echo $jobid;

}

The problem I am having now, is that when the calculation has been done I return a value like 922. Which is fine but I know this figure is wrong.

Having played around with it, it seems that the month is appended to the front of the calculation, thus there are only really 22 jobs posted.

Anyone any ideas how I can overcome this final hurdle??