One other thing.. As you said you're using php you could
be interested in phpMysqlAdmin which has a lot of functionality.
Date: (PHP Question?)
Yes, You have to convert it to 'YYYY-MM-DD HH:MM:SS'. I miss oracles TO_DATE
function.
Look in the PHP manuals as I don't program in PHP right now.
I would use regexp: s/(\d{1,2})\/(\d{1,2})\/(\d{4})/$3-$2-$1/ would do the
trick :o)
Then you have to check if it matches: /\d{4}-\d{1,2}-\d{1,2}/
If it does, just insert it, otherwise, the date inserted by the user
was not d/m/y.
mvh:
Pål Wester, programmerer
never.no as, stortingsgt 30, 0161 Oslo
tlf: 22 01 66 20, fax: 22 01 66 21
direkte: 22 01 66 34, 906 900 62
http://never.no - icq:103476059
~ f u cn rd ts u prb a gk ~
> -----Opprinnelig melding-----
> Fra: php php [mailto:[EMAIL PROTECTED]]
> Sendt: 11. februar 2001 20:10
> Til: [EMAIL PROTECTED]
> Emne: afraid of using mysql!
>
>
> Hi!
> I've just joined ur mailing list!
> i've never used mysql!
> i'm wondering if there is only one way to insert data to a table?
> i use the command line, no interface!
> i have the mysql GUI but obviously it does not offer it it just offers
> showing tables and their data !
> i'm used to Asp with Oracle or access but i'm afraid of using mysql!
> is it difficult ? can u point me to sites that include all mysql
> data type,
> like memo, automatic numbers etc
> i have already tried php with access, it works , thwn with
> oracle , it does
> not work and as long a s i'm in hurry of finishing my project i decided to
> try mysql is it so difficult?
> what about inserting data to tables easily and quickly !
> another question, i have a form where the user enters two dates(d/m/y)
> after submittimg, i use a select syntax that extract from a
> table, the lines
> where the attibute date is between the ones of the form!
> do i have to convert the date extracted from the form ? to waht and how?
>
> Thanks a lot !
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
---------------------------------------------------------------------
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
