Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $conn = pg_connect("host=localhost port=5432 dbname=alc user=postgres password=postgres");
- $training_id= "SELECT m.training_mst_id FROM tbl_user u, training_mst m WHERE u.user_id = m.trainer_id AND m.start_traning >= now() AND m.end_traning <= now() AND m.trainer_id = ".$_SESSION['user_id'];
- $result = pg_query($conn,$training_id);
- $query = "UPDATE training_mst set status='TRUE' where training_mst_id= ".$training_id;
- $result2 = pg_query($conn,$query);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement