Code: Select all
$s = "SELECT * FROM zzzzsys_user WHERE zzzzsys_user_id = '#USER_ID#'";
$t = nuRunQuery($s);
if (db_num_rows($t) == 1) {
$r = db_fetch_object($t);
//$to = $r->InvtTo;
$from = $r->sus_name;
$email =$r->sus_email;
}
$j = " nuSetValue('EmailFrom','$email'); ";
nuAddJavascript($j);
Also what would be the best way to set the value for the name field?