Please I Need Help!

jennifer_ann

This is my 1st attempt EVER at PHP and I'm trying to pull a search of countries out of a database I have. I can't get it to work though. Can someone please help me 🙁

</select><input type="submit" value = "Search">

//it then opens 'search.php' which is meant to search through the touchart database

<?php
// open connection to database
$db = mysql_connect("localhost", "root", "");
if (!$db)
{
print "unable to connect!";
exit;
}

// set server access variables
extract($_GET);

//select database to use
$db= mysql_select_db ("touch_art1");
if (!$db)
{
print "could not select database";
exit;
}

$query = "SELECT * FROM temp";

echo $query;
$result = mysql_query($query, $connection);

//check to see if query worked
if (!$result)
{
echo "Query on Connection failed!";
// exit

}
else
{
echo "Query succeeded";
// process results
}

while($row = mysql_fetch_row($result)) {

$country_origin = $row[1];

echo $country_origin.";

}

mysql_close($connection);
?>

bradgrafelman

Use descriptive subjects when posting new threads. "HELP ME!" and its variants aren't descriptive, and they will most likely turn away many helpful posters.
Use the board's PHP tags when posting PHP code.
When posting large amounts of code (or any amount, really), try to conserve space. Remove extraneous line breaks. Only post a section or two of code that is specifically relevant to your problem. If more code is truly needed, a knowledgeable poster will most likely say so.
If you're asking for help with some code that is not working... tell us the problem! Is PHP giving you error messages? Is it not behaving as expected? Etc.
Instead of using [man]extract/man on the $GET superglobal, I would recommend simply referencing the array to get data, such as $GET['country_origin']. Basically, this boils down to security measures since [man]extract[/man]'ing is basically what register_globals did.
This line:
```
echo $country_origin.";
```
has an unclosed double quote. It should instead be:
```
echo $country_origin;
```