User Location on Different file

[bowers01 +]

What version of 68 Classifieds are you running?
V4.10 Developer

Hi,
I am setting up a page to fetch the all the seller stores and list them.
What i currently have is below.

What i am stumped on is getting the city, state and phone for the sellers.
Any ideas how this could be done?
Regards,
Nick

PHP Code:

<?php
require_once('includes/init.php');
require_once(FILESYSTEM_PATH .'modules/seller_store/includes/functions.php');
require_once(FILESYSTEM_PATH .'includes/classes/kernel/Users.php');


        $sSQL = "SELECT s.sID,s.sUserID,s.sTitle,s.sDescription,s.sImage FROM ".PREFIX."store AS s LEFT JOIN ".PREFIX."users AS u ON s.sUserID = u.id";
        $result=$db->query($sSQL);
        $data=array();
        while($rs = $result->fetch())
        {
            $data[]=$rs;
        }
        $class_tpl->assign('results', $data);
        $class_tpl->assign('body','custom/dealers.tpl');
        
$class_tpl->display('layout.tpl');

?>

[Eric Barnes]

You just need to add the user fields to your query.

$sSQL = "SELECT s.sID,s.sUserID,s.sTitle,s.sDescription,s.sImage,u.city,u.state,u.phone FROM ".PREFIX."store AS s LEFT JOIN ".PREFIX."users AS u ON s.sUserID = u.id";

[bowers01 +]

Thank you very much, works like a charm.
I had it in my head that it was not going to be something simple.

Cheers,
Nick