Mike SD

Thanks Its a scheduling program that I import into a MySQL database The login passwords are being encripted Im trying to use the programs login information in the online version (Im not trying to hack anything) I have gone back to the person who told me it was SHA1 Hopefully he can clarify this

I asked for the encryption type used in a program, the answer he gave was: "It uses SHA1 with the following 5 magic keys" One of the keys is: 98badcfe I have been searching google trying to find a way of implamenting the magic keys, but I cannot find any information on them at all

Hello Everyone Does anyone know how to use Magic Keys in a SHA1 encryption? I can use the SHA1 encryption (please see below) but I have been given 5 magic keys to use and I dont know how to use them $str = 'test'; echo sha1($str); Result: test = a94a8fe5ccb19ba61c4c0873d391e987982fbbd3 Thanks for your time

Thank you so much This has made me very very happy I have run a test and it converted the data back to a serial date successfully I will add it to my script and let you know if I encounter any problems Thank you

Thanks How would that formula go? Ive tried creating one based on the original formula you provided, but I was unsuccesfull (sorry if im being cheeky)

I was wondering Is it possible to convert from dd/mm/yyyy format back to a serial date?

A serial date is a date with a general formatting in Excel 08/05/2009 = 39941

Fantastic I have been searching the internet all morning for an answer to this one Thank you very much

Hello all Does anyone know how to use PHP to convert a serial date into a normal date format like dd/mm/yyyy?

What code do you need? To import my .csv into my database I use: $sql = 'LOAD DATA LOCAL INFILE \'temp/schedule.csv\' REPLACE INTO TABLE `table` FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' ESCAPED BY \'\\\\\' LINES TERMINATED BY \'\\r\\n\' . ' '; $result=mysql_query($sql); To to display the data by date I use: $sql="SELECT * FROM $tbl_name WHERE DateStart <= '$filter' && DateEnd >= '$filter' ORDER BY ResourceName ASC"; Does this help?

$_P0OST You have a 0 in your $_POST This may be causing the problem

Hello Everyone I was hoping someone could help me with a PHP MySQL CSV problem I am trying to create an online add-on for a program I use called ScheduleIt I export all of the data from the ScheduleIt program as a .csv file and import this into a MySQL database, then use PHP to display selected data The problem I am having is with the dates When exporting the data as a .csv file it exports the dates as general formatted text (2009/05/05 becomes 39938) I can open the .csv file in Excel and format the cells using a custom format (yyyy/mm/dd) then upload the data to my database But I want to eliminate this section I am trying to create some sort of code to format the dates It does not matter when the dates are formatted, all I want to do is search the database for a chosen date Does anyone know how this can be done? I have been searching the internet for weeks and have made no progress Thank you for your time Regards Michael