Jump to content

SlyMan

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by SlyMan

  1. 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.
×
×
  • Create New...