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_
trim function issues
Hi guys, total noob here...
So I've been tinkering around with a html and am using php to em
mysql UPDATE request not working and driving me crazy!!!
Hi,
I have been stuck on this for ages.
Quite simply I am trying to update my database
PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP
I've created an html form to allow the user to request a basic telephone dire
JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library
This is driving me nuts!
This insert query looks to be alright, however I get this error:
QuoteYou have an error in yo
getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI
INSERT for date range
Hi all
I have the following table
Code: [Select] `date` date
`day` int(2)
`
updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date t
output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish