unexpected error

theaman

Please help me with this:

$mailadress = mysql_query("SELECT email FROM subscribers WHERE status='1'") or die(mysql_error());

function recips()
  {
echo "while($row = mysql_fetch_array($mailadress)) {
print($row['email']);
print('; ');
}";
  }

recips();

I want to output e-mail adresses like this from a mySQL database: a@b.c; d@e.f;

but it says:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on...

Thanks for the help!

HalfaBee

You have an extra echo, try this.

function recips()
{
    while($row = mysql_fetch_array($mailadress)) {
        print( $row['email'] );
        print('; ');
    }
}

laserlight

You could even write:

function recips()
{
    while($row = mysql_fetch_array($mailadress)) {
        echo $row['email'] . '; ';
    }
}

However, note that $mailadress does not exist in recips(). You should either declare it global, or better yet, pass it to the function, or perhaps even make it such that you execute the SQL statement in recips().