table generation (please help)

Anon

I would like to have a table generated based on whether the condition result1, result2, or result3 is met. Here is what I have but it's not right.

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

else if($countries=all){
$result2 = mysql_query("SELECT country FROM trips WHERE region LIKE '$region' AND cost>='$price1' AND cost<='$price2'",$db);
}

else
{
$result3 = mysql_query("SELECT * FROM trips WHERE region LIKE '$region' AND country LIKE '$countries' AND cost>='$price1' AND cost<='$price2'",$db);
}

do
{
echo "<table border=1>\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></tr>";

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]);
echo "</table>\n";
}
while ($myrow = mysql_fetch_row($result1);

do
{
echo "<table border=1>\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></tr>";

</body>

Can anyone help?

techek

First of all, swap the 'do' and 'while' in every loop.

Second, I suggest you move every output-block inside each if-statement. An example follows :

<?php
if ($condition == '1') {
// make and fire sql nr 1
// take output from db and display nr 1
} elseif ($condition == '2') {
// make and fire sql nr 2
// take output from db and display nr 2
} else {
// make and fire sql nr 3
// take output from db and display nr 3
}
?>

There is no need to execute code EVEN if you know it isn't going to do anything.

Hint : Have a look at the 'switch'-function - it'll save even more coding when you get a lot of if-statements.