looping in PHP n MySql

[w3bdiv3r]

Hi bro..
anw i've a looping problem in string + integer(e.g PP001)

else if($_GET[act]=='viewProgressProject')
	{
		include "connect.php";
 		$sql = mysql_query("select * from progress where IDPro = '$_GET[id]'");
		
		while($fetch = mysql_fetch_array($sql))
		{
			if ($zzz = substr($fetch[0],2,3) + 1)
			{
				$test = "PP00";
				$gg = $test.$zzz;
			}
			else if($zzz = substr($fetch[0],2,3) + 10)
			{
				$test = "PP0";
				$gg = $test.$zzz;
			}
			else
			{
				$test = "PP";
				$gg = $test.$zzz;
			}
		}
		
		echo "
			<h2>Progress Project : $_GET[id]</h2>
			<form id=formViewProgressProject name=formViewProgressProject method=post action='action.php?module=project&act=doUpdateProgressProject'>
  			<table>
    		<tr>
      			<td>ID Progress</td>
     			<td> : <input type=text name=txtIDProgress id=txtIDProgress value='$gg' readonly=readonly/></td>
    		</tr>

[prasanthmj]

What is the problem/output that you are getting?

It should be

intval(substr($fetch[0],2,3)) + 10

I guess?

Also in the else case, $zzz is not initialized?

[w3bdiv3r]

according to my code, my looping results are PP001,PP002,PP003......,PP0010,PP0011, whereas i want my results are PP010,PP011 not PP0010,PP0011..
u got my questions?

[JShor]

See if this fixes it for you:

else if($_GET[act]=='viewProgressProject')
    {
        include "connect.php";
         $sql = mysql_query("select * from progress where IDPro = '$_GET[id]'");
        
        while($fetch = mysql_fetch_array($sql))
        {
            if ($zzz = substr($fetch[0],2,3) + 1)
            {
                $test = "PP00";
                $gg = $test.$zzz;
            }
            else if($zzz = substr($fetch[0],2,3) + 10)
            {
                $test = "PP0";
                $gg = $test.$zzz;
            }
            else
            {
                $test = "PP";
                $gg = $test.$zzz;
            }
        }
        
        str_replace("00", "0", $test);
        
        echo "
            <h2>Progress Project : $_GET[id]</h2>
            <form id=formViewProgressProject name=formViewProgressProject method=post action='action.php?module=project&act=doUpdateProgressProject'>
              <table>
            <tr>
                  <td>ID Progress</td>
                 <td> : <input type=text name=txtIDProgress id=txtIDProgress value='$gg' readonly=readonly/></td>
            </tr> 

[w3bdiv3r]

@prasanthmj : my looping results are PP001,PP002,PP003......,PP0010,PP0011, whereas i want my results are PP010,PP011 not PP0010,PP0011..
anw thx for ur help..

@JShor : hmm.. ur code results are same with my code results..>.<
anw thx for ur help..

anybody could help me to solve this problem??

[forum_amnesiac]

Have you tried using strlen(), ie

            if (strlen(trim($zzz)) == 1) 
            { 
                $test = "PP00"; 
                $gg = $test.$zzz; 
            } 
            else if(strlen(trim($zzz)) == 2) 
            { 
                $test = "PP0"; 
                $gg = $test.$zzz; 
            } 
            else 
            { 
                $test = "PP"; 
                $gg = $test.$zzz; 
            }