ramli

I want to select multiple mysql encryted and non-encrypted values and decrypt them for usage: [code] $Query = mysql_query("SELECT AES_DECRYPT(adres,'$key'), AES_DECRYPT(zipcode,'$key'), * FROM userspersonal WHERE ID ='$relationid'"); while($r = mysql_fetch_array($Query)) { $adresdb = $r['adres']; echo($adresdb); } [/code] As you can see i want to select two values and decrypt them and then i want to select the remaining fields in de table. Then i use mysql_fetch_array to put them i a array. I dont seem to get it to work, any help pleace ?

clould you help me with a solution pleace ?

I want to calculate a total time using the following script: [code] while($r1 = mysql_fetch_array($Query1)) { $difference = $r1['difference']; // time in format 15:15:30 $difference = microtime($difference);  // Transorm to milliseconds $verschil = $verschil + $difference; //Add differance of every record to the total difined as $verschil } $seconds = floor(($verschil)); //calculate seconds of the total $minutes = floor(($verschil / 60)); //calculate hours of the total $hours = floor(($verschil / 60) /60);//calculate seconds of the total [/code] where difference is a database object in the format 00:00:00. I dont seem to get it to work wat am i doing wrong ? Thanx in advance....