svendsek Posted May 27, 2009 Share Posted May 27, 2009 Dear Freaks, I have kind of a newbie question for you today, but still a question, so here it goes: I am working on this newsscript, in wich i need to save the news (obviously) to the database, but I also need to save which user posted the news. This info is stored in a separate table from the news stuff, so my question is: how do I go about to achieve this? do I need a join, or is this only for outputting? :-\ All response appriciated Quote Link to comment Share on other sites More sharing options...
Maq Posted May 27, 2009 Share Posted May 27, 2009 Yes, you need a JOIN. Quote Link to comment Share on other sites More sharing options...
svendsek Posted May 28, 2009 Author Share Posted May 28, 2009 hmmm... I'm not quite sure how to go about this... i think that join article was a bit on the heavy side for me, but i couldn't find that join applied to insert into" statements? excuse my utter stupidity Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted May 28, 2009 Share Posted May 28, 2009 Run two INSERTs? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 2, 2009 Share Posted June 2, 2009 hmmm... I'm not quite sure how to go about this... i think that join article was a bit on the heavy side for me, but i couldn't find that join applied to insert into" statements? excuse my utter stupidity It wasn't an article, it was a refman page. Are you talking about storing the related records, or retrieveing them? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.