pcmansf

Thank you for looking into this! I need to use result from mysql query twice or more on a page Should I do this: $sql = mysql_query("SQL"); while ($row = mysql_fetch_assoc($sql)) CODE ... while ($row = mysql_fetch_assoc($sql)) CODE2 OR should I keep result of a query in an array and use FOREACH instead? My concern is performance.

You are indeed a genius! First number is the number of days since December 30, 1899 - Microsoft Excel's epoch date and the second number after the dot is a fractional number of seconds (0.864 seconds per digit). Thanks a lot for pointing me in the right direction!

Hi there, I'm using this data logger: http://www.omega.com/pptst/OM-CP-PRTEMP101.html Date time comes out of this device as this: 39400.82848 when I paste it to excel and change cell format to date/time this is what I get: 11/14/2007 7:53:01 PM. Does anyone know about this format? How do I convert this number to actual date/time? Device's manual says that date and time are stamped. I'm not sure what it means. Please help. Thanks a lot!