Code: Select all
$result = mysqli_query($link, 'SELECT Count(name) FROM signup WHERE tourny = "' . $tournyinfo['name'] . '"');
include 'bin/verifysql.php';
$row = mysql_fetch_array($result);+-------------+
| count(name) |
+-------------+
| 3 |
+-------------+
1 row in set (0.00 sec)
so $result should be a valid resource.
I have a line right under it that works:
Code: Select all
$result = mysqli_query($link, 'SELECT * FROM signup where tourny = "' . $tournyinfo['name'] . '"');
include 'bin/verifysql.php';
while ($row = mysqli_fetch_array($result))