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
Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_
Undefined offset
The following script checks to see if the user answer matches the correct answer.
Form Fiel
Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g
Comparing MySql data and arrays.
I have a mysql table set up like this:
idsubjectbodyuseriddatetimetags1blog subjectblog body111|2
How to get exact 3 moths post date from today date using javascript
How to get exact 3 moths post date from today date using javascript
Please help
array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e
Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver
Greek characters in php
Hi,
I'm making a script and I m using for first time greek characters.
I started to write
problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t
Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter