Jump to content

Error #1136 Message

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...