[PHP] Unknow "Date" Format
I am importing a database from WordPerfect Paradox, the time stamp that it puts into Mysql is one that I'm not familiar with. Some examples are, In Excel it formats them to: 35621 ---> 10-Jul-97 36965 ---> 15-Mar-01 36356 ---> 15-Jul-99 Can anyone tell me what date format this is, or how to format it into a readable date using either PHP or MySql? Thanks Jared -- 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 PROTECTED]
[PHP] MySql Help
Hello, I have a database with 4 Columns |ID|First|Second|Third| I am tring to run a query On the First Column and place the data into an array. The problem that I am running into Is that there are doubles, triples, and sometimes more of the same name in that column. Each name represents something differnet in the "Second" and "Third" and when I run a simple query (select "first" from "table") I get (expectedly) all of the names in the Column "doubles" and all. My question is , is there a way to select from a database and only select one of each name from the column? Example. Data >Data Data Data Data Data1>Data1 Data1 Data2>Data2 Data2 Data2 Data2 Thanks for any advice. Jared -- 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 PROTECTED]
[PHP] Dynamic Form
Hell0, I have a MySql database with 3 columns. The first column is "id" second is "name" and third is "value", I have two drop-down lists, with the first filled with an array from the column "name". I would like for the second drop-down list be changed according to the "value" of what has been selected in the first drop-down list. I have fill that I'm going in the right direction, but have run into a wall. Can anyone give me some advice in doing this miraculous feat? Thanks, Jared -- 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 PROTECTED]
RE: [PHP] Dynamic Form
I have tried using "onChange" in my script but have faild to load the values of the first drop-down list. Can I place an array inside an array. Or is there a better way of doing this? -Original Message- From: Jason Bell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 4:47 PM To: Jared Mashburn; PHP Users Subject: Re: [PHP] Dynamic Form PHP does not know what the user has selected in the first drop down. You can either reload the page with the new value once the user has selected the value for the first drop down list, and go from there, or use Javascript. - Original Message ----- From: "Jared Mashburn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 12, 2001 3:45 PM Subject: [PHP] Dynamic Form > Hell0, > > I have a MySql database with 3 columns. The first column is "id" > second is "name" and third is "value", I have two drop-down lists, > with the first filled with an array from the column "name". I would > like for the second drop-down list be changed according to the "value" > of what has been selected in the first drop-down list. I have fill > that I'm going in the right direction, but have run into a wall. Can > anyone give me some advice in doing this miraculous feat? > > Thanks, > > Jared > > > -- > 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 PROTECTED] > > -- 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 PROTECTED] -- 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 PROTECTED]
