start new row of pictures

Posted on 16th Feb 2014 07:03 pm by admin

on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get there picture on the homepage. currently the box limit is 6. If you increase the limit then it will display the images in a row side by side continuously. I need it to display 6 per row then start a new row of 6, so on, so on.

here is the current code:
Code: <? $feature_sql="select * from featuredproducts f,auction_details p where p.status='Active' and selling_method!='ads' and selling_method!='want_it_now' and home_feature='yes' and picture1!='' and p.bid_starting_date <= NOW() and f.productid=p.productid order by rand() limit 6";
$feature_res=mysql_query($feature_sql);
$tot_count=mysql_num_rows($feature_res);
if($tot_count!=0)
{
?>
<table border="0" align="center" cellpadding="0" cellspacing="0" width=574>
<tr>
<td colspan=4 height="30" valign="middle">
<table width="574" cellpadding="0" cellspacing="0" >
<tr>
<tr class="tdhead"><td width="1%" height="30" valign="top"><img src=templates/<?=$tfold?>/img_files/h_left.gif></td>
<td width="98%" height="30" valign="middle">&nbsp;<B>Featured Auctions</b>&nbsp;&nbsp;<a href="rssfeatured.php" target="_blank"><img src=templates/<? echo "$tfold" ?>/img_files/xml.gif border="0"></a></td>
<td width="1%" height="30" valign="top"><img src=templates/<?=$tfold?>/img_files/h_right.gif></td></tr>
</tr>
</table>
</tr></table>
<table border="0" align="center" cellpadding="0" cellspacing="0" width=574 class="ft_right">
<?
}
?>
<?
$count=0;
while($feature_row=mysql_fetch_array($feature_res))
{
$expire_date = $feature_row['expire_date'];
require 'ends.php';
$string_1=$feature_row[detailed_descrip];
$count=$count+1;
?>
<td valign=top>
<table cellpadding=5 cellspacing=2>
<td >
<? if(empty($feature_row['picture1']))
{ ?>
<table height="49" border="0" cellpadding=0 cellspacing=0>
<tr>
<td height="12" background="templates/<? echo "$tfold" ?>/img_files/window_01.gif" ></td>
</tr>
<tr>
<td background="templates/<? echo "$tfold" ?>/img_files/window_03.gif" >

<table border="0" cellpadding="0" cellspacing="0" width=77>
<tr valign="top">
<td align="center">
<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>">
<? echo $featured_row['producttitle']; ?>
<img src="templates/<? echo "$tfold" ?>/img_files/noimage2.gif" width=<?= $w; ?> height=<?=$h?> border=0>
</a>
</td>
</tr>
</table>
</td>
</tr><tr>
<?
$bid_sql="select * from site_bids where productid=".$feature_row['productid'];
$bid_res=mysql_query($bid_sql);
$bid_tot_row=mysql_num_rows($bid_res);
if($bid_tot_row!=0)
{
$bid_row=mysql_fetch_array($bid_res);
$curprice=$bid_row['bidding_amount'];
}
else
{
$curprice=$feature_row['min_bid_amount'];
}
if($feature_row['selling_method']=="fix")
{
$curprice=$feature_row['quick_buy_price'];
}
?>
<td valign=top align="center">
<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>">
<? echo $feature_row['producttitle'];?></a>
<? echo "Price: ".$feature_row['currency']." ".$curprice; ?>


<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>" style="text-decoration:none;">

<?= $string_difference; ?>
</a>
</td>
</tr>
</table>

<?
}
else
{

$img=$feature_row['picture1'];
list($width, $height, $type, $attr) = getimagesize("uploads/$img");
$h=$height;
$w=$width;
if($h>60)
{
$nh=60;
$nw=($w/$h)*$nh;
$h=$nh;
$w=$nw;
}
if($w>60)
{
$nw=60;
$nh=($h/$w)*$nw;
$h=$nh;
$w=$nw;
}

?>
<table height="49" border="0" cellpadding=0 cellspacing=0 align=center>
<tr>
<td height="12" ></td>
</tr>
<tr>
<td align=center>
<center>
<table border="1" cellpadding="0" cellspacing="0" width=65 height=65 bordercolor="#000000">
<tr valign="top">
<td align="center" bgcolor="#ffffff">
<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>">
<? echo $featured_row['producttitle']; ?>
<img src="uploads/<? echo $feature_row['picture1']; ?>" width=<?= $w; ?> height=<?=$h?> border=0>
</a>
</td>
</tr>
</table></center>
</td>
</tr>
<tr>
<?
$bid_sql="select * from site_bids where productid=".$feature_row['productid'];
$bid_res=mysql_query($bid_sql);
$bid_tot_row=mysql_num_rows($bid_res);
if($bid_tot_row!=0)
{
$bid_row=mysql_fetch_array($bid_res);
$curprice=$bid_row['bidding_amount'];
}
else
{
$curprice=$feature_row['min_bid_amount'];
}
if($feature_row['selling_method']=="fix")
{
$curprice=$feature_row['quick_buy_price'];
}
?>
<td valign=top align="center">
<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>">
<? echo $feature_row['producttitle'];?></a>
<? echo "Price: ".$feature_row['currency']." ".$curprice; ?>


<a href="itechd.php?productid=<? echo $feature_row['productid']; ?>" style="text-decoration:none;">

<?= $string_difference; ?>
</a>
</td></tr>

</table>
<?
}
?>
</td>
</tr>
</table>
</td> <?
}
?>
<? if($tot_count!=0)
{ ?>
</tr>
</table>

<?
}
?>

Your Answer:

Login to answer

Other forums

natcasesort works on one server but not on another
Hi

I have a problem that I was hoping that someone can help me with.

I'm trying to use

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Product categories for registration
Dear all,

We are going live with the Supplier registered next week. At standard, the 'sel

A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.ran

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '