Please,help me!

[Anon]

hello!
i have a table with the next code:

<?
$connection = mysql_connect("localhost","nobody","");
$db = mysql_select_db("price");
$result = mysql_query("SELECT * FROM pricelist where Field1 like 'FDD 1 44MB%'");
echo "<table cellpadding=2 cellspacing=0
border=0><tr><td><b>Description</b></td><td><b>Currency</b></td><td><b>Price</b></td></tr>";

                $alternate = "2"; 
                while ($row = mysql_fetch_array($result)) { 
                $Field1 = $row["Field1"]; 
                $Field2 = $row["Field2"];
                $pr1 = sprintf ("%01.2f", $row["pr1"]); 

                if ($alternate == "1") { 
                $color = "#6699FF"; 
                $alternate = "2"; 
                } 
                else { 
                $color = "#FFFfcc"; 
                $alternate = "1"; 
                } 
                echo "<tr bgcolor=$color><td>$Field1</td><td>$Field2</td><td>$pr1</td><td></tr>"; 
                } 
                echo "</table>"; 
                ?> 

but the results from Field2 pr1 come out on the left .please,let me know if there is any way to put the result in the center not in the right.

i will be thankful for any help!

Ivelina

[Anon]

Hi Ivelina!

you have to put in a "align"
it would look like this:
echo "<tr bgcolor=$color align="center"><td>$Field1</td><td>$Field2</td><td>$pr1</td><td></tr>";

have a nice day 🙂

[techek]

Have you tried this :

<?php
$line = 0;
while ($row = mysql_fetch_array($result)) {
if ($line % 2) {
$color = "#6699FF";
} else {
$color = "#FFFfcc";
}
$line++;

}

[Anon]

Hello Both Tamino and Jacob !

thank you very much for your help!
All the best to you!
Ivelina