mysql_query行值迭代问题

Question

I have a problem iterating through an sql query:

$result = mysql_query("SELECT * FROM transactions");

while($row = mysql_fetch_array($result)) {
// this returns 3 rows 

foreach ($row as $values) 
{ 
//fputcsv($a_csv, $values;
echo $values;
}   

}

The script iterates fine but it appears to be going through each row twice. So what I receive in output is the following:

value1value1value2value2value3value3

I'm not sure why this is - could anyone explain please?

Thankyou

Answer 1

You need to access $row like this $row[0] And $row shouldn't be in a foreach() itself unless it too is some kind of array you need to iterate through.

$result = mysql_query("SELECT * FROM transactions");

while($row = mysql_fetch_row($result)) 
{
    echo $row[0];
    echo $row[1];
    // ... etc.
}