Page 1 of 1

PHP MYSQL Errir

Posted: Fri Feb 13, 2015 7:42 pm
by Trevor
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 :

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);
?>
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

Re: PHP MYSQL Errir

Posted: Fri Feb 13, 2015 8:05 pm
by requinix
This is actually a PHP problem: you didn't put quotes around your query.

Did you not notice that or were you not aware you have to use quotes in PHP?

Re: PHP MYSQL Errir

Posted: Sat Feb 14, 2015 6:21 am
by Celauran
Also, that query is passed as a parameter to mysqli_fetch_array instead of mysqli_query.