Multiple mysql loops

[oracle259]

How can i do multiple mysql loops without having to do while ( ) more than once

[wildteen88]

Could you explain in more detail what you're trying to do. ALsi if you want to do a loop within another loop you'll have to use either a while loop, a for loop, foreach loop

[oracle259]

ok. I have the following code. The problem is this, say $user = "bob.camsara and $reserved names are bob and sara the output would be %%%.camsara.

my question is how can i modify the code to go through the entire result to get %%%.cam%%%%.


[code]
while ($res = @mysql_fetch_array($result)) {
if (stristr(trim($user, $reserved)) {
  $length = strlen($reserved);
    for ($k = 1; $k  <= $length; $k++) {
      $percent = "%";
}

$newuser = eregi_replace($reserved, $percent, trim($user));
$percent = " ";

    }
}

echo $newuser;

[/code]

[jrodd32]

couldn't you use the strpos() function and search for your reserved words and then replace them with the % character

[oracle259]

i'm not familiar with strpos how would i go about doing that.

[jrodd32]

strpos(string haystack, string needle) it will return the position of the needle within the haystack.

For example:
$string1=strpos("The cat sat on the mat", "cat");

would return 4

so once you know where in the string the data is that you don't want to display you could simply create a for loop that would print the % character you were using.

[oracle259]

ok i read up on strpos but it still failed to account for both reserved names

[jrodd32]

I think that you would have to run it once for each reserved name