Re: php array saving only one record

[Peter Brawley]

1 To debug such a script fragment, echo the sql, ie ...

$sql = "...";

echo $sql;

... and inspect the values when it runs.

2. Calling mysqli_query(...) without either polling the result of the call or trapping errors is unsound. It hides problems. You need something like ...

$res = mysqli_query($connection, $sql);
If( !$res ) exit( mysqli_error($connection) );