nec9716 Posted March 20, 2008 Share Posted March 20, 2008 i try to look on search engine how to "related" table or "associated" table...without any chance that why i say that could be an easy one to some of you what exactly I have to type to be able to have a result? ??? Link to comment https://forums.phpfreaks.com/topic/97105-newbie-question/ Share on other sites More sharing options...
lordfrikk Posted March 20, 2008 Share Posted March 20, 2008 Can you explain yourself a bit more in English so we can help you? Link to comment https://forums.phpfreaks.com/topic/97105-newbie-question/#findComment-496861 Share on other sites More sharing options...
nec9716 Posted March 20, 2008 Author Share Posted March 20, 2008 ok I know that in a database you can link table between so when I go on google and type " link table sql" I don't have much good links.... so my next question is what I have to look for ? Link to comment https://forums.phpfreaks.com/topic/97105-newbie-question/#findComment-496867 Share on other sites More sharing options...
soycharliente Posted March 20, 2008 Share Posted March 20, 2008 Example users: id username password email firstname lastname messages: id senderid receiverid subject body postdate read SELECT * FROM messages JOIN users ON messages.senderid=users.id WHERE username='$un' That would maybe show you all the messages in an inbox for the person with username $un and you would have access to their firstname and lastname and email since you associated the senderid with the userid. That's the basic concept. Link to comment https://forums.phpfreaks.com/topic/97105-newbie-question/#findComment-496881 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.