CpHpristian

It's for a webshop. I wanted to show the user the time he bought the item in his time zone.. not the server time zone. So I guess your second solution would work. How can I retrieve the timezone?

date() gives me the server-time, right? How I can set the date for the user's local time?

Thank you! Apparently I am too stupid to put my SQL-query into the DATE_FORMAT. So I had to use date() instead.

How can I convert a SQL timestamp (e.g. 2009-06-12 20:23:26) into a nicer format like dd-mm-yyyy? Thanks for your help!!

Both IE and Firefox are doing the same thing.. :-\

OK. So it worked on my computer at home.. .. but now it's getting mysterious. I transfered the same files to the XAMPP machine at school.. and the special characters were all garbled again. I tried everything - other than setting the browser to UTF-8 manually after every page click nothing helped. Then I created a php-file at school, using the same header. And the special characters were just fine. Then I opened two editor windows.. both had the exact same content (!!) but different file names.. in one window the characters were garbled and the other one was fine. ??? At home I used dreamweaver and at school the editor.. but after copy/pasting the content should have been just the same. I am so confused.

It works! Thank you so much, thebadbad!

What's interesting is that the special characters submitted by my HTML-forms look funny in the database but correct when readout. Hm. I need help here!!

I tried UTF8_general_ci for the collation and included <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> in my php-file.. but it doesn't work.

I know that the problems with special characters have probably been discussed a thousand times.. but I couldn't find a satisfying solution yet. Whenever readout stuff from my database, it doesn't display German special characters like ö and ä and so on. The php-echos just work fine.. what can I do?

I'm using a SQL-Update QUERY.. $res = mysql_query("UPDATE user SET V_Name='$_POST[v_name]', N_Name='$_POST[n_name]', Passwort='$_POST[passwort]', Email='$_POST', Admin='$_POST[admin]' WHERE U_ID='$_GET[iD]'"); I guess with UPDATE every variable will be updated, even if it is the same value. Is there a way to tell how many values acutally got changed? Thank you so much!