Hi, First post here
I have a problem.. My Mysql database seems to skip the first entry completely..
IE:
you have the database:
-----------------
ID | entry |
-----------------
1 | This |
----------------
2 | is |
-----------------
3 | annoying|
-----------------
outputs: is, annoying
if it helps here's the part of my code I use to generate/display the data:
$sql = mysqli_query($link, "SELECT * FROM foto");
$row = mysqli_fetch_assoc($sql);
$array = array();
echo "<form method=\"POST\">
<input type=\"hidden\" name=\"id[]\" value=\"".$row['id']."\">";
while ($row = mysqli_fetch_assoc($sql))
{
echo "<input type=\"text\" name=\"foto[]\" value=".htmlspecialchars($row['foto'])."></input>";
}
echo "<input type=\"submit\" name=\"submit3\" value=\"update\"></input></form>";
thanks,