It's not incrementing $c. Start out with $c=0;, then Add $c++; after
the while line (not after the whole while statement).
Advertising
Like this:
$c = 0;
print("<tr>");
while($row = mysql_fetch_array($dbResult))
$c++;
{
print("<td>{$row['server_name']}</td>");
if(($c % 4) == 0)
{
print("</tr><tr>");
}
}
You'll also need a print("</tr></table>") at the end, but I assume
you knew that...
--- "Chevalier, Arthur" <[EMAIL PROTECTED]> wrote:
> You are right about my query. I am only pulling down one column.
>
> As you guys can probably tell I am pretty inexperienced with this.
> I tried
> what you said and still got the same results.
>
> Here are snippets of my code and maybe this will depict what I am
> doing
> wrong:
>
> After creating the connection:
>
> $query = "select server_name from servers where midtier =
> '$server'";
> $dbResult = mysql_query($query,$dblink);
>
> $c = 1;
> print("<tr>");
> while($row = mysql_fetch_array($dbResult))
> {
> print("<td>{$row['server_name']}</td>");
> if(($c % 4) == 0)
> {
> print("</tr><tr>");
> }
> }
>
>
>
> -----Original Message-----
> From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 05, 2002 3:26 PM
> To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] MySQL Array
>
> I think he meant that he is only pulling one column, i.e. "field1"
> with each
> mysql_fetch_array and he wants that in four columns.
>
> $c = 1;
> echo "<tr>";
> while($ar = mysql_fetch_array($result))
> {
> echo "<td>{$ar['field1']}</td>";
> if(($c % 4) == 0) { echo "</tr><tr>"; }
> }
>
> You'll have to account for incomplete rows and clean up the output,
> but
> hopefully that gives you an idea.
>
> ---John Holmes...
>
> ----- Original Message -----
> From: "Ryan Jameson (USA)" <[EMAIL PROTECTED]>
> To: "Art Chevalier" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Thursday, December 05, 2002 3:05 PM
> Subject: RE: [PHP-DB] MySQL Array
>
>
> while ($ar = mysql_fetch_array($rs))
> echo "<tr><td>".
> $ar['field1']."</td><td>".$ar['field2']."</td></tr>";
>
>
> Make sense?
>
> -----Original Message-----
> From: Art Chevalier [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 05, 2002 12:44 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MySQL Array
>
>
> Hello,
>
> I am pulling one column out of a MySQL table in an array. I want
> to place
> each element into a HTML table 4 rows across. I am currently doing
> this
> with the mysql_fetch_array() function. How can I pull out 4 array
> elements
> in one pass through a while loop?
>
> Thanks
>
> Art Chevalier
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
=====
Mark Weinstock
[EMAIL PROTECTED]
***************************************
You can't demand something as a "right" unless you are willing to fight to death to
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***************************************
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
