Thnx a lot Martin and all, this worked. Anyway, apart of this being a logical solution (I almost kill myself for not thinking it before), why is that the FOR looping (before using that division operator) worked in such a strange way? Isn't it supposed to stop looping if nothing else is fetched from the DB?
Pardon my interest in learning, but this is how I am. Thanks a lot, C. > -----Original Message----- > From: Martin Towell [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 2:05 AM > To: 'César Aracena'; [EMAIL PROTECTED] > Subject: RE: [PHP] Re: Table formatting > > try changing these two lines > > $num_rows = mysql_num_rows($result); > $num_cols = 2; > > to this > > $num_cols = 2; > $num_rows = mysql_num_rows($result) / $num_cols; > > this isn't the full solution, but will help you on your way... > > HTH > Martin > > -----Original Message----- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 2:03 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] Re: Table formatting > > > I know no one in this list like to think we newbie's want the job done > for us, so I'm trying to figure out the below question myself, but trust > me when I say it's making me nuts... this is my best shot so far: > > $query = "SELECT * FROM saav_arts ORDER BY artid"; > $result = mysql_query($query) or die(mysql_error()); > $num_rows = mysql_num_rows($result); > $num_cols = 2; > > for ($x = 0; $x < $num_rows; $x++) > { > echo "<tr>"; > > for ($i = 0; $i < $num_cols; $i++) > { > > $row = mysql_fetch_array($result); > echo "<td align=\"center\">"; > echo "<a href=\"details.php?artid=".$row[artid]."\"><img > src=\"".$CFG->artdir."/".$row[artsmall]."\" > ALT=\"".$row[artname]."\" BORDER=\"0\"></a>"; > echo "</td>"; > } > > echo "</tr>"; > } > > The thing is that it shows up two columns as I want, but not the 4 > images that I have in DB... it shows 2 rows of 2 images each and antoher > 2 rows of 2 *NOT DIPLAYED* images which I don't have... like it was > looping again with nothing to fetch from the DB... What is this? > > Jason: as I wrote this, your tip came over and as you can see I did > figure it out (almost melted my brain though)... now, do you know what > is going on? > > Thanx, C. > > > -----Original Message----- > > From: César Aracena [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 29, 2002 12:27 AM > > To: 'Chris Earle'; [EMAIL PROTECTED] > > Subject: RE: [PHP] Re: Table formatting > > > > I like this method a lot. Now, considering I do like FOR looping as a > > fact, how can I make a loop inside another loop. I mean, if I tell the > > first loop that $i=0 and then do the comparison and then add 1 to $i, > in > > the inner or second loop should I state that $i=$i or what? Also make > it > > $i=0??? > > > > Thanks, C. > > > > > -----Original Message----- > > > From: Chris Earle [mailto:[EMAIL PROTECTED]] > > > Sent: Saturday, July 27, 2002 1:54 AM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP] Re: Table formatting > > > > > > You can do what he said or just put a separate loop inside the > > original > > > loop. > > > > > > Depending on how you get the info, you can use either way (his would > > > create > > > less overhead if you are just using the same <TD> info every row, > > > otherwise > > > they're really the same because his way you'll have to create an > array > > to > > > access later for multiple rows, or just do my way and have the loop > > access > > > the NEXT *3* (or whatever) items ...). > > > > > > i.e., > > > for (LOOP FOR <TR>) > > > { > > > for (LOOP FOR <TD>) {} > > > } > > > > > > "César aracena" <[EMAIL PROTECTED]> wrote in message > > > 001a01c234f0$a5e8ad80$28ed0dd1@gateway">news:001a01c234f0$a5e8ad80$28ed0dd1@gateway... > > > Hi all. > > > > > > Last nite I've came across a problem I wasn't able to figure out by > my > > > self. It's not difficult to make a loop that will make new *TABLE > > ROWS* > > > (<tr>) to show several DB objects in a nice way. what I need to do, > is > > > to display 2 or maybe even 3 of this objects stored in a DB per > table > > > row, separated in different *TABLE COLUMS* (<td>). how can I achieve > > > this? What I usually do is: > > > > > > ------------------------------ > > > // DB QUERY > > > $query = "SELECT * FROM table_name"; > > > $result = mysql_query($query) or die(mysql_error()); > > > $num_rows = mysql_num_rows($result); > > > > > > // NOW THE LOOP > > > for ($i=0; $i<$num_rows; $i++) > > > { > > > $row = mysql_fetch_array($result); > > > echo "<tr>"; > > > echo "<td>"; > > > echo $row[whatever]; > > > echo "</td>"; > > > echo "</tr>"; > > > } > > > ------------------------------ > > > > > > but how can I get 2 or 3 columns displaying different db objects? A > > loop > > > inside a loop? > > > > > > Thanks in advance, > > > > > > <mailto:[EMAIL PROTECTED]> Cesar Aracena > > > CE / MCSE+I > > > Neuquen, Argentina > > > +54.299.6356688 > > > +54.299.4466621 > > > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
