[SOLVED] Warning: mktime() expects parameter 6 to be long, string given in

[abs0lut]

<?php
$date1 = date("Y-m-d");
$query = mysql_query("SELECT closedate, topicstatus FROM topics") or die (mysql_error());
while($row = mysql_fetch_array($query)){
	$date2=$row['closedate'];
	$topicstat=$row['topicstatus'];
	$date1_array = explode("-",$date1);
	$date2_array = explode("-",$date2);
	$now =mktime(0,0,0,$date1_array[1],$date1_array[2],$date1_array[0]);
	$close =mktime(0,0,0,$date2_array[1],$date2_array[2],$date2_array[0]);
	if(($now>close) && ($topicstat==0)){
		$do = mysql_query("UPDATE topicsSET status=1") or die(mysql_error());
		}
	}
?>

please help me

[abs0lut]

oops, I forgot space.

<?php
$date1 = date("Y-m-d");
$query = mysql_query("SELECT closedate, topicstatus FROM topics") or die (mysql_error());
while($row = mysql_fetch_array($query)){
	$date2=$row['closedate'];
	$topicstat=$row['topicstatus'];
	$date1_array = explode("-",$date1);
	$date2_array = explode("-",$date2);
	$now =mktime(0,0,0,$date1_array[1],$date1_array[2],$date1_array[0]);
	$close =mktime(0,0,0,$date2_array[1],$date2_array[2],$date2_array[0]);
	if(($now>close) && ($topicstat==0)){
		$do = mysql_query("UPDATE topics SET status=1") or die(mysql_error());
		}
	}
?>

[JasonLewis]

All I can say is use print_r and echo to make sure all variables are being set properly.

[abs0lut]

what will I print_r and echo? could you please explain further?

[unkwntech]

I think he means:

print_r($date1_array);
print_r($date2_array);

Then verify that each item in the array is what it should be.

[abs0lut]

thanks, topic solved.