Hi Guys, am new to PHP and just got stuck with this error message:
Column count doesn't match value count at row 1.
The code is this below:
$query = "INSERT INTO members(email, name, gender, dob, profile, password, group_ID)
SELECT operations.group_ID
FROM operations
JOIN members
ON operations.group_ID = members.group_ID" ;
$result = $db->query($query);
Am trying to insert data into a table called members, and needs to get the group_ID from another table called operations.
Not so sure what is wrong with the code; will appreciate help from anyone.
Cheers.