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

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

Get ID from Database when Posting with a HTML Form
I have a form I am submitting to a MySql database. Each product has an ID # attached to it that auto

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Send current URL in URL with a $_GET variable problem.
Hello community,

I have created a function that gets the current variable of a page, example:

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

Php mysql - select?
Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid =

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <