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.

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 Like 6 Dislike
Previous forums Next forums
Other forums

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

pass form variables straight to email, no database required?
hello all,

im working on this form...

http://www.adobedayevents.com/project_request/pr

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash