ankycooper

Hey Thanks for replying... But How did you get the number.....24192000. i want to pull up $months intervals.... $months can be 10 Months or 1 Month Or 12 Months ... I mean Anything Looking Forward For help

hi ??? I Have a table named prop_tbl with a lot of feilds, one of the feilds is create_date which stores the timestamp of the record creation. Now i want to pull up the records which are x months old. please help $months=10; $nowstamp=time(); $expirestamp=strtotime("-$months month",$nowstamp); "SELECT * FROM prop_tbl WHERE create_date<='$expirestamp'" but it simply thows all the records Please help I just want records whose create_date is greater than equal to $months

as per the time stamps the difference is more than 10 hours so more than 600 min but it does not give the desired results Please Help

Sorry There was a Typo But still The Result is absurd <?php $f_clkin=1183405223; $f_clkbrkin=1183405451; $f_clkbrkout=1183440836; /// set here $f_clkout=1183441924; // and here:: why are you setting this 2x? $t1=$f_clkbrkout-$f_clkbrkin; $t2=$f_clkout-$f_clkin; // $f_clkout .. not defined in this code piece $min=$t2-$t1; $min=$min/60; ?>

I'm calculating Time Difference (in min) and it is giving me a absurd value $f_clkin=1183405223; $f_clkbrkin=1183405451; $f_clkbrkout=1183440836; $f_clkbrkout=1183441924; $t1=$f_clkbrkout-$f_clkbrkin; $t2=$f_clkout-$f_clkin; $min=$t2-$t1; $min=$min/60; So Now $min has a value of 21.933333333333 min How is it possible?? am i doing something wrong.... :-\ :-\ Please help

Hi i have installed PHP 5.2.2 and Mysql 5.1.18 Beta. now on evey php page i get Error in my_thread_global_end(): 2 threads didn't exit it listed as a mysql bug and there is a patch for it but i cant find the download and install instructions for it Please Help

Time Keeping System Can u Suggest me some Time keeping and attendence PHP application

Hi I'm Making a basic Clock In Clock Out Application In which every employee Has an Emp ID/username When he comes to the office he needs to do clock in if he takes a break he need to do break in and break out when he returns from the break finally clock out when he leaves for the day the table is something like this shift is the date of the shift, username=empid, nameemp=name header=(woff, Leave, Working), clkin=clockin_timestamp, clkbrkin=breakin_timestamp, clkbrkout=breakin_timestamp, clkout=clockout_timestamp, hours=no of hours excluding break and comments will have a leave Id if on a leave table 1 pid | shift | username | nameemp | header | clkin | clkbrkin | clkbrkout | clkout | hours | comments Now if the employee works after 00:00Am the date will change and will not look for the old rec....Its confusing Also The user can apply leaves and the admin can approve them table 2 lid | username | name | fdate | edate | reason | status if the manager aproves the following should also create a leave rec in table 1 also the user table has a feild woff=weekly off which should also create a rec for the emp if a weekly off Please give suggestions, links or example apps Thanks

hi i have 2 time stamps i want to calculate the Difference in minutes please help Thanks In Advance

hi my system clock is in IST but My php code gives an output in GMT/UTC how to set my timezone in php.ini there is date.timezone = i tried +5.5 and also IST but none of them work Need Help

Hi Is there a class or a script by which i can let users upload thier excel data to mysql. if the record already exists it will update it Thanks

hey the following gives me time in GMT Code: $today = date("F j, Y, g:i a"); However my time zone is IST and and my Machine is SET To IST Please Help 

hey the following gives me time in GMT [code] $today = date("F j, Y, g:i a"); [/code] However my time zone is IST and and my Machine is SET To IST Please Help

I Think no one is a real Guru Who can solve this

Please Help