有没有办法随机选择一个ID进入数据库

Question

I am making a car dealership booking form and I need to select a staff member at random to go on the test drive

I've tried mt_rand() but I think I'm putting it in the wrong place

````````````````````````````````````
$sql = "INSERT INTO bookingcars (BookingStart, BookingEnd, BookingDate, MemberReference, ActivityID staffID) VALUES ('$timeStart', '$timeEnd', '$startDate', '$memberReference', '$activity', '$mt_rand(1, 4)staffID'";
````````````````````````````````````

Answer 1

while you could build it in the query, its little cleaner and easier to debug if you do something like:

$staff=rand(1,4).'staffID'; // assume you wanted 1staffID .. ?

//or did you just want $staff=rand(1,4);

$sql = "INSERT INTO bookingcars (BookingStart, BookingEnd, BookingDate, MemberReference, ActivityID, staffID) VALUES ('$timeStart', '$timeEnd', '$startDate', '$memberReference', '$activity', '$staff')";