kirankumer

Hello Friends.. I tried to open my site using https (SSL layer) ,but its not opening in my browser... I need to know what will be the process to get secured my site.. Please post your replies ... Thanks

Thanks Guys for your help...i solved the problem

<?php // your database connection settings.. $conn=mysql_connect("localhost","root"," "); echo "<table>"; echo "<tr><td><b>channelid</b></td> <td><b>channel</b></td> <td><b>current users</b></td></tr>"; $qry="select chanid, channel, currentusers from denora.chan where mode_ls =Y order by chanid desc limit 0 ,10 "; $data =mysql_query($qry); while($row=mysql_fetch_assoc($data)) { echo "<tr><td>".$rec['channelid']."</td> <td>".$rec['channel']."</td> <td>".$rec['currentusers']."</td></tr>"; } echo </table>; ?>

Thanks Guys for your valuable replies... Really that's good idea to calculate ....,If i take another column "depart_punch_time" it will be easy for me to calculate timings ..... But we have a finger print device, this software unlocks the door when an employee punches, so at every time record will get inserted for every punch ( means door opens when i punch, if punch is not taken properly it will give warning message ) thats the reason till now we dint get the situation like " missing punch ".... I tried this problem by using " for loop " . If i have a fixed number of punches then i can get using for loop but here i dont have fixed punches in a day....I think am missing some logic , please help me how to calculate in this way (with out depart_punch_time ).. :'(

Actually my question is. I have database with table called "attendance".. Userid Date Punch_time 1 01-01-2012 09:00 am 1 01-01-2012 09:15 am 1 01-01-2012 11:02 am 1 01-01-2012 12:59 pm 1 01-01-2012 15:55 pm 1 01-01-2012 17:59 pm 2 01-01-2012 09:10 am 2 01-01-2012 10:45 am 2 01-01-2012 01:02 pm 2 01-01-2012 18:02 pm like this for every employee and for every day records will be inserted in " attendance " table ... Now i want to calculate timings of an employee inside and outside office ..... In coding language for employee userid 1 first punch is inside (09:00) , 2nd punch(09:15) is outside and 3rd punch(11:02) is inside and so on.... Now i have to calculate how much time he's inside office and outisde office in PHP Hope now you understand my question ..

Hello Guys, Please explain me how to add these timings of an employee(These are punch in and out timings of an employee) .. 1 2 3 4 5 6 7 ..................... 09:00 09:10 09:15 09:20 09:25 10:30 11:11 ........... I want to store in timings and out timings separately ... like in_timings =( 1st + 2nd ) punch + (3rd + 4th ) punch + (5th + 6th) punch ..... out_timngs =(2nd + 3rd ) punch + (4th + 5th ) punch + (6th + 7th ) punch ..... I am trying it in php ... Please give me any ideas ....Thanks in advance