reusing results from "mysql_query"

Anon

Why doesn't this work?:
(assuming:
username = username
password = password
tblname = tblname
tblname has 3 fields:
first_name, last_name, and email)

mysql_connect (localhost', 'username', 'password');
mysql_select_db ('dbname');
$result = mysql_query ("SELECT * FROM tblname");

while ($row = mysql_fetch_assoc ($result))
{
extract ($row);
echo "$first_name $last_name<br>";
}

while ($row = mysql_fetch_assoc ($result))
{
extract ($row);
echo "$email<br>";
}

Only the first while loop is executed, why?

Anon

You need to move the pointer for the record set back to the beginning by using mysql_data_seek($result, 0) just before your second while statement.

Anon

They are both executed, it is just that the pointer is at the end when you go to do the second, so it doesn't find anything to loop thru in the second one.

you need to put:

mysql_data_seek($result, 0);

in between the two (it is kind of like resetting an array)

craig

Anon

What do you guys think is faster ?

Resetting the result pointer or doing the following:

while ($row = mysql_fetch_assoc ($result))
{
extract $row;
$name .= "$first_name $last_name<br>\n";
$email .= "$email<br>\n";
}

echo $name;
echo $email;

Instead of running two times over the result, we can do some string manipulating.
Whats faster ? 🙂

Anon

Oops, i forgot the braces around $row at the "extract $row"

Sorry :>

Anon

arrays would be faster.

while ($row = mysql_fetch_assoc ($result))
{
extract ($row);
$name[]= "$first_name $last_name\n";
$email[]= "$email\n";
}

echo $name[0];
echo $email[0];