PHP5000

20000 thanks to each of you. I am not sure if my hosting company allows access to such settings mac_gyver this would be very helpful. I am yet to find a good hosting company with proper tech support and services. Barand it is not just for being pretty. On what planet we start the date with year? It is like starting an address with the country. That said, you been very helpful and you can start the date with seconds as far as I am concerned.

10000 thanks Barand I tried it and worked like a charm. As some of the replies suggested I set the format in mysql table as Y-m-d H:i:s . It might have certain advantages, but it looks like putting the cart before the horse to me so I prefer to show the result as d-m-Y H:i. however, when I try the code: $DD=$row["OrderDate"]; $FormattedDate = date_format($DD,'d-m-Y H:i'); print $FormattedDate; It shows nothing? Thanks in advance

Gentlemen, I had a theory for a while that the world around me is getting dumber (at an accelerated rate since 5 years ago), just as everybody is getting older and I am staying wondering about it. Now, I am beginning to give it a slight possibility that maybe I am not as smart as used to think I was, or I was. Please imagine that you are talking to an ignoramus, and do be kind enough to provide examples in code. I learn by only example despite several degrees in computer science and engineering ( yup, I am not kidding you). Thanks in advance and let's all of us enjoy less dizziness on a flat earth.

Thanks for the replies. What is the advantage of YYYY-mm-dd over dd-mm-YYYY ?

Hi all I have a mysql table called Ordertable, in it there is column where I save the date and time, by saving date("d.m.Y') I have made another column called OrderTimestamp which saves mktime($DD4), where $DD4 is date("H:i:s m.d.Y"); I have been trying to find a way to select the records created in the 24 hours before running the code without success. I have tried at least a dozen suggestions I saw on different websites including stockexchange (which to my experience is a complete waste of time). Apparently people who made those suggestions never actually tried them themselves. This can't be a complicated task, why is it not working then? Any idea how this can be done? Thanks in advance PS. The reason for 2 columns is the many different ways that I tried and none worked.

Hello I have been coding in PHP since at least 15 years ago, but there has been a gap for the last 4 years. Now many things that I had done perfectly well in the past does not work. For example /" which I used hundreds if not thousands of time when passing a string from a form to a database or vice versa no longer works. Example is: \"Your inquiry about our services\" Only the first word (Your) is kept, which is the first word before space. Any idea why? I have spent hours searching online through different forums and tutorials without any results. thanks in advance.