Echoing a record minus a particular character 2

[meeble3]

Hello,

When I pull a record from the database, it is a word, (varchar) and I echo it to the page.

Sometimes the word is like this - 'hello' and sometimes like this 'hello3' or 'hel3lo'.

Is there a way to say if any record contains 3 wherever it is in the word, just to print the word without the 3 so it always says 'hello'?

Cheers

James

 

[cLFlaVA]

echo str_replace( "3", "", $string_value );

http://us2.php.net/manual/en/function.str-replace.php

*cLFlaVA
----------------------------
[tt]insert funny quotation here.[/tt]

 

[meeble3]

Thanks, but doesn't do anything.

My line is:

echo str_replace( "3", "", $myrow[0] );

but it doesn't change anything. Any ideas?

Cheers

James

 

[cLFlaVA]

are you getting any errors? what is the value in $myrow[0]?

*cLFlaVA
----------------------------
[tt]insert funny quotation here.[/tt]

 

[meeble3]

No errors just doesn't do anything...

 

[DRJ478]

That seems strange. Let's see the code that you use to generate the output (more than the echo statement).
Cheers.

 

[meeble3]

The code is...

$result = mysql_query("SELECT DISTINCT area from centres where towncity = 'London' order by area",$db);

while ($myrow = mysql_fetch_row($result)) {

echo str_replace( "3", "", $myrow[0] );

echo"<option><span class=\"formfont\">$myrow[0]</span></option>";

}

 

[DRJ478]

The first echo statement should print the replaced value into the output. However, it doesn't change the content of the record data.

$result = mysql_query("SELECT DISTINCT area from centres where towncity = 'London' order by area",$db);

while ($myrow = mysql_fetch_row($result)) {

   echo"<option><span class=\"formfont\">".str_replace( "3", "", $myrow[0] )."</span></option>\n";
}

You either need to assign the replaced value to the row or use the function on the output as shown above. You code just echos the original content og the row.

 

[meeble3]

Thanks a lot

 

[Bastien]

you can also use regex to do this as well, it may be more viable if the number changes...

$var = eregi_replace("[[:digit:]]","",$da_result);

Bastien

Cat, the other other white meat