PHP &amp; MySQL Query help please

PHP & MySQL Query help please

sdm

I have a database that has 6 fields, one of these is language. The options are English, German or Spanish. I know that I can query the database with

Select * WHERE language = 'English'

but what I need to do is have a dropdown list on a webpage where the option that is chosen is the language list given. I cannot work out how to set the $query value to either English, German or Spanish. I hope this makes sense, any examples that anyone can show would be very gratefully received.

ahundiak

It's not clear (to me) what you you are asking for.

Do you need to get a list of languages for your option list? If so then "Select distinct language from table_name" will give you a list of languages in the table.

Or are you trying to build a query itself?
$language = 'English';
$query = "Select * from table_name where language = . '$language'"

Elena_Mitovska

Maybe you mean this:

Creating drop-down:

<select name=language>
<option value="English" selected>English</option>
<option value="German">German</option>
<option value="French">French</option>
</select>

after you submit form, build query like that:
$query=" from my_table where language=".$language;

sdm

I am new to this so please excuse the layout of the code on the page. What I have is a database with names of people in it, all the people are translators of some language or other.

I want to create the page so a user can click on a button to select all the translators that are available for a particular language, I have the database but am trying to build the page.

The code below works OK but starts with an error message because $sql is not set as I have commented it out, if I remove the comment from the line which reads $sql = "SELECT * WHERE language = 'English'" I don't get the error message but the buttons do not work to set the value of $sql.

I hope that explains things a bit better and I hope you can help.

Regards,

SDM

<html>
<head>
<title>Translators Data</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<form action="<?php echo $PHP_SELF; ?>" method="post">
<input type="submit" name='all' value="All">
<input type="submit" name='english' value="English">
<input type="submit" name='german' value="German">
<input type="submit" name='spanish' value="Spanish">
</form>

<?php

if($all)
{
$sql = "SELECT FROM people";
}
if($english)
{
$sql = "SELECT FROM people WHERE language = 'English'";
}
if($german)
{
$sql = "SELECT FROM people WHERE language = 'German'";
}
if($spanish)
{
$sql = "SELECT FROM people WHERE language = 'Spanish'";
}

//$sql = "SELECT * WHERE language = 'English'";
$result = mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;

echo "Number of translators found: ".$num."";

echo "<ol>";

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$id = $row["id"];
$name = $row["name"];
$address = $row["address"];
$phone = $row["phone"];
$email = $row["email"];
$language = $row["language"];

echo "<li>Translator Data: Name: $name Address: $address Phone Number: $phone Email: <a href=\"mailto:$email\">$name</a> Languages: $language</li> ";

$cur ++;
}
echo "</ol>";
?>

</body>
</html>

Elena_Mitovska

I think I found the error in yuor script. After you define $sql :

You have to check if $SQL if defines and only if it is defined, continue with the rest of code,because when you run script first time, none of yuor submit botoms is pressed, so none of IF conditions work and $SQL is not set, than's why it generates error when you try to run empty query..

So just insert this check after previous part of code:

if (isset($sql)) {

$result = mysql_query($sql,$db);
.....
echo "<li>Translator Data: Name: $name Address: $address Phone Number: $phone Email: <a href=\"mailto:$email\">$name</a> Languages: $language</li> ";

$cur ++;
}
echo "</ol>";
}//if