Rother2005 Posted January 15, 2007 Share Posted January 15, 2007 if it is can anyone point me in the right direction code wiseThanks Link to comment https://forums.phpfreaks.com/topic/34280-is-it-possible-to-display-data-from-2-tables/ Share on other sites More sharing options...
JJohnsenDK Posted January 15, 2007 Share Posted January 15, 2007 Yes there is... JOIN[code]$sql = mysql_query("SELECT p.name, j.position FROM people AS p JOIN job AS j");[/code]You can also use LEFT JOIN, RIGHT JOIN and INNER JOIN, so it would be easier if you posted an example of what you want. Link to comment https://forums.phpfreaks.com/topic/34280-is-it-possible-to-display-data-from-2-tables/#findComment-161222 Share on other sites More sharing options...
Philip Posted January 15, 2007 Share Posted January 15, 2007 look at MySQL's JOIN functionhttp://dev.mysql.com/doc/refman/5.0/en/join.html Link to comment https://forums.phpfreaks.com/topic/34280-is-it-possible-to-display-data-from-2-tables/#findComment-161229 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.