AHHHHH!!!!

[Anon]

Why am I getting this error???
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/idema/new_site_html/again/search_options.php on line 35

//Perform query depending on user's selection

if(($region=="all")and($countries=="all"))
{
$result = mysql_query("SELECT * FROM trips WHERE cost>='$price1' AND cost<='$price2'",$db);
$flag1="flag1! region=all and countries=all query executed!";
}

else if(($region)and($countries=="all"))
{
$result = mysql_query("SELECT * FROM trips WHERE region='$region' AND cost>='$price1' AND cost<='$price2'",$db);
$flag2="flag2! region was set and countries=all query executed!";
}

else if(($region)and($countries)and($price1)and($price2))
{
$result = mysql_query("SELECT * FROM trips WHERE region='$region' AND country='$countries' AND cost>='$price1' AND cost<='$price2'",$db);
$flag3="flag3! region set, countries set, price1 and price2 set!";
}

//Output Table

//This is where I am getting errors

if ($myrow = mysql_fetch_row($result))
{
echo "<table border=2>\n";
echo "<tr><td>Trip Name</td><td>Region</td><td>Country</td><td>Description</td><td>Cost</td><td>Duration</td><td>Lodging</td><td>Grade</td>";

do{
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["trp_name"], $myrow["region"], $myrow["country"], $myrow["description"], $myrow["cost"], $myrow["duration"], $myrow["lodging"], $myrow[grade]);
}
while ($myrow=mysql_fetch_array($result));
echo "</table>\n";
}
else
{
echo "Sorry, no records were found.";
}

echo "$flag1";
echo "$flag2";
echo "$flag3";

?>

</body>

[craigh]

not sure, but it might be something related to this:

cost>='$price1'

it looks like you are comparing a number to a string. You might try this

cost>=$price1

and see what happens

[Anon]

Your query is either incorrect or you do not have a valid database connection.

First, where you establish your database connection, check to see it is valid.

Second, check your query to see if it is executing without error.

See this tutorial:

http://www.devshed.com/Server_Side/PHP/PHP101_4/

Also see this page in the manual that covers the die function:

http://www.php.net/manual/en/function.die.php

You can put other functions in the die function to provide you the mysql error number.

If you have a valid db connection, then there must be an error in your query. Try running the query directly in SQL if you can access your DB directly.

I cannot diagnose the problem for sure without seeing your trips table structure.

Good Luck

[staffanolin]

I don't know if this could be the problem, but..
First you do: "$myrow = mysql_fetch_row($result);"
then later on you do "$myrow = mysql_fetch_array($result);"

If there only was 1 record in $result, then you sometimes get that error if you are trying to read from the variable again (I am not sure about this part, please correct me if I'm wrong).

Instead of the first (mysql_fetch_row())
do like this:
if($result)
{
//your code
}

or

if(mysql_num_rows($result) > 0)
{
// Your code
}

/Staffan

[Anon]

while ($myrow=mysql_fetch_array($result));
echo "</table>\n";
}

should look like

while ($myrow=mysql_fetch_array($result))
{
echo "</table>\n";
}

1. the semicolon is unnecessary
2. you left out a bracket

[zirius]

Actually, that is not an error... The while is a part of a do-while and should stay the way it is...

What you could check instead is if your script executes any of the queries at all, and if they do, are they run without errors? Try using mysql_error to check this.

[Anon]

It's fixed. Thanks all.