Add letter JO on the autoincrement data produce

[newphpcoder]

Thank you so much for your help..

Now that I post my whole code, I hope it could help to find you why when I put your code in my code it did not work,but when it is stand alone ot works.

I really appreciate your help.


I hope this time we could find the problem and solve it ...

Thank you very much

[newphpcoder]

kindly visit this site:
http://www.topmovietrailers2012.blogspot.com

thank you

[tom8]

Thanks for posting additional info. I will have a look today and keep you posted with my progress.

[tom8]

Ok, lets try this:

This line (line #241)
$currentSRYMD = substr($row['jo_number'], 0, 6);

Change it to:
$currentSRYMD = substr($row['jo_number'], 2, 6);


Do that and let us know what you got.

[tom8]

The above probably will only partially fix your problem.

Try this instead:

<?
   $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
   $result = mysql_query($sql, $con);
        
   if (!$result)
   {
       echo mysql_error();
       die();
   }
   $total = mysql_num_rows($result);
   if ($total <= 0)
   {
       $currentSR = "JO".date("ymd")."001";
   }
   else
   {
            // Stock Number iteration....
       $currentYMD = date("ymd");
       $row = mysql_fetch_assoc($result);
  
       $currentSRYMD = substr($row['jo_number'], 2, 6);
       $currentSRNum = substr($row['jo_number'], 8, 3);
       if ($currentYMD > $currentSRYMD) 
       {  
           $currentSRNum = 1;
           $currentYMD = $currentSRYMD;
       }
           else 
           {  
           $currentSRNum++;
           }
       $currentSR = "JO" . $currentSRYMD . sprintf("%03d", $currentSRNum);
   }      
?>

[newphpcoder]

The above probably will only partially fix your problem.

Try this instead:

<?
   $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
   $result = mysql_query($sql, $con);
        
   if (!$result)
   {
       echo mysql_error();
       die();
   }
   $total = mysql_num_rows($result);
   if ($total <= 0)
   {
       $currentSR = "JO".date("ymd")."001";
   }
   else
   {
            // Stock Number iteration....
       $currentYMD = date("ymd");
       $row = mysql_fetch_assoc($result);
  
       $currentSRYMD = substr($row['jo_number'], 2, 6);
       $currentSRNum = substr($row['jo_number'], 8, 3);
       if ($currentYMD > $currentSRYMD) 
       {  
           $currentSRNum = 1;
           $currentYMD = $currentSRYMD;
       }
           else 
           {  
           $currentSRNum++;
           }
       $currentSR = "JO" . $currentSRYMD . sprintf("%03d", $currentSRNum);
   }      
?>

Thank you so much...It works...

Thank you....Thank you....Thank you

[tom8]

I’m glad we figured it out. As you can see, more info provided makes it easier to pinpoint problem area. Good luck with your project.

[newphpcoder]

I’m glad we figured it out. As you can see, more info provided makes it easier to pinpoint problem area. Good luck with your project.

Thank you very much

[newphpcoder]

I’m glad we figured it out. As you can see, more info provided makes it easier to pinpoint problem area. Good luck with your project.

Thank you very much

[newphpcoder]

Hi...

I thought before that my issue in jo auto increment is solved, but Io notice that on the second day that I add approve jo number it was the same on the first date.

for example:

JO120515001
JO120515002
the next day I add, the displayed output is:

JO120515001 // the correct shoulb be JO120516001


here is the code:

   $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
   $result = mysql_query($sql, $con);
        
   if (!$result)
   {
       echo mysql_error();
       die();
   }
   $total = mysql_num_rows($result);
   if ($total <= 0)
   {
       $currentSR = "JO".date("ymd")."001";
   }
   else
   {
            // Stock Number iteration....
       $currentYMD = date("ymd");
       $row = mysql_fetch_assoc($result);
  
       $currentSRYMD = substr($row['jo_number'], 2, 6);
       $currentSRNum = substr($row['jo_number'], 8, 3);
       if ($currentYMD > $currentSRYMD) 
       {  
           $currentSRNum = 1;
           $currentYMD = $currentSRYMD;
       }
           else 
           {  
           $currentSRNum++;
           }
       $currentSR = "JO" . $currentSRYMD . sprintf("%03d", $currentSRNum);
   } 

Thank you

[tom8]

Looks like we got this line transposed:
$currentYMD = $currentSRYMD;

The code should be this:

<?php
   $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
   $result = mysql_query($sql, $con);
        
   if (!$result)
   {
       echo mysql_error();
       die();
   }
   $total = mysql_num_rows($result);
   if ($total <= 0)
   {
       $currentSR = "JO".date("ymd")."001";
   }
   else
   {
            // Stock Number iteration....
       $currentYMD = date("ymd");
       $row = mysql_fetch_assoc($result);
  
       $currentSRYMD = substr($row['jo_number'], 2, 6);
       $currentSRNum = substr($row['jo_number'], 8, 3);
       if ($currentYMD > $currentSRYMD) 
       {  
           $currentSRNum = 1;
           $currentSRYMD = $currentYMD;
       }
       else 
       {  
           $currentSRNum++;
       }
       $currentSR = "JO" . $currentSRYMD . sprintf("%03d", $currentSRNum);
   }  
?>

Hopefully we got everything right this time

[newphpcoder]

Thank you so much it works