SlyMan
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by SlyMan
-
-
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_IDFROM operationsJOIN membersON 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.
Error #1136 Message
in General
Posted
Yes they do exist.