getting multiple columns per row from databse query

2001-11-15 Thread chip . wiegand 

I have a database that is names and addresses. I want to make a web page
that will display those
names and addresses in a table with 4 columns per row, as many rows as necessary. The 
little
if statement below works to make 2 columns, but when I change the number to 3 or 
higher it no longer
works properly - I get the 3 or more columns wrapped to look like multiple rows. 
(there's on long line,
hopefully it will wrap properly).

?
(html and connection lines snipped)...
$sql = select * from brochures;
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
printf(td%sbr%sbr%sbr%sbr%sbr%s, %s %s/td\n, $row[Account], 
$row[name], $row[email], $row[Address], $row[Address2], $row
[City], $row[State], $row[Zip]);
if ($i % 2)
{
echo /tr\ntr\n;
}
$i++;
}
?

--
Chip W



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: getting multiple columns per row from databse query

2001-11-15 Thread Bill Adams 

Try:

$i++;
if( $i % 3 == 0 ){
  echo /tr\ntr\n;
}


b.
mysql

[EMAIL PROTECTED] wrote:

 I have a database that is names and addresses. I want to make a web page
 that will display those
 names and addresses in a table with 4 columns per row, as many rows as necessary. 
The little
 if statement below works to make 2 columns, but when I change the number to 3 or 
higher it no longer
 works properly - I get the 3 or more columns wrapped to look like multiple rows. 
(there's on long line,
 hopefully it will wrap properly).

 ?
 (html and connection lines snipped)...
 $sql = select * from brochures;
 $result = mysql_query($sql);
 while ($row = mysql_fetch_array($result))
 {
 printf(td%sbr%sbr%sbr%sbr%sbr%s, %s %s/td\n, $row[Account], 
$row[name], $row[email], $row[Address], $row[Address2], $row
 [City], $row[State], $row[Zip]);
 if ($i % 2)
 {
 echo /tr\ntr\n;
 }
 $i++;
 }
 ?

 --
 Chip W

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Bill Adams
TriQuint Semiconductor




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: getting multiple columns per row from databse query

2001-11-15 Thread chip . wiegand 


Thanks Bill,
That works great.

Much appreciative,

Chip





Bill Adams [EMAIL PROTECTED]@tqs.com on 11/15/2001 10:31:45 PM
Internet mail from:

Sent by:  [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:   [EMAIL PROTECTED]

Subject:  Re: getting multiple columns per row from databse query


Try:

$i++;
if( $i % 3 == 0 ){
  echo /tr\ntr\n;
}


b.
mysql

[EMAIL PROTECTED] wrote:

 I have a database that is names and addresses. I want to make a web page
 that will display those
 names and addresses in a table with 4 columns per row, as many rows as
necessary. The little
 if statement below works to make 2 columns, but when I change the number
to 3 or higher it no longer
 works properly - I get the 3 or more columns wrapped to look like
multiple rows. (there's on long line,
 hopefully it will wrap properly).

 ?
 (html and connection lines snipped)...
 $sql = select * from brochures;
 $result = mysql_query($sql);
 while ($row = mysql_fetch_array($result))
 {
 printf(td%sbr%sbr%sbr%sbr%sbr%s, %s %s/td\n, $row
[Account], $row[name], $row[email], $row[Address], $row
[Address2], $row
 [City], $row[State], $row[Zip]);
 if ($i % 2)
 {
 echo /tr\ntr\n;
 }
 $i++;
 }
 ?

 --
 Chip W

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Bill Adams
TriQuint Semiconductor









-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php