Re: [PHP] 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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 "\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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
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]
Re: [PHP] Missing first record in PHP/Mysql query
At 7:11 PM -0700 7/5/01, Rory O'Connor wrote:
>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?
It's doing exactly what you told it to ;)
See below:
>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);
This line fetches the first row and moves the pointer to the next
row. You then proceed to ignore the results of the first row! Just
delete this line, and you'll be happy.
>while($query_data = mysql_fetch_array($result)) {
> $firstname = $query_data["firstname"];
> $email = $query_data["email"];
> $optin = $query_data["optin"];
>
> echo "\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?
Check out the file functions - fopen, fwrite, fclose will be of
particular interest:
http://www.php.net/manual/en/ref.filesystem.php
>thanks,
>
>rory
>
>providing the finest in midget technology
>
--
+-- Factoid: Of the 100 largest economies in the world, 51 are --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- corporations -- http://www.ips-dc.org/reports/top200text.htm ---+
--
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]
