It's not incrementing $c. Start out with $c=0;, then Add $c++; after
the while line (not after the whole while statement).

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

Reply via email to