[PHP-DB] Date Formatting Question

2005-12-14 Thread Bomgardner, Mark A
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

[PHP-DB] Problem with MySQL Extension

2005-06-23 Thread Bomgardner, Mark A
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

[PHP-DB] Insert and Update on same page

2004-11-01 Thread Bomgardner, Mark A
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

[PHP-DB] Date Question

2004-10-27 Thread Bomgardner, Mark A
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

RE: [PHP-DB] Importing Excel and Access data to MySQL

2004-10-08 Thread Bomgardner, Mark A
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