List Screen

You can access fields values in the "Process record values" event or in the "Before display" event using the $values array:

Hi Christian,
Added code :
echo "My Forum ". $values["FORUM"];
Error :
Undefined variable: values

Do you add the code in the "Process record values" event or in the "Before display" event of edit page ? Is FORUM the real name of the field ?

Hi,
function BeforeProcessList(&$conn)
echo "Hello there! ";
global $conn;

$strSQLExists = "select * from forms.user_forums where ";

$strSQLExists .= "rtrim(user_id,' ') = '".$_SESSION["ID1"]."' and rtrim(forum,' ') = '";

$strSQLExists .= $values["FORUM"]."'";

echo $strSQLExists;

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

$user=db_fetch_array($rsExists);
if($user)

{return true;

}

else

{header("Location: REDIRECT_view.php?editid1=X");

exit();

}
} // function BeforeProcessList
Error :
Hello there!

PHP error happened
Technical information

Error type 8

Error description Undefined variable: values

URL localhost/Classroom/TRAINING_COURSE_list.php?

Error file C:\Program Files\PHPRunner4.2\projects\Training\include\TRAINING_COURSE_events.php

Error line 357

SQL query
Thanks

Add the code to the "Process record values" event or to the "Before display" event of edit page if you want to do some validation on the fields before showing the Edit screen.