[RESOLVED] Logic Problem

maskme

Hi All

I've made two functions, One function checks whether the same reference no. exists and another function just generates part of reference no.

$ref = autoGR ();
$ref_no = $PCwho."-".$ref."-".$dor_ref; 
$va = chkRef ($ref_no, 'tbl_test')

//I don't know what to do next from here, how should i go back to autoGR();

Once the autoGR(); has generated the $ref, i need to keep checking in the table whether there is no duplicate ref no. So if its same it needs to autoGR(); till its a unique one.

Please help me on this one, how i should do it?

function chkRef ($ref, $tableName)
 {
		$srquery = "select fld_ref from $tableName where fld_ref='$ref'";
		$srresult = mysql_query($srquery) or die("Reference Check Failed");
		if (mysql_num_rows($srresult) != 0) return $refv = 1;
			else return $refv = 0;
	}

function autoGR ()
 {
		srand(time()); 
  $a="123456789"; 
  for($i; $i<=6; $i++) 
   { 
    $ref.=substr($a, (rand()%(strlen($a))),1); 
   } 
		return $ref;	
	}

leatherback

Something like:

while($unique == 0)
  {
   $ref = autoGR ();
   $ref_no = $PCwho."-".$ref."-".$dor_ref; 
   $unique = chkRef ($ref_no, 'tbl_test') ;
  }

maskme

Hi Leatherback

Thanks for your reply but its going in an infinite loop???

leatherback

Haha,

Think that the autoGR () returns 1 upon duplicate then, or not? THen change the whole to while... == 1)

maskme

Thanks for you help...
its working this way OK???

				$ref = autoGR ();
				$ref_no = $PCwho."-".$ref."-".$dor_ref; 
				$unique = chkRef ($ref_no, 'tbl_test'); 					

			while($unique == 1)
				{
					$ref = autoGR ();
					$ref_no = $PCwho."-".$ref."-".$dor_ref; 
					$unique = chkRef ($ref_no, 'tbl_test') ;
				}

thanks

leatherback

Yes, or:

$unique = 1;
                while($unique == 1)
                    {
                        $ref = autoGR ();
                        $ref_no = $PCwho."-".$ref."-".$dor_ref; 
                        $unique = chkRef ($ref_no, 'tbl_test') ;
                    }

If the problem is solved, please mark the thread resolved, since only the thread starter can do this. It help people to see what still is unanswered (See thread tools)