Table trouble
Posted on
16th Feb 2014 07:03 pm by
admin
i have been reading the forum for a few weeks and decided to join. i like the format and the advice given is great.
anywho here is my table, the issue i have is that i am displaying pictures from a user on said users profile. pics of items they have within the site.
Did you know?Explore Trending and Topic pages for more stories like this.
they are showing fine, trouble is i cant seem to get them to wrap within the page, they are just making the page wider and wider when more pictures are added instead of wrapping and forming a group rather than a line of images screwing up the page dimensions.
any tips of help, im at a total loss and at my wits end trying to make this work.
$col=$db->query("SELECT iv.*,i.*,it.* FROM collections iv LEFT JOIN items i ON iv.collection_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.collection_userid={$r['userid']} ORDER BY i.itmtype ASC");
if ($db->num_rows($inv) == 0)
{
print "Member has not started a collection";
}
else
{
print "<table width=100% class="table" border="0" cellspacing="1">";
$lt="";
while($i=$db->fetch_row($col))
{
if($lt!=$i['itmtypename'])
{
$lt=$i['itmtypename'];
print "n<tr><td><b>{$lt}</b></td></tr>";
}
if ($i['inv_qty'] > 1)
print"</td><td><img src='colpics/{$i['itmpic']}' height='120' width='120' title='{$i['itmdesc']}'>";
}
}
$h->endpage();
?>
No comments posted yet
Your Answer:
Login to answer
273
6
Other forums
Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th
Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc
Troubles with a spider class
I am building a spider that will crawl through random whitepages (eg. anywho.com, switchboard.com, w
Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?
php mysql script to find record
Hi,
Currently I have a simple table with 4 columns. A, B, C, D
If I want to find all
Embed Video Problem
Hey, thanks for looking!
File to be embedded:
Code: <playlist version="1&q
Need help with unexpected T-STRING error
I'm a newbie and I'm still learning PHP. However this error has me stumped. I've googled, searched t
PHP form authentication
Hi guys,
what am trying to achieve is this: Whenever a user tries to login to my website, an
Error when call dll from oracle
Hi all, please help me!
I have dll write C language, I want call it from oracle procedur
mysql select query problem
how can i select multiple fields from multiple table in one query like
i have table name t1 a