GoFuckYourself.com - Adult Webmaster Forum

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - PHP/MySql help... (https://gfy.com/showthread.php?t=1016403)

PHP/MySql help...

I'm setting up a new store using CMS to sell sex toys, movies, etc. An online adult store specializing in niche oddities and arousals. I have it set up so all of the products show up on the main page under most popular products. However, it will not stop listing them so when I have 500 products, my index body content has 500 products. I want to stop the display at 12 items. Below is the code, how do I change it so it stops after 12 products are displayed?

Code:

    <div id="our_prod">

    <h1>popular products</h1>

  <?

  $selprod=mysql_query("select p.products_id,pd.products_name ,p.products_image from products p,products_description pd where p.products_id=pd.products_id and pd.language_id=1 and p.special_status=1 and p.left_status");

  $cx=0;

  while($selprodD=mysql_fetch_array($selprod)){

  $cx=$cx+1;

  ?>

    <div <? if($cx%4==1){?>class="prod_dis" <? } else{?>class="prod_dis"<? }?>>

    <div class="tlt"><?=$selprodD['products_name'];?></div>

     <div class="img"><a href="#"><img src="images/<?=$selprodD['products_image'];?>" alt=""  width="125" height="65"/></a></div>

    <div class="btn"> <a href="<?=tep_href_link("product_info.php","products_id=".$selprodD['products_id']); ?>"><img src="images/buy_now_btn.gif" alt="" /></a></div>

       </div>

Thanks in advance! :thumbsup

select p.products_id,pd.products_name ,p.products_image from products p,products_description pd where p.products_id=pd.products_id and pd.language_id=1 and p.special_status=1 and p.left_status limit 12

Change the query line to

Code:

$selprod=mysql_query("select p.products_id,pd.products_name ,p.products_image from products p,products_description pd where p.products_id=pd.products_id and pd.language_id=1 and p.special_status=1 and p.left_status limit 12");

Simples.

ROCK & FUCKING ROLL!!! :thumbsup

Thanks!

Quote:

Originally Posted by bbobby86 (Post 18015329)

thread closed...

Until he asks how to get to the next 12 ;p

Quote:

Originally Posted by sarettah (Post 18015544)

Until he asks how to get to the next 12 ;p

I didn't go full retard here.

osCommerce is such a pile of shit.

Quote:

Originally Posted by GrouchyAdmin (Post 18015806)

osCommerce is such a pile of shit.

I think that is your comment towards every piece of software that you didnt create ;)

Quote:

Originally Posted by fris (Post 18017568)

I think that is your comment towards every piece of software that you didnt create ;)

It's still not as much of a pile of shit as WordPress, though.

well good luck dude :)