Jump to content

Error #1136 Message


SlyMan

Recommended Posts

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.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...