Member Avatar for klemme

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

  • 2 Contributors
  • 2 Replies
  • 56 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by klemme
Member Avatar for debasisdas

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

Edited by debasisdas because: n/a
Member Avatar for klemme

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.