Giving space in a word

I've a table contain 2 fields DATEFROM & DATETO. Now i fetch dis names from table and display the same, but i want to display like DATE FROM & DATE TO...If it is this possible How? We have any functions li开发者_如何学运维ke 'explode()'? please help

---

If it is only used on those fields then you could use

str_replace('DATE', 'DATE ', $dateField);

But in that situation there is no way to determine where a word starts/ends otherwise.

If the field names were camel case or separated with underscores then it would be different.

---

You can use substring() to extract content from fields, if you want to name column differently, use as, e.g. select datefrom as [date from] from mytable.