I've used a similar structure hundreds of times, but the following isn't 

$result = mysql_query($sql, 

if( !$result ) { echo "No result code in SQL send. <br>"; 
if( mysql_num_rows( $result ) >= 1 

    echo "Rows fetched: ", mysql_num_rows( $result ), 
    while( $row = mysql_fetch_array( $result ) ) 

       //$password = $row[ password 
       //$first_name = $row[ first_name 
       //$last_name = $row[ last_name 
       //$email = $row[ email 

       echo "In the 

       echo $row[ password ] . "<br>" ;

       // there will be code here to build and send an email



    echo "Mailing of passwords completed. 

    echo "<input type = \"submit\" name = \"action[]\" value= \" $Close \" 

The sql statement show below has been tested interactively, it does return 
5 records and none of them are nulls.
--- begin sql ---
    select first_name, last_name, password, email from subscriber where 
lpasswd_mailed = 0 and email != ''
--- end sql ---

Here's the output from the browser:
---------- top of browser -------
Rows fetched: 5
In the while!!
<horizontal rule >
Mailing of passwords completed.
--------end of output ----------

I believe it should show, in addition to the record count..
           "In the while" 5 times, interspersed with password values.

What is the dumb obvious thing I'm missing?

Regards - Miles Thompson

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to