[Resolved] where for art thou 2?

[tuf-web_co_uk]

hey peeps

does anyone know why the '2' 's dissapear after running this script

<?

include("includes/auth/common.php");

$string = "
 2


 2fort


 2nd


 2rooms


 2vs2
 ";

$string = addslashes($string);
$sql = "SELECT * from waypoints where type='other'";
$query = mysql_query($sql) or die (mysql_error());

while ($row=mysql_fetch_array($query)) {

$name = $row[name];

$name = str_replace(".zip", "", $name);

// echo $name;

$string = str_replace($name, "", $string);

}
$string = nl2br($string);
$string = stripslashes($string);
echo $string;
?>

that should give a blank output if their are records in the database which equal the corresponding line

however it returns

fort

nd

rooms

vs

which is basically removing all the 2's from the script 😕

can anyone help?

[HalfaBee]

Try echo $row['name'] in the loop and see what you are replacing.

HalfaBee

[Moonglobe]

hmmm i have a feeling that for some reason name is calling the pimary auto_increment field who's value is 2....... at least that's the fist thing to pop into my head.

[tuf-web_co_uk]

ok, i echoed all the record names, which just gives me a list of all my records

but the problem isnt with the database its with the $string variable

it only happens to 2's, no other number

[laserlight]

What if you try:

$string = str_replace($name, "[DELETED]", $string);

and see if it has any effect?

[tuf-web_co_uk]

although that didnt directly help, it made me realise that 1 of the records in the database had the name '2', so it deleted all the 2's and replaced it with [DELETED]

now i have this solved

thanks 😉