Two snippets of PHP code:
The first one works fine, giving values from different rows sequentially.
while ($row = mysql_fetch_assoc($rst)) {
...
$link1 = $row['audio1'];
if ($link1) {
$link1 = $link1;
}
...
}
The second one outputs the value from the first row and applies it to every subsequent row.
while ($row = mysql_fetch_assoc($rst)) {
...
if ($row['audio1']) {
$link1 = $row['audio1'];
}
...
}
I.e. where the first code sample generates
Audio1.mp3
Audio2.mp3
Audio3.mp3
the second one would generate
Audio1.mp3
Audio1.mp3
Audio1.mp3
The question is why those two similar implementations differ in output.
Another test case with ...s removed (clean loop code) yields a different picture: the first example only outputs one line (the first one), the second example's output is the same which is repeating lines.
MySQL table that is being used has the following structure: One table, INT (id), CHAR, SMALLINT, TINYTEXT, TEXT, TEXT, TINYTEXT (audio1). All of the rows are fully populated except for the last one (audio1) which is mostly empty and has non-NULL values somewhere in the middle (if we sort by id field). Replacing the 'audio1' with another column name yields correct results (for that field) in both cases.
Another addition is that I do indeed place a SELECT statement initially in mysql_query that filters out rows. Depending on the number of rows being returned the picture for the second example may be slightly different, like 3 non-repeating values followed by a repetition of the third value until the end.
