[PHP-DB] Date Formatting Question
I am trying to format the month portion of a date that I am trying to pull from MySQL to be placed into a drop down menu to modify the date. I have tried several ways and none seem to be working. I am pulling the date out of MySQL with: $sDate = explode(-, $row_events['Sdate']); And then attempting to insert each portion of the array into a drop down menu with: echo select name=Smonth; echo option selected$sDate[1]/option; which is where I am running into the problem. I pull out the month as 2 digit numeric 01, 02, 03 etc., but I want it displayed as January, February, March, etc., I have tried the following with no success: Date(F,strtotime($sDate)); Strftime(%B:,$sDate); Date(F,$sDate); I would use MySQL to format the date, but I have three date fields to modify and it would be easier to do it in PHP Any pointers would be appreciated. Mark Bomgardner Technology Specialist KLETC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with MySQL Extension
Setup Linux RHEL 3, PHP 4.3.2, MySQL 4.1.12 I am trying to use phpMyAdmin to connect and I am running into trouble. I get the message that PHP can not load mysql extension. A check of /usr/lib/php4 shows mysql.so is where is should be and under /etc/php.d there is the correct mysql.ini, along with imap, odbd and ldap which all show up with a call to phpinfo(), but mysql does not. I upgrade the php-mysql extension from 4.3.2-8 to 4.3.2-23, which is the most current rpm and still no luck. I now get the message that it can't find mysqli extension. Any ideas? Mark Bomgardner Technology Specialist KLETC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Insert and Update on same page
I've got a problem with trying to insert and updating on the same page. Here is my problem: I have a form that the user fills out. Upon submission, I want the information that was just inserted, to be pulled back out and shows to the user with an unique number for that record other than the record ID field. I can use the ID field together with another value to get the unique number that I want, but it would require a insert, select and update in one shot. Is this possible? I hope I have not confused everybody Mark A. Bomgardner Technology Specialist KLETC
[PHP-DB] Date Question
I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about this, but I keep getting an error message when I try to search the archives. I have looked at the manual, but I am not finding what I am looking for. Mark A. Bomgardner Technology Specialist KLETC
RE: [PHP-DB] Importing Excel and Access data to MySQL
The best way I have found is convert the data to a comma separated value file, use phpMyAdmin and insert the data into you database. A couple of things that you have to watch out for is the number of records that you are importing and that all your fields in your DB are of the correct format and length. Mark A. Bomgardner Technology Specialist KLETC -Original Message- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 9:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Importing Excel and Access data to MySQL Simple question, How does one import excel and access data to MySQL? -- Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
