Random number

Hi,
you can use Before record added event on the Events tab.

Here is a sample code:

where FieldName is actual field name.

For more information: http://www.w3schools.com/php/func_math_mt_rand.asp

where FieldName is actual field name.

For more information: http://www.w3schools.com/php/func_math_mt_rand.asp

Hello, thanks alot for that.

One question : with this generator, is it possible that 2 records have the same number? I guess so. I forgot to add the number can only be used once.

Hi,
use predefined event Check if specific record exists (Add action button on the Events tab) just after.

$values["code"]=mt_rand(100000,999999);

//** Check if specific record exists ****

global $conn;

$strSQLExists = "select * from AnyTable where SomeColumn='SomeValue'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

// if record exists do something

}

else

{

// if dont exist do something else

}
What is needed in the 'SomeValue' value then since its a random number?

thanks,

Hi,
random value is defined before in your code. Just repalce SomeValue with $values["code"] in your event:

where AnyTable is your actual table name, SomeColumn is actual field name.