Hello I have this code :
Code: Select all
<?php
$con=mysqli_connect("login info here");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT events.*, signup.status FROM events, signup ");
//$result = mysqli_query($con,"SELECT events.*, signup.status FROM events, signup ");
echo "<table class='TFtable'><tr><td>Name</td><td>Event ID</td><td>Location</td><td>Time / Date</td><td>Lead</td><td># Needed</td><td>Complete?</td><td>Materials</td><td>Teacher</td><td>Duration</td><td>Summary</td><td>Signed Up</td></tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['eventname'] . "</td>";
echo "<td>" . $row['eventid'] . "</td>";
echo "<td>" . $row['location'] . "</td>";
echo "<td>" . $row['time'] . "</td>";
echo "<td>" . $row['lead'] . "</td>";
echo "<td>" . $row['need'] . "</td>";
echo "<td>" . $row['complete'] . "</td>";
echo "<td>" . $row['materials'] . "</td>";
echo "<td>" . $row['teacher'] . "</td>";
echo "<td>" . $row['duration'] . "</td>";
echo "<td>" . $row['eventsummary'] . "</td>";
$row1 = mysqli_fetch_array(SELECT COUNT(status) FROM signup WHERE eventid='$row['eventid']' and status='yes';)
echo "<td>" . $row1 . "</td>";
}
echo "</tr>";
echo "</table>";
echo "<br><br><br><br>";
mysqli_close($con);
?>Parse error: syntax error, unexpected 'COUNT' (T_STRING) in /home/howto570/public_html/dmcisc/home/index.php on line 55
Line 55 is:
$row1 = mysqli_fetch_array(SELECT COUNT(status) FROM signup WHERE eventid='$row['eventid']' and status='yes';)
Thanks