PHP MYSQL Errir
Posted: Fri Feb 13, 2015 7:42 pm
I am trying to make it so that it displays a table with the data from the one table on the first bunch of columns but on the last colum it is supposed to take the event id and see how many times it appears in the signup tree with the status set to yes:
Hello I have this code :
And I'm getting this error:
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
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