[PHP] string convertion to time & substracting

2002-06-07 Thread juaid
Well, I got all working now and calculating the duration with mysql functions The fields which which hold times are now TIME types, and everything works really good!!! Thanks again to all :) juaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
ays use the mysql_error() function... thanks again juaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
date" field in the table, where the format is like "Jun 7 2002" if I switch connTime, startTime and stopTime to TIME types, I get the error I said I'll try the things you've told me and the mysql_error() as Chris said thanks again, juaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
Thank you very much Erik, I'll try it :) anyway, it would be nice to know what's wrong with the code I posted, why does it work with CHAR and not with TIME types? juaid From: "Erik Price" <[EMAIL PROTECTED]> > > First of all, if you're storing time then y

Fw: [PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
note that I put: $startTime = $linea["startTime"]; I misppeled it while copying, this shuold be $startTime = $line["startTime"]; juaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
not a valid MySQL result resource in /var/www/text.php on line XX" what am I missing? the mysql_fetch_array should only be used with CHAR types and so? what should I use then? thanks again for the help juaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] convertion from string to time & substracting

2002-06-07 Thread juaid
00:00 = 90 I looked up at the doc in the php.net website and couldn't get on how to do this... should I use the strtotime function? anyone has donde something like this, or knows what functions could help me to do this? Thanks in advance, juaid -- PHP General Mailing List (http://www.ph

[PHP] Opening a page in the same window

2001-04-29 Thread Abdullah Al-Juaid
hello, How to open a page in the same window by means of PHP or JavaScript? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTE