[RESOLVED] Help with SELECT...WHERE syntax

[AHoward007]

//Retrieve posted info.
$englishinput=$_POST['englishinput'];

$query="SELECT monolingua, COUNT(monolingua) as monolingua_count FROM dictionary 
WHERE english=$englishinput GROUP BY monolingua ORDER BY monolingua_count 
DESC LIMIT 5";

echo $query;

I'm having two problems with this script.

First, I'm getting a syntax error for the $query cmd. I believe it has to do with the $englishinput variable.

Second, the echo $query line just prints out the script line above. I need it to print out the data results.

[bpat1434]

You need to quote your strings in sql. So put single-quotes around the $englishinput variable in the $query string. Also, be sure to Filter Input using [man]myql_real_escape_string/man or [man]pg_escape_string/man (or the other _real_escape_string() functions for each D😎.

In order to run a query, you need a connection to the database, a database selected, and then you just need to run [man]mysql_query/man and use [man]mysql_fetch_row/man or [man]mysql_fetch_assoc/man to get the results of the query (if any).

[devinemke]

assuming mySQL here

$englishinput = mysql_real_escape_string($_POST['englishinput']);
$query = "SELECT monolingua, COUNT(monolingua) AS monolingua_count FROM dictionary WHERE english = '$englishinput' GROUP BY monolingua ORDER BY monolingua_count DESC LIMIT 5";
$result = mysql_query($query) or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['monolingua_count'] . ' ' . $row['monolingua'] . '<br>';
}

[AHoward007]

Thanks that worked!

As an addendum to this, I need these results to print on my original web page instead of on a separate page. Currently I have this script in my processforms.php file that is being called to action by my form method action cmd from my main web page file.

Should I just add this script to my main file instead of in my processforms.php file somewhere below my form method...action cmd?

[bpat1434]

You can add it anywhere you would like.