0

Hello everyone this is my first question so if you miss something or if i am doing something wrong tell me!

I have two tables:

klanten:
id, ledenpagina_id

topics:
id, onderwerp, slogan, omschrijving

I want to add the ledenpagina_id to the topics table but I don't know how. I think it has something to do with Insert into but I looked up a few things but I cant get it to work in my case.

Please help me. :)

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
doesntmattteratll
  • 11
  • 1
  • You should post relevant code here, so others can see what you are working on and what you have achieved on your own. – rainer Mar 23 '18 at 10:46
  • @rainer well its kinda hard to post the code I have because it are databasetables? – doesntmattteratll Mar 23 '18 at 10:47
  • What columns and data values you expect on the updated table? Is ledenpagina_id = topics.id? – jose_bacoy Mar 23 '18 at 10:50
  • Have a look there https://stackoverflow.com/questions/18064495/inserting-a-column-to-preexisting-table-in-phpmyadmin – nicolallias Mar 23 '18 at 10:51
  • @anonyXmous I think the thing he wants is to add the ledenpagina_id from the table "klanten" to also be in the "topics" table – tom Mar 23 '18 at 11:14
  • Thanks tom. How lapenpagina id relates to topics table? – jose_bacoy Mar 23 '18 at 11:25
  • I thought the same but I think that ledenpagina_id needs to be set so he can set if ledenpagina_id = 1 show it and maybe when its 0 some people can not see it? i think that how he wants it @anonyXmous – tom Mar 23 '18 at 11:29

0 Answers0