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();
?>

Your Answer:

Login to answer

Other forums

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

Get dump of MySQL DB from Live Site
I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

Mail from PHP form not always ending up in my inbox?
Hi guys,

I'm a real newbie to PHP and have managed to put together a simple mail form that se