View Thread
 Print Thread
User Store help
dziewalex
I am working on an infusion that would allow users to have there own store and be able to sell what they want on it. I have ran into a bit of an issue with displaying items in the shop. I am trying to limit the amount of items per row that display and not per page. My goal is to have 4 items per row in each category. this what it looks like atm. php-fusion.us/forum/attachments/currently.png this is what i am trying to have it look like. www.php-fusion.us/forum/attachments/future.png

this is my code



            echo "
";
         
         echo "";
             
            $qtwo =
                    mysql_query(
                            "SELECT si.*,i.*,it.* FROM ".DB_SHOPITEMS." si LEFT JOIN ".DB_ITEMS." i ON si.sitemITEMID=i.itemid LEFT JOIN ".DB_ITEMTYPES." it ON i.itemtype=it.itemtypeid WHERE si.sitemSHOP=".$_GET['shop']." ORDER BY i.itemtype, i.itembuyprice, i.itemname") or die(mysql_error());
            $st = "";
            while ($data = mysql_fetch_array($qtwo))
            {
                if ($st != $data['itemtypename'])
                {
                    $st = $data['itemtypename'];
                    echo"";
                }
      
   echo "";
    
            }
          echo "";
            echo "
Browsing shop items at ".$shopdata['shop']."...
".$st."


       

         
".$data['itemname']."

         
'".$r['itmdesc']."'

         
".$buyprice."

       

       
Qty:
      


     
";
    
         closetable();
dziewalex attached the following file:
You are not allowed to see attachments in this thread.
 
NetriX
Solved at PHP-Fusion UK, thread locked.
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the [url=https://php-fusion.co.uk/articles.php?cat_
 
https://netrixhosting.com
Jump to Forum
Similar Threads
Thread Forum Replies Last Post
Different Homepage For Each User Group? Addon Requests 3 10-18-2017 12:06
Adding Selz Link to User Profile Addon Requests 1 10-14-2017 07:42
away to list certain user group Addon Requests 24 04-30-2015 13:28
User rights and Prilidges General Chat 11 01-23-2015 16:54
User profiles General Chat 1 01-23-2015 16:33