Replace string with matched character with sentence

PHPAnx

Trying to figure out how to search for a character in my result string (want to find the character: X) and if it is X then show a sentence for it:

my current code:

$id = $row["productsID"];
$title = $row["productsTitle"];
$price = $row["productsPrice"];
$desc = $row["productsDesc"];
$cat = $row["productsCat"];

$cat = str_replace(" all","",$cat);

//<img src='img/spacer.gif' width='1' height='10' border='0' alt=''><br>*Please allow 6 to 8 weeks for delivery.<br>

$foo = $cat;
$foo = ucwords($foo);

$row_color = ($row_count % 2) ? $color1 : $color2;

echo "";

So basically, want to search $id for product that has "X" in it, and if it does, then echo "a sentence"

examples of product codes:

X102
X1102
A0233
E0255
CD-2263

ecg

I use postgresql but I figure this is very similar...

Heres your Product codes
X102
X1102
AB102
B1092

2 questions:
does Case matter?
will the letters be just on the front of the code?

I set up some codes to explain LIKE...
Codes:
X102
1X02
102X
ABC0

select * from "Codes" where "Name" LIKE '%X';

will return
102X

select * from "Codes" where "Name" LIKE 'X%';

will return
X102

select * from "Codes" where "Name" LIKE '%X%';

will return
X102
1X02
102X

PHPAnx

Actually, not looking for a select statement. This comes after the select statement is over and done. This must be in the echo of the string results.

Basically something that says if the queried string product has an "X" in it then swap that out for "this sentence" but if the string does not have an "X" in it, then to show nothing.

ecg

how to search for a character in my result string (want to find the character: X)

the LIKE stuff will find your character

Basically something that says if the queried string product has an "X" in it then swap that out for "this sentence" but if the string does not have an "X" in it, then to show nothing.

ie IF (code LIKE string){
echo "a sentence";
}else{
echo "";
}

PHPAnx

Seems incomplete, I can't make sense out of that.

Like this, search $id for "X" and if has "X" write "this sentence"

In order to fit into echo, it must be a variable like so:

$ship = $id

if ($ship == "")
$ship = "";

if ($ship != "")
$ship = "this sentence";

Need to find a way for if $id contains "X" to fit this.

ecg

sorry got the sql a little mixed with the php...

Either:

$Query = pg_query("Select id from tablename where (id =$id) and $id LIKE 'X%';");	
if (pg_num_rows($Query)>0) {
$Ship = "A Sentence";
}

Or you could substring $id into a seperate field (if X will always be leading on the code)
$var = (first letter of ) $id;
and do a:

 if ($var =='X'){
$Ship = "A Sentence";
}

I'm not so good at the substr stuff.. but it'll be in the manual...