PHP Cool Tricks Reference

Can anyone point me to a reference that shows various ways of displaying
MySQL data with PHP, like the following?:

Display only rows where each word in a particular column begins with B.
Display only words that END in a particular letter.
Display only words that contain combinations of letters, such as "angor."
Display only the first three letters of each word.
Change everything to lower case.
Change the first letters of every word except "and" and "the" to upper case.

I found a good reference a couple weeks ago, but I seem to have lost the
link.

Thanks.

try this: http://www.devguru.com/home.asp

Craig


"David B" <david_blomstromDELETETHIS (AT) yahoo (DOT) com> wrote

Can anyone point me to a reference that shows various ways of displaying
MySQL data with PHP, like the following?:

Display only rows where each word in a particular column begins with B.
Display only words that END in a particular letter.
Display only words that contain combinations of letters, such as "angor."
Display only the first three letters of each word.
Change everything to lower case.
Change the first letters of every word except "and" and "the" to upper
case.

I found a good reference a couple weeks ago, but I seem to have lost the
link.

Thanks.

.oO(David B)

Can anyone point me to a reference that shows various ways of displaying
MySQL data with PHP, like the following?:

Assuming you want to do this in your queries:

Display only rows where each word in a particular column begins with B.
Display only words that END in a particular letter.
Display only words that contain combinations of letters, such as "angor."

.... WHERE yourField LIKE 'B%';
.... WHERE yourField LIKE '%B';
.... WHERE yourField LIKE '%angor.%';

Display only the first three letters of each word.
Change everything to lower case.

Answered in my other reply.

Change the first letters of every word except "and" and "the" to upper case.

I would do this in PHP, maybe something like

$text = strtr(ucwords($text), array('And ' => 'and ', 'The ' => 'the '));

HTH
Micha