Re: Missing first record in PHP/Mysql query

here may be why: //Right here you grab a row $query_data = mysql_fetch_row($result); //but you don't use it and you move on while($query_data = mysql_fetch_array($result)) { ----- Original Message ----- From: "Rory O'Connor" <midget@elaris.com> To: <php-general@lists.php.net> Sent: Thursday, July 05, 2001 3:11 PM Subject: [PHP] Missing first record in PHP/Mysql query > 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 > interest='rory'"; > $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? > > thanks, > > rory > > providing the finest in midget technology > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >