1 update commando, 2 velden in verschillende tabellen vullen
$now = (gmdate("Y-m-d H:i:s"));
$sql = "UPDATE `tabel1` SET `logout_date`='$now' WHERE UNIX_TIMESTAMP(DATE_SUB('$now', INTERVAL $session_duration SECOND)) > UNIX_TIMESTAMP(last_request_time) AND (`logout_date` ='0000-00-00 00:00:00')";
Alvast bedankt voor de reacties!
$sql1 (voor tabel 1)
$slq2 (voor tabel 2)
GR,
Loran
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
UPDATE
tabel1,
tabel2
SET
tabel1.logout_date = NOW(),
tabel2.last_logout_date = NOW()
WHERE
tabel1.id = $id
AND tabel2.id = $id
tabel1,
tabel2
SET
tabel1.logout_date = NOW(),
tabel2.last_logout_date = NOW()
WHERE
tabel1.id = $id
AND tabel2.id = $id
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
UPDATE
tabel1 as t1
INNER JOIN table2 as t2
ON (t1.id = t2.id
SET
t1.logout_date = NOW(),
t2.last_logout_date = NOW()
tabel1 as t1
INNER JOIN table2 as t2
ON (t1.id = t2.id
SET
t1.logout_date = NOW(),
t2.last_logout_date = NOW()
Zoiets?
