PHP/MySql help... - GoFuckYourself.com

TripleXPrint · 03-30-2011, 01:33 PM

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!

tical · 03-30-2011, 01:36 PM

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

redwhiteandblue · 03-30-2011, 01:37 PM

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.

TripleXPrint · 03-30-2011, 01:40 PM

ROCK & FUCKING ROLL!!!

Thanks!

mafia_man · 03-30-2011, 01:41 PM

..............

bbobby86 · 03-30-2011, 01:47 PM

thread closed...

sarettah · 03-30-2011, 02:54 PM

Quote:

Originally Posted by bbobby86

thread closed...

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

TripleXPrint · 03-30-2011, 03:19 PM

Quote:

Originally Posted by sarettah

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

I didn't go full retard here.

GrouchyAdmin · 03-30-2011, 04:52 PM

osCommerce is such a pile of shit.

fris · 03-31-2011, 10:46 AM

Quote:

Originally Posted by GrouchyAdmin

osCommerce is such a pile of shit.

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

GrouchyAdmin · 03-31-2011, 10:52 AM

Quote:

Originally Posted by fris

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.

Dappz · 03-31-2011, 10:54 AM

well good luck dude

03-30-2011, 01:37 PM	#3
redwhiteandblue Bollocks Industry Role: Join Date: Jun 2007 Location: Bollocks Posts: 2,792	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. __________________ Interserver unmanaged AMD Ryzen servers from $73.00

03-30-2011, 01:40 PM	#4
TripleXPrint Confirmed User Join Date: Apr 2007 Posts: 983	ROCK & FUCKING ROLL!!! Thanks! __________________ Skype: Triplexprint

03-30-2011, 01:41 PM	#5
mafia_man Confirmed User Industry Role: Join Date: Jul 2005 Location: icq#: 639544261 Posts: 1,965	.............. __________________ I'm out.

03-30-2011, 01:47 PM	#6
bbobby86 partners.sexier.com Industry Role: Join Date: Jan 2007 Location: San Francisco, CA Posts: 11,926	thread closed... __________________

03-30-2011, 04:52 PM	#9
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	osCommerce is such a pile of shit. __________________ AIM: GrouchyGfy

03-30-2011, 01:36 PM	#2
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	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

03-31-2011, 10:54 AM	#12
Dappz Confirmed User Join Date: Dec 2009 Posts: 997	well good luck dude __________________ Hentai Artist * Draw My Anime * HentaiLovers * hentaiG4H * ICQ : 657458