Thanks for your continued help Andy, but I am not getting anything printing out. I have checked that I am connecting correct and I am, but it fails after I attempt to execute the query and print out the result? I tried switching the table calls in the join as well, and still I haven't been able to print out any results?
PS I am doing this in PHP, and I realize it would be better to fetch by association, but I cannot even fetch by a row :/
$query = mysql_query("SELECT p.part_id, p.serial, p.description, link.quantity, p.part_status
FROM parts as p JOIN parts_has_children as link ON link.child_id = p.parts_id
WHERE link.parent_id = 34 AND p.parts_status = 1");
$row = mysql_fetch_row($query);
print $row[0] . "<br />";
print $row[1] . "<br />";