big select with for-loop

[Ph_Schmidt]

Hi.
I've gotta Problem:
There're 5 columns named column1 to column5.
I wanted to select every entry in the table.

for ($i=1; $i <= 5; $i++) { 
$sql_select = "SELECT column".$i." FROM test"; 
$result = mysql_query($sql_select, $db); 
if($result) { 
    ${"column".$i."_row"} = mysql_fetch_row($result); }} 

The arrays fill up a table..

<?php echo $column1_row[0]; ?>
<?php echo $column1_row[1]; ?>
<?php echo $column1_row[2]; ?>
<?php echo $column1_row[...]; ?>
<?php echo $column2_row[0]; ?>
<?php echo $column1_row[1]; ?>
<?php echo $column1_row[...]; ?>

He writes the first row with index [0].
index[0] to index[...] failed:
Undefined offset: 1
He doesnt read
<?php echo $column1_row[1]; ?>
<?php echo $column2_row[1]; ?>
<?php echo $column3_row[1]; ?> etc.
Why?
Philipp

[zhabala]

Because you are not working with array here:

${"column".$i."_row"} = mysql_fetch_row($result); }}

it should look like

${"column".$i."_row"[]} = mysql_fetch_row($result); }}

or (am not sure just now)

${"column".$i."_row"}[] = mysql_fetch_row($result); }}

--------- but it seems to be a really bad idea to work this way with the data

because you can SELECT * FROM test
the mysql_fetch_array into some array. It depends on what are you trying to do.

Zdenek

[Ph_Schmidt]

thanks.
you're right the select * method is the right way.