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
Wierd if else problem
Hi guys,
this probably aint wierd for you, but it seems like php is playin up to me. may b i
check how many commas the variable containing the query has between [i]select[/i
Hi...
iv made an sql table that contains id number - name of sql query and an sql query.
T
quick basic question, hopefully not dumb
I don't know how to search for this, so forgive me if it's been covered...
I often see an exa
getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI
Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but
Warning: mysql_num_rows() supplied argument is not a valid MySQL result resource
This may be simple I just may need another pair of eyes..
When i get records back the below c
PHP MySQL and DATE
Hi everyone
I have a databse and in one of the columns I have date values such as 2009-March-
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else
I can give them an F
Join Query Help
Hi all,
I am having problems with the below code, which we shall call 'my first join query'!
Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.