how to set default value on text field from sql query and process in add page?
case illustration:
Text Field : registration_id
Desire default value : 200911000001, 200911000002, ..... auto increase with first 6 digits are from date("Yd")
on Event Add page Before display i tried using:
global $conn,$registration_id;
$sql = "select max(registration_id) as a from tr_registration where registration_id like (select concat((select DATE_FORMAT((SELECT CURRENT_TIMESTAMP), '%Y%m')),'%'))";
$rs = CustomQuery($sql);
$data = db_fetch_array($rs);
if ($data){
$data("a") = $data("a") + 1;
$registration_id["params"]["value"] = $data("a");
} else {
$registration_id["params"]["value"] = date("Ym") . "000001";
}
but return as error <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13157&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />