The below code works just fine:
Code: Select all
$query = "SELECT * FROM filenames";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$orig_name = $row["orig_name"];
$new_name = $row["new_name"];
echo "$orig_name<br>";
}Code: Select all
$query = "SELECT * FROM filenames";
$result = mysql_query($query);
foreach(mysql_fetch_array($result) AS $key => $value){
$row = mysql_fetch_array($result);
$orig_name = $row["orig_name"];
$new_name = $row["new_name"];
echo "$orig_name<br>";
}Any ideas what the problem could be? Of course I can simply use the code that works but I would like to know why the other code behaves so odd.
Thanks!
Tomas