PHP and mysql

Anon

How would I go about writing a php script that can take different search requirements from an html page. For example, I give the user the option of selecting region, country, or difficulty level. How do I search the mysql db depending on which of these they select. Or even better yet, can I have the php script search the db if they have more than one value selected?

kennethl

Say $region, $country, and $difficulty are passed to your script from a form, and say you've got a table called "tablename" with fields region, country, difficulty, and some key we'll call uniqueid. To build your SQL...

$fieldcount = 0;
$query = "SELECT uniqueid FROM tablename WHERE";
if ($region != "") {
$query .= "region='$region'";
$fieldcount++;
}
if ($country != "") {
if ($fieldcount > 0) $query .= " AND ";
$query .= "country='$country'";
$fieldcount++;
}
if ($difficulty != "") {
if ($fieldcount > 0) $query .= " AND ";
$query .= "difficulty='$difficulty'";
}

Anon

Thank you. Another question... Why is this still returning the following error?

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/new_stuff/new_site_html/again/return_row2.php on line 13

script=

<body>
<?

$db = mysql_connect("161.58.151.98","aidema","hexagenia");

mysql_select_db("journeys",$db);

if ($region)
{
$result = mysql_query("SELECT * FROM trips WHERE region=$region",$db);
$myrow = mysql_fetch_row($result);

printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9], $myrow[10]);

}

echo "</table>\n";

</body>

kennethl

I take it line 13 is $myrow = mysql_fetch_row($result);

The error means something went wrong with issuing the query to MySQL. To get more info about what went wrong, try this before you use mysql_fetch_row:

echo mysql_error();

Just by the looks, I would guess you got the error because you need single quotes around $region in your query. Try this:

SELECT * FROM trips WHERE region='$region'