Fairly new to PHP and have the following code which should simply output into 3 columns - I have checked the query which does work - so I dont understand why I get this error
mysql_fetch_array() expects parameter 1 to be resource,
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = “SELECT * FROM duration_matched WHERE groupm = '”.$coincidence ."’";
$result = $conn->query($sql);
// set up loop counter
$col_count = 0;
// start table and first tr
echo ‘
’;
while ($row=mysql_fetch_array($result)) {
// if you have output 3 cols then end tr and start a new one
if ($col_count == 3) {
echo ‘
’;
// and reset the col count
$col_count = 0;
}
// always output the td
echo ‘
’;
// and count the column
$col_count++;
}
// then close off the last row and the table
echo ‘
’ . $row[‘image’] . ‘
’;
$conn->close();
