.oO(David B)
Quote:
I want to display just the first three letters of every word in one
field from a table, and I also want the first letters changed to lower
case. I believe either of the following two codes will do the trick, but
I can't figure out how to plug them into my query: |
Do you want to do these modifications when fetching the data (i.e. in
your SQL-query) or after fetching it (i.e. in the PHP-code)?
1) SQL: SELECT ... LOWER(LEFT(yourField, 3)) AS yourField, ...
2) PHP: $value = strtolower(substr($value, 0, 3));
HTH
Micha