Code: Select all
<?php
include("database.php");
define('HOST', 'localhost');
define('USER', 'root');
define('PASS', '');
define('DB', 'db1');
$staffNo = $_POST['StaffNo'];
$dateapply = $_POST['dateapply'];
$RefID = ?????
global $conn;
$q = "INSERT INTO leave VALUES ('$dateapply')";
mysql_query($q,$conn);
?>L($staffNo)($dateapply)
How should I write it? (the value of $RefID)