SQL QUERY SELECT INSIDE A FUNCTION

Question

I am trying to work with a voting database system. I have a form to display all the candidates per candidate type. I'm still trying to to explore that. But this time, I want to try one candidate type, lets say for Chairperson, I want to display all candidate names for that type in the ballot form. However, there's an error with the line where i declare $query and made query statements, can somebody know what it is. I am very certain that my syntax is correct.

 function returnAllFromTable($table) {
 include 'connect.php';
 $data = array ();
 $query = 'SELECT * FROM ' . $table. 'WHERE candidateId=1'; //ERROR
 $mysql_query = mysql_query ( $query, $conn );
 if (! $mysql_query) {
 die ( '<a href="../../">Go Back</a><br>Unable to retrieve data from table ' . $table );
 } else {
 while ( $row = mysql_fetch_array ( $mysql_query ) ) {
 $data [] = $row;
 }
 }
 return $data;
 }

• Darwin von Corax: You're probably missing a space between the table name and WHERE. Try calling print_r($query) to see what's actually in there. Also, don't use mysql driver yada yada obsolete yada use mysqli or PDO.

Answer 1

As @Darwin von Corax says, I sure that you have a problem between $table and WHERE

Your query:

$query = 'SELECT * FROM ' . $table. 'WHERE candidateId=1';

If $table = 'Chairperson';

You have:

'SELECT * FROM ChairpersonWHERE candidateId=1';

The your query should be:

 $query = 'SELECT * FROM ' . $table. ' WHERE candidateId=1';

• Adrian Cid Almaguer: @adrianquevada a plasure ;-)