Excuse me if this is too newbie...but I'm writing a simple script to
query a database and loop through the reuslts, echoing them on the page.
 When I enter the query at the mysql command line, I get the correct
results.  But the same query run through PHP renders all results except
the first one.  Any idea why?  I've included the code snippet below:

//the query to select the data
$query = "SELECT firstname,email,optin from contact where
$result = mysql_query($query);
if(!$result) error_message(sql_error());

$query_data = mysql_fetch_row($result);

while($query_data = mysql_fetch_array($result)) {
        $firstname = $query_data["firstname"];
        $email = $query_data["email"];
        $optin = $query_data["optin"];

        echo "<BR>\n";
        echo "$firstname;$email;$optin\n";

} //end while loop 

also, what would be the code to output the reuslts to a text file
instead of (or in addition to) the screen?



providing the finest in midget technology

PHP General 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