[PHP-DB] Re: Date Formatting Question

2005-12-14 Thread Neil Smith [MVP, Digital media]
Apart from anything, you need to supply an option value for each of those options, not just rely on the browser which will default to passing the option *text* back from the form, if you specify no value. So your option elements should read January Notwithstanding that, RE below - you guys a

Re: [PHP-DB] Date Formatting Question

2005-12-14 Thread tg-php
You got the right idea, but you're making it more complicated than it needs to be. your $sDate after using explode() is going to contain an array. strtotime doesn't take an array, it takes a string. $monthName = date("F", strtotime($row_events['Sdate'])); $monthNumber = date("m", strtotime($r

[PHP-DB] Re: Date Formatting Question

2005-12-14 Thread El Bekko
Bomgardner, Mark A wrote: 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_eve

[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 att

[PHP-DB] Re: Character encoding issues: Pound- sign "£" becomes a "ú" - why?

2005-12-14 Thread El Bekko
Alex Gemmell wrote: Hello, I'm experiencing some odd character encoding issues. My PHP webpage is displaying test from a MySQL database. What happens is that I export data from an SQL Server database to a MySQL (4.0) database. Somewhere along the line the British currency pound-sign "£" be