rbjolly

CHARINDEX is 1 based, not 0. The following works for me on the developer edition of SQL Server: SELECT RTRIM(LEFT (ctn_node_path, CHARINDEX(' > ', ctn_node_path, 1))) FROM yourTableNameHere

When you get emp_id from the database just put it into your session variable like so: $_SESSION["id"] = $emp_id Where $emp_id represents the value from the database. Once it is in the session array, there is no need to return to the database or a form in order to read …

Probably not the most efficient way, but if it is working for individual id values then enclose your code in a loop that iterates over the range of values and change your SQL statement from using BETWEEN to = , like so: $start = 1; $end = 2; for ($tmpID …