PHP - Return Rows

Given the below 3 database tables I am trying to construct a SQL query that will give me the following result:

customer_favourites.cust_id
customer_favourites.prod_id OR product.id
product.code
product.product_name
product.hidden
product_ section.section_id (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)
product_ section.catpage (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)
product_ section.relative_order (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)

I currently have....

SELECT customer_favourites.cust_id, customer_favourites.prod_id, product.code, product.product_name, product.hidden, product_section.section_id, product_section.relative_order, product_section.catpage  
FROM customer _favourites  
INNER JOIN product ON customer_favourites.prod_id = product.id  
INNER JOIN product_section ON product_section.product_code = product.code  
WHERE `cust_id` = '17' AND `hidden` = '0' GROUP BY `code`  
ORDER BY `section_id` ASC, `relative_order` ASC, `catpage` ASC LIMIT 0,30

This gives me what I want but only sometimes, at other times it randomly selects any row from the product_section table.

I was hoping that by having the row I want as the last row (most recent added) in the product_section table then it would select that row by default but it is not consistent.

Somehow, I need to be able to specify which row to return in the product_section table, it needs to be the row with the lowest section_id value or it should by the last row (most recent).

Pulling my hair out so any help is gratefully received.  
customer_favourites

id     cust_id   prod_id
70    4            469
product

id        code           product_name    hidden
469    ABC123     My Product        0
product_section

id                  section_id      catpage    product_code    relative_order     recommended
44105         19                   232            ABC123             260                    1
44106          3                     125            ABC123              87                      1
44107          2                     98              ABC123             128                     1
44108          1                    156             ABC123             58                        0

 

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

I have 2 queries that I want to join together to make one row  

Hey all. My site has a config database table that has a column showlogin to set whether or not login functionality is enabled.

I'm playing around with MySQLi, Classes, and Returns.  My return is always 1. Where am I going wrong?

test.php
<?php
// Start Session
session_start();

// Production Settings
ini_set('display_errors', 1);
mysqli_report(MYSQLI_REPORT_ALL);

include 'db.php';
$mysqli = new mysqli($host, $user, $pass, $db);

class styles
{
function showlogin($show)
{
global $mysqli;
$select = $mysqli->query("SELECT showlogin FROM config LIMIT 1");
$value = $select->fetch_object();

if ($value->showlogin = 1) { 
return 1;
}
return 0;
}
}
$login = new styles();
echo $login->showlogin($show);
?>

Hi Everyone,   My name is Raoul Grosser, live in The Netherlands. I'm a front/backend developer working with AngularJS and Bootstrap and Symphone2. I've been writing PHP code for over 4 years now my focus is on opensource projects.   If you have any question, please let me know!