date_format question

2002-05-22 Thread Lee P Reilly
Hi, I have a quick question concerning date/time functions. If I query MySQL: SELECT date_format(date, '%W %M %e %Y') FROM experiments where expid=3706 It returns: Wednesday May 2 1979 Are there existing methods for determining whether to add st, nd or rd after the %e? e.g. in this

MySQL 3.23.49 Installation - password problems

2002-04-02 Thread Lee P Reilly
Hi, I just installed MySQL 3.23.49 on NT and executed the following commands: UPDATE USER SET password=password(test1) WHERE host=localhost; UPDATE USER SET password=password(test1) WHERE host=%; Now, after doing 'mysqladmin reload', I cannot connect... mysql -p Enter password: *

PHP/MySQL application - how to schedule server processes?

2002-03-12 Thread Lee P Reilly
is complete, the user will have access to the a results folder in the system containing a list of their submitted analysis (either pending or complete). Can anyone offer any advice/suggestions on how this can be accomplished? Thank you very much for your time. - Best regards, Lee Reilly -- Lee P. Reilly

insert select in ONE statement?

2002-02-20 Thread Lee P Reilly
Hi, I wonder if anyone can offer me some advice with this one: I have a table called 'iq_data' holding just a primary key and a field called 'iq_data'. +++--+-+-++ | Field | Type | Null | Key | Default | Extra |