Dear Representative,

Is there a way to use DMXZONE Server Connect to insert the following value into a Global Session variable?

$query = "SELECT MAX(ID) AS lastID FROM donations";
$result = mysqli_query( $con, $query ) or die();
$row = mysqli_fetch_assoc($result);

session_start();
$_SESSION[last_ID] = $row[lastID];

Hi David,
Could you explain what are you trying to achieve?

The code should have been,

$query = "SELECT MAX(batch) AS lastID FROM donations";
$result = mysqli_query( $con, $query ) or die();
$row = mysqli_fetch_assoc($result);

session_start();
$_SESSION[last_ID] = $row[lastID]


Sure, I want to obtain the last value from a number field named "batch" in a mysql database. I need that number when I create a new record. I can do that using php, but wasn't sure if I could do that with Server action.

Hi David,
Yes that is possible. Not sure why would you need the session for the insert? Are you going to use it somewhere else on the page?
With the insert step in server connect you don't need a session.

This reply was removed on 10/15/2024 6:09:20 AM.
See the changelog