Error php and mymql

Question

First time programming a simple database. But I cant figure out how to solve this error:

Parse error: syntax error, unexpected '$row' (T_VARIABLE) in W:...\index.php on line 39

This is my script..

$result = mysqli_query($link,"SELECT * FROM studenten");

echo "<table border='1'>

<tr>
<th>first name</th>
<th>last name</th>
<th>studentnummer</th>
</tr>";

while($row = mysqli_fetch_array($result)) {

  id = $row[id]; //this is line 39
  echo "<tr>";
  echo "<td>" . $row['voornaam'] . "</td>";
  echo "<td>" . $row['studentnummer'] . "</td>";
  echo "<td> <a href ='edit.php?id_student=$id'>Edit</a>";
  echo "<td> <a href ='delete.php?id_student=$id'><center>Delete</center></a>";
  echo "</tr>";
}                     

echo "</table>";

can someone help me?

Not enough coffee yet. Change that row to be `$id = $row['id'];` Note the `$` for the variable and the quotes around the array key identifier. — Jay Blanchard, Jun 05 '15 at 12:47
@Jay Blanchard how to store value in variable inside the loop it returns in array format — Karthik Keyan, Jun 05 '15 at 12:51
Not possible to store the variable inside the loop i this it stored in array format like $id[] = $row['id']; — Karthik Keyan, Jun 05 '15 at 12:55
Guys, You we are all putting minus to question , It just a question — Karthik Keyan, Jun 05 '15 at 12:58

Ankh · Answer 1 · 2015-06-05T12:47:21.903

1

id = $row[id]; //this is line 39

Shouldn't that be

$id = $row['id']; //this is line 39

You're missing the $ from your id variable and quotes for your array key.

edited Jun 05 '15 at 12:47

answered Jun 05 '15 at 12:46

Ankh

5,478
3
36
40

score 1 · Answer 2 · answered Jun 05 '15 at 12:48

1

use

mysqli_fetch_assoc

because

mysqli_fetch_array

returns a indexed array

and on line 39

$id = $row['id'];

answered Jun 05 '15 at 12:48

PHP Worm...

4,109
1
25
48

Error php and mymql

2 Answers2