arjdat

ED IN AD IN OUT DIFF 12:20:00 12:10:00 12:23:00 00:00:00 when i use integer format, diff column gives exact result i.e. out-max(edin, adin); when i want them in time format it does not work; like in the example given above, diff should be 00:03:00 or even better 00:03 (omitting the second part and giving only hr; mm). below is the code i use for getting the value and put into diff column if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO chk (edin, adin, `out`, diff) VALUES (%s, %s, %s, %s)", GetSQLValueString($_POST['edin'], "date"), GetSQLValueString($_POST['adin'], "date"), GetSQLValueString($_POST['out'], "date"), GetSQLValueString($_POST['out'] - max($_POST['adin'], $_POST['edin']), "date"));

columns are in datetime format; i did most of job in dreamweaver including the connection and form to insert values and showing the result in table by dynamic table; so the codes are not written by me but by dreamweaver itself.

i have a db table with four columns: adin, edin, out and diff first three columns' values are inserted manually. i want the diff column to show difference between out time and maximum of edin time and adin time and insert the record into diff column in my phpmyadmin.

i have the following php code to find image's dpi <?php function get_dpi($filename){ $a = fopen($filename,'r'); $string = fread($a,20); fclose($a); $data = bin2hex(substr($string,14,4)); $x = substr($data,0,4); $y = substr($data,4,4); return array(hexdec($x),hexdec($y)); } print_r(get_dpi('C:/tv1.jpg')); ?> how do i use this to find all images' dpi in a folder and output to html? thanks in advance

thanks to all of you. since i am using windows i have to work with the power shell thing only and the standard applications available in the market were tried but did not serve us totally.

hi i am an absolute newbie in this thing. i have a phpmyadmin table with columns name, date and time of copy. is it possible with php code that if a new file comes into a folder the code automatically inserts its name and the date and time of copy (not the creation or modification time, but the time it was copied in that folder) into my database table? i need the list to retain the names even if the file is moved from that folder or deleted. if a file with same name comes twice (after it was deleted) the entry should be twice. also a text log generation of the same listing would be great. many many thanks in advance