DonPatricio

thanks

any other suggestion how to output 2008-02-04 00:12:22 -8 hours. The date is already formatted in the DB so that's why I don't know how to do that. Thanks

i don't really see how this can help me with my prob.

I got this date in my DB: 2008-02-04 00:12:22 I want to output this value - 8 hours. How do i do that. I tried this, but that obviously doesn't work: $date = mysql_query ("SELECT date from date_test;"); while ($date_output = mysql_fetch_array ($date)) { $date1 = $date_output[date] - (8*60); echo $date1 . "<br>"; }

Because they are a security issue.

maybe the mail() function is deactivated on your server?

Thanks. The now() function is really what I needed...

Ok, one more thing though. I got this function now. That should be fine right now: <?php $timestamp = time(); echo( date('l jS M Y, g:i a', $timestamp-9) );S ?> However, when I alter my system time on my computer the time on the website is altered as well. That was not really what I wanted to do.

Thanks both of you. The purpose of that is to program a PN-System like on this forum. When a message gets inserted into the db I really need the right time, because PN's from all over the world could be written and I need one standard time and that is my location. I hope I can figure all that out... Thanks a lot

well, i don't know anything about classes & object. i meant with basic programing knowledge that i know loops, variables and little bit more, but I don't know anything about OOP, which I guess that is, but thanks anyway

hmm, when i copy your code no time is being displayed.

hi, i got basic knowledge about php and javascript. however i have no clue about date/time function in php and javascript. what i want to do is to show the current time in my timezone. however, i want to display the CORRECT time and not the time on the computer on the bottom right. because everybody can change his system time and the WRONG time would be displayed. so, how can i display the CORRECT time of my pacific america time zone. is there a way to do that with the server time?? but i have no clue, please help me guys. thanks a lot.

Hello, I am trying to program a little social networking site and now I am at the point where I have to program a little, simple Personal Message System (Inbox and Outbox) as we see it at many sites like this forum for example. Do you guys have any idea how to approach that, because I have no no idea how to approach that yet. how are the messages stored? Database? Textfile? Is there maybe a little turial to get oriented how that is roughly going to work? I'd just like your inputs, Thanks, patrick

i think that i got it, thanks for all the help

ok, well reading from one table and inserting to another should work fine. I think I know what the problem is, but I don't know how to solve it. So, above you see the dump schema for references. When user admin requests to be friend with another user for example "admin5", the num_rows is >= 0 and nothing would be inserted. But something should be inserted! (In this case $username = 'admin' & $add_friend = 'admin5') However when a other user, not inserted in the db yet called "danny" for example wants to be friend with "pablo" num_rows would be <=0 and it would work. So, I think that the query has to be rewritten, but i actually don't know how to do this.