$row[ variable here? ]

[xcandiottix]

Say I have a table with 3 fields.

How can I ...

$i = 3
for($x = 0 ; $x < $i ; $x++){
  echo $row[$x];
}

 

I've tried [$x],['$x'], etc but nothing seems to work ... any ideas?

 

Thanks!

[trq]

Were going to need more info. Syntax wise, there is nothing wrong with the code you have posted.

[xcandiottix]

To claify this a little better here's my table:

ID | 1 | 2 | 3

1 | red | green | blue

 

I want to echo out: red, green, blue. But the number of columns later on maybe become bigger:

 

ID | 1 | 2 | 3 | 4 | 5

1 | red | green | blue | orange | black

 

So I need any $row calls to anticipate this...

mysql_connect()
mysql_select_db()
$query = "Select * FROM table WHERE ID = 1";
$result = mysql_query($query);

$i = 1;
for($x = 0; $x < $i; $x++){
$row = mysql_fetch_assoc($result);
if($row[$x] !== ""){
echo "Color".$x."=".$row[$x];
$i++;
}
}

 

The problem is I can't seem to get $row to work with a variable with in the brackets ... not sure if anyone can spot a work around. 

 

As a side note, if I change

 

echo "Color".$x."=".$row[$x];

 

to

 

echo "Color".$x."=".$row['1'];

 

then I get "Color1=red Color2= Color3= etc" echoed. So it works ... the var is hanging up it seems.

 

[trq]

$row is an associative array in your case.

 

Your best off using a foreach.

 

mysql_connect()
mysql_select_db()
$query = "Select * FROM table WHERE ID = 1";
if ($result = mysql_query($query)) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      foreach ($row as $k => $v) {
        echo "Color $k = $v<br />";
      }
    }
  }
}

[trq]

Oh, and if your only expecting one result, you don't need the while....

 

mysql_connect()
mysql_select_db()
$query = "Select * FROM table WHERE ID = 1 LIMIT 1";
if ($result = mysql_query($query)) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    foreach ($row as $k => $v) {
      echo "Color $k = $v<br />";
    }
  }
}

[xcandiottix]

Yes! Thank you Thorpe it works beautifully.