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
Keeping data in form
How can I keep whatever I write in the form?
Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm
ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al
Procedural to OOP
ohn Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pri
using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto
gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d
PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48
strptime() equivalent for php4 ?!
Greetings!
this is my first post, thank you in advance for your replies.
Well, the ti
Typing math
I've added support for typesetting math using LaTeX on the forums.
Example:
Code: [Select]
want to add a break after a certain amount of characters
i was wondering how to add a break in a blog post after a certain amount of characters... any idea o