Temp Row

[Xploder]

How do I display all the values in a table in order from top to bottom, one after the other?
So fahr It only does it with specific values:

$result = mysql_query("SELECT * FROM map");
$row = mysql_fetch_row($result);
echo $row["1"];

how do I siplify it to any values, just read them out?

 

[steven290]

you try running it through a loop, something like this

for ($i=0; $i<count($row); $i++) {
echo $row[$i]."<br>";
}

 

[Xploder]

no that doesn't work cause I could have repeated $i values.

 

[steven290]

?

repeated $i values

 

[nego78]

$result = mysql_query("SELECT * FROM map");
while ($row = mysql_fetch_row($result)) {
  echo $row[0]."<br>";
}

or when you specify columna names

$result = mysql_query("SELECT col1,col2 FROM map");
while (list($col1,$col2) = mysql_fetch_row($result)) {
  echo "col1: $col1 , col2: $col2 <br>";
}

gry online

 

[Xploder]

hmm, It doesn't work.

// works, but only if i values don't repeat in the table,
// if they do, any other occurance of it is ignored.
for ($i=0; $i<count($row); $i++) {
echo $row[$i]."<br>";
}

// works only for values of 1 in the table even if they
// repeat.
for ($i=0; $i<count($row); $i++) { // works, for repeated
echo $row["1"]."<br>";
}

my table look like this:
-----------
|id | land|
-----------
| 5 | 67 |
| 1 | 45 |
| 1 | 89 |
| 2 | 100|
| 1 | 34 |
| 2 | 12 |
| 4 | 35 |
-----------

I just want to get all the values output one after the other, without remembering all the values:

67, 45, 89, 100, 34, 12, 35

 

[steven290]

try

for ($i=0; $i<count($row); $i++) {
echo $row[$i].", ";
}

 

[Xploder]

for ($i=0; $i<count($row); $i++) {
echo $row[$i].", ";
}

It doesn't work because in a table such as above when $i is 1 it gets the value from the table, but then $i is 2 it won't get another row with a value of 1.

Does MySQL not have a function to get all the values from the 'land' column?

 

[Xploder]

oh, nevermind I fugured it out.

 

[steven290]

so what was it

 

[Xploder]

well I did this:

$query = "SELECT * FROM map WHERE id>0 ORDER BY id";
$result = mysql_query($query) or die(mysql_error());

while ($fetched = mysql_fetch_assoc($result)){
echo $fetched['land']
}

I don't really need order by id...