Converting Certain Charaters and Ordering Information

carros01

Don't know if I've overlooked something simple but here goes. There are two things I'm looking to do.
1. I would like to feed in a string and have it returned cleaned of certain characters. i.e. "Who Can You Trust?" returned as "Who Can You Trust" - no question mark. How can I do this?
2. When getting data from the database is there a way to return only fields stating with a certain letter. i.e. Return all fields that start with a "b".

Thanks for any help you can offer (and sorry if the answers are stupidly obvious!)

Sean

devinemke

1.
$string = 'Who Can You Trust?';
$string = str_replace ('?', '', $string);
echo $string;
// outputs: Who Can You Trust

2.
$sql = "SELECT * FROM tablename WHERE fieldname LIKE 'b%'";

carros01

Thanks very much.

It didn't take long for a reply!

pablogosse

For replacing certain characters, use preg_replace to search and replace based upon regular expressions you develop:
http://www.php.net/manual/en/function.preg-replace.php

For your database question, use syntax similar to the following in your query:

select col_a from table_a where col_a like 'A%'

Cheers,
P.

devinemke

if you are just stripping out characters (as in the original question) you do not need or want the addtional overhead of regular expressions. a simple str_replace will do the job faster.