reading row

[muppy]

Hi, i'm newbie with mysql and php, i have a table like this

value_x value_y value_z
data1 data2 data3
data4 data5 data6

But i have about 100 column
I whould read it following lines, obtaining this result:

data1 data2 data3

I can't use an SQL statement like select value_x, value_z from myTable, beaucose i have many column.

I tried this

while($row = mysql_fetch_array($rs)) {
while(list($key, $element) = each($row) {
echo $element;
echo "<br>";
}
}

but it gives me a result like this

data1
data1
data2
data2
data3
data3

Thanks!

Any suggestion??
Sorry for my bad english
Mario

[Eddymvp]

how about

$rs = mysql_query("select * from my table where value_x= 'data1'");
while ($row= mysql_fetch_array($rs))   {
echo"$row[value_z] <br>";
 }

[muppy]

sorry, it doesn't works: it gives similar result to my script 😕 😕

[Eddymvp]

a lo mejor tu esta haciendo algo mal. mandame un email contodo el codigo and dame un url a donde yo lo pueda ver.