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"> <B>Featured Auctions</b> <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
170
49
Other forums
Table Control
Hi Guru's,
I've created a Module pool program, which contains the Table Control.
PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v
Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm
Remore client postprocessing phase getting dump SAPSQL_ARRAY_INSERT_DUPREC
Hello Expects,I have started remore client copy. Data was copied successfully. but while running pos
sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.
fie
Switch letters in message (basic cryptology)...
I am trying to switch letters around in a message for an application on my site (see here). The prob
VAT
how should I deal with VAT?
if I have a product that costs £5.00 and VAT @ 17.5% (£0.87
Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb
eregi to preg
Im converting my regex for php 5.3 and I am stuck on the following
Code: [Select]if((eregi(&q
Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at