Re: Calculate elapsed time between 2 time/dates
you can use any programmin language to manipulate... i did the following in PHP... //### // Function to calculate remaining days, hours, minutes and seconds between current date and end date.. // Returns the remaining time .. in days or hrs or mins or secs... //### function CalRemTime($ClosingDay,$ClosingMonth,$ClosingYear) { $ClosingTime = mktime(24,60,60,$ClosingMonth,$ClosingDay,$ClosingYear); $TimeDifference = $ClosingTime - time(); $RemainingDays = ($TimeDifference - ($TimeDifference % 86400)) / 86400; $TimeDifference = $TimeDifference - ($RemainingDays * 86400); $RemainingHours = ($TimeDifference - ($TimeDifference % 3600)) / 3600; $TimeDifference = $TimeDifference - ($RemainingHours * 3600); $RemainingMinutes = ($TimeDifference - ($TimeDifference % 60)) / 60; $TimeDifference = $TimeDifference - ($RemainingMinutes * 60); $RemainingSeconds = ($TimeDifference - ($TimeDifference % 1)) / 1; if($RemainingDays>0) { $sValue = "$RemainingDays days"; return $sValue; } else { if($RemainingHours>0) { $sValue = "$RemainingHours hrs:$RemainingMinutes mins:$RemainingSeconds Secs"; return $sValue; } else { if($RemainingMinutes>0) { $sValue = "$RemainingMinutes mins:$RemainingSeconds Secs"; return $sValue; } else { if($RemainingSeconds>0) { $sValue = "$RemainingSeconds secs"; return $sValue; } else { $sValue = "Bidding time is over..."; return $sValue; } } } } } Shankar -- --- Roger Baklund <[EMAIL PROTECTED]> wrote: > * YC Nyon > > I need to get the time/date (ie. 1 day 12 hours 11 > min 4sec) > > between 2 time dates. > > Can't seem to find any of these functions in the > Mysql manual. The nearest > > was Period_diff() which is calculating months > elapsed. > > I don't think you can do it directly, you have to > split the day and time > part, and calculate the two things separately: The > number of days between > the two dates AND the difference in the > HH:MM:SS-part of the two dates. > > HTH, > > -- > Roger > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Testing the Server Load
Dear All, we have developed a web-based application for a client and now in its testing phase by next week... It uses Linux/PHP 4/MySQL 3.23 As the volume of user will be more, we are very much concerned about the server efficiency and our application efficiency/performance... Following are the one we need to database server... 1. server performance 2. the database load 3. efficiency query 4. execution time 5. how many inserts/updates taking place 6. volume of data involved and so on... Is there any tools available for this? Any idea about testing the mysql server? Thanks a lot. Shankar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server load
hi we have developed for a client and now its testing phase by next week... using Linux/PHP/MySQL 3.23 we need to test the database load... like how efficienty query is executing... how many inserts..updataes taking place...etc... how much the data etc... is there any tools available for this? any idea? Shankar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LIMIT problem when no record
Hi, i faced a problem when using LIMIT clause in select statement.. select * from Discussion Where ParentID=x Order By DatePosted Desc LIMIT 1 iam using the above select statement inside a loop where ParentID varies... when u run that program, suddenly mysql stopped and said mysql-opt error then i found out that when there is no record with the above criteria, it is giving error and mysql stops abruptly... when there is no record and if i remove LIMIT clause, then no problem.. fine... but i donno when there will be record or when there won't be as i am running inside loop... any idea? Shankar __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing diff format date to MySQL
Hi, I have data in CSV format file which has a date value in the format 'dd/mm/yy'? When i used 'Load data...' to import to a MySQL table, all the fields gets the value from the file except the date field that contains the date of birth?? is there any way to format and import??? Thanks Regards Shankar __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing data from Oracle
Hi, I am having two servers running Oracle and MySQL database. Views has been created for me in Oracle and I want to import data from that Oracle table to my MySQL table. I want a script like something main thing is I want to import data from that Oracle database to MySQL daily...like a scheduled job.. The mysqlimport statement imports data only from text filesbut in my case i want to run a scheduled script that imports data from Oracle to MySQL at a specified time... I am using MySQL version 3.23.22 Is there any tool available for free or any other way to do this..Please help me. Shankar __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error: Transactions are not enabled
Hi, I am using Visual Basic application to insert and update records in MySQL database. MySQL 3.23 is installed in Windows 2000 Server. I am running my VB application from my Windows 95 machine with MyODBC 2.50 for Win 95 installed in my machine. I have used the provider for the connection as follows: Set gcnMMLS = New ADODB.Connection With gcnMMLS ' Thru' Provider .ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=MMLSConn" .ConnectionTimeout = 300 .CursorLocation = adUseClient .Open End With .. While saving the record i have used transaction for the connection object as follows: .. gcnMMLS.BeginTrans .. But the problem lies here...my application shows error as follows:(in my application i am trapping the error) .. Error Number -2147467259 [TCX][MyODBC]Transactions are not enabled .. What could be the problem??? Thanks. Shankar __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL stops suddenly
Hi, I have MySQL 3.23 installed in Windows 2000 Server 4 days ago. It runs as a service of the server. It was working fine. But now it stops abrubtly. When I run the PhpMyAdmin from the browser it says the following : -- Error MySQL said: Go Back -- It does not say anything else... I ahve a doubt that it shuts down by itself after a specific period of time.. Is there any such options??? What is that I need to do? Thanks in advance. Shankar __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running MySQL as Service on 2000 Server
Hi, I am also facing the same problem...in Win2K When i try to run in from the service, it says some error so i referred to some sites...and just using the command line as standalone Also i acould not run apache as a service... I could not see it under services... Any way to start these under service... Shankar --- [EMAIL PROTECTED] wrote: > Hi, > > Anybody running MySQL on Win 2000 server here? > > I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a > 2000 Server (Dual 1.1 > GHz - 1GB RAM - 15GB HD space) and I can run it > without any problem from > the command line as a standalone. However I couldn't > run it as a service > even though I already did 'mysqld-max-nt --install' > the first time I ran > it. Is there anything wrong with MySQL or is it more > of permission issue on > NT/2000 server. > > I also attached the my.ini file if it would help. > Thanks. > > > Regards, > Martin > > [mysqld] > basedir=G:/MySQL > datadir=G:/MySQL/data > #bind-address= > log-slow-queries=h:/slowquery/slowquery.log > set-variable=key_buffer=20M > innodb_data_home_dir = g:/ibdata > innodb_data_file_path = ibdata:2000M;ibdata2:2000M > set-variable = innodb_buffer_pool_size=200M > set-variable = innodb_additional_mem_pool_size=30M > innodb_log_group_home_dir = h:/iblogs > innodb_log_arch_dir = h:/iblogs > innodb_log_archive=0 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=30M > set-variable = innodb_log_buffer_size=24M > innodb_flush_log_at_trx_commit=1 > set-variable = innodb_file_io_threads=10 > set-variable = innodb_lock_wait_timeout=50 > [WinMySQLAdmin] > Server=G:/MySQL/bin/mysqld-max-nt.exe > > > > > > > **Disclaimer** > This Memo and any attachments, may be confidential > and legally privileged. > If you are not the intended recipient and have > received this in error, > kindly destroy this message and notify the > sender. Thank you for your > assistance. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent : Problem in Group by clause
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate >From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent : Problem in Group by clause
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate >From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to set CD as autorun
Hi, I have developed an application in PHP/MySQL in Linux environment. I need to burn it in a CD and give it to the client. I need to do one thing - that is when the client insert that CD automatically my setup should run. How to do that...? what sort of coding i need to do ..? is it that i need to code in linux..? thanks... __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Null Value In a Column
Hi, I want to select record from a table that return empty string or something else that i want, if a column contains null value. can we do that in a select statement. I tried IsNUll function but it return wither 1 or 0. In MS SQL Server u got a function IsNULL that accepts 2 parameter - first the column name, second the value to be returned if that column contain null value. Is there any function MySQL? Shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Recordset
Hi, I am connecting MySQL in Linux server through Visual Basic in windows. When i used the recordset to select a record, the RecordCount method returns -1 even there is record in the table. following is the connection string i used "Provider=MSDASQL.1;Persist Security Info=False;Data Source=MMLSConn" Also i used adOpenKeyset and adLockOptimistic. shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Case sensitive in selecting records
Hi, I have a situation as follows: There is a table that stores the user name. One user name is 'David' and another is 'david' I want to select only the user with the name 'david'(all small and not 'David') MySQL is case insensitive in selecting records... how to make it case-sensitive in selecting records... shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Case Sensitivity in MySQL
Hi, I have a situation as follows: There is a table that stores the user name. One user name is 'David' and another is 'david' I want to select only the user with the name 'david'(all small and not 'David') MySQL is case insensitive in selecting records... how to make it case-sensitive in selecting records... shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php