RE: [PHP] Re: Table formatting -- PARTIALY SOLVED
why would you expect a for loop to know whether there was an array returned
from the mysql_fetch_array($result). you haven't told it to check this. This
is why I suggested using the fetch_array() to control the loop and a counter
to determine when to start and end rows - did you not get that?
Tim Ward
www.chessish.com
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: 29 July 2002 16:39
To: 'Martin Towell'; [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Table formatting -- PARTIALY SOLVED
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_fet
RE: [PHP] Re: Table formatting -- PARTIALY SOLVED
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
RE: [PHP] Re: Table formatting -- PARTIALY SOLVED
I just found a new problem when using the solution Martin tells me
below... if I take out one record from the DB, leaving just 3 objects,
the web page displays:
row1 = 2 objects in two columns
row2 = 1 object in the first column and a *NOT DISPLAYED* image in the
2nd column... how can I override this fourth image from *TRYING TO*
showing?
Thanx a lot, C.
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 12:39 PM
To: 'Martin Towell'; [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Table formatting -- PARTIALY SOLVED
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_fet
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
Re: [PHP] Re: Table formatting
On Monday 29 July 2002 11:27, César Aracena wrote: 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??? Not sure if I understand your question. To nest for-loops you have to use a different counter for each loop. Eg, if you're using $i for the outer-loop you can use $j for the inner-loop. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Some people's mouths work faster than their brains. They say things they haven't even thought of yet. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
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
RE: [PHP] Re: Table formatting
I'd use the following code:
--
// DB QUERY
$query = SELECT columnFirst, columnSecond, columnThird FROM table_name;
$result = mysql_query($query) or die(mysql_error());
// NOW THE LOOP
while ($row = mysql_fetch_assoc($result))
{
echo tr;
echo td;
echo join(/tdtd, $row);
echo /td;
echo /tr;
};
--
-Oorspronkelijk bericht-
Van: Chris Earle [mailto:[EMAIL PROTECTED]]
Verzonden: 27 July 2002 06:54
Aan: [EMAIL PROTECTED]
Onderwerp: [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
