Help

[fragmentation]

i know everything is right above this point but why if i echo $empty_check it gives a value of zero when there where post made in the last hour...
am i doing this wrong or is there a syntax error...

$get = date("YmdHis");
$get_this = 10000;
$now = $get - $get_this;

//check to see if there are any fields that where made in the last hour

$sql_empty_check = mysql_query("SELECT * FROM database WHERE posttime >= $now");

$empty_check = mysql_num_rows($sql_empty_check);

//if they where created then carry out rest of functions

if(($empty_check > 0)){

[diego25]

Try this instead:

$get = time();
$get_this = 60*60;
$now = $get - $get_this;

//check to see if there are any fields that where made in the last hour

$sql_empty_check = mysql_query("SELECT * FROM database WHERE UNIX_TIMESTAMP(posttime) >= $now");

If that doesn't work, what's the data type of posttime?

Diego

[fragmentation]

i will check this out later tonight to see if it works cause i dont have time now however if it does make a difference the posttime is set up the same way i was making the date should i just use the time as now() when subiting if this does make a difference

YmdHis

[diego25]

Why aren't you using a date type for the posttime column? You should be...

Diego

[fragmentation]

okay either i have no idea what you mean or i have no idea what you mean.... i am a little new to coding php and mysql could you point me in the direction where i can learn about this data type or explain.... or am i just misunderstanding what you mean by data type for the post time

[diego25]

To create the database table,you had to do a
CREATE TABLE some_name (fields)

right?

You created posttime as VARCHAR or TEXT I think...but there is a type called DATE that you can use to handle dates better...

Diego

[fragmentation]

alright thanks a lot i think that would help... now that you explained it i know what you are talking about... i will see how this works..thanks