jumping to next iteration in a loop

[Anon]

Hi All,

I wonder if anyone can help me. I'm trying to do this :

// Connect to database
$mysql_link = mysql_pconnect("localhost", "database", "password");

    // Get list of tables
    $mysql_result = mysql_list_tables("takbro", $mysql_link);

    // Get each table name and query it.
    while ($tablename = mysql_fetch_row($mysql_result)) {

            $real_tablename = (eregi_replace("\_.*.$","","$tablename[0]"));

            $query = "select * from $tablename[0] where category like '%".$searchterm."%'";

            $result = mysql_query($query);

            $num_results = mysql_num_rows($result);

            if ($num_results == "0" ) {

                    break;

            }

            print "The $real_tablename range has $num_results results matching <b>$searchterm</b>\n";

// Other Stuff Happens.....

}

So basically, the script executes, grabs a list of tables, and then checks for results. I want to jump round to the next loop if $num_results == 0. In perl, I'd just use a next statement, but I can't seem to find a similar thing, and break; just halts all execution (in this case). Help ! Deadline Looming !

TIA

James.

[toma42]

continue; instead of break;

[Anon]

Fantastic !!! Thanks....

[Anon]

Or, you could just structure the rest of the loop with an if/else, and do the "extra" stuff in the body of the if: that you you don't need the jumping around part (which is always nice, makes the code easier to understand and thus easier to get right and keep right!)