Is this a correctly made JOIN:

// Build SUBJECT navigation and gather SUBJECT data here--------------------------------
$sqlCommand = "SELECT id, linklabel, pos FROM subjects INNER JOIN pages on id = pages.subjectid ORDER BY pos ASC"; 
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

?

Klemme

It is practically impossible to predict without knowing the actual structure of both the tables and their relations.

Hmm Sorry :-)

I think im on the wrong track anyways, and cant use joins in what I want to achieve.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.