PHP MYSQL Errir

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Trevor
Forum Newbie
Posts: 1
Joined: Fri Feb 13, 2015 7:38 pm

PHP MYSQL Errir

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: PHP MYSQL Errir

Post 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?
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: PHP MYSQL Errir

Post by Celauran »

Also, that query is passed as a parameter to mysqli_fetch_array instead of mysqli_query.
Post Reply