Use mysql_fetch_assoc more than once

Question

I have a big question about mysql_fetch_assoc in while. what happens is the following, I have a page where I do a database search and return to a while existing information with mysql_fetch_assoc, the problem is, when I want to do this while twice, it simply overrides, so I’m doing two database searches on the same page, only changing one situation because of the first mysql_fetch_assoc that overrides the second and so on. the code acts is this.

$buscar_conteudotag = mysql_query('SELECT msg_message FROM flq_message WHERE msg_private LIKE 0 ORDER BY msg_id DESC') or die (mysql_error());
while($quantidade_de_tag = mysql_fetch_assoc($buscar_conteudotag)) {}

$buscar_conteudoclosest = mysql_query("SELECT msg_message FROM flq_message WHERE msg_private LIKE 0 AND msg_message LIKE '%".$closest."%' OR '%".$closest."%' ORDER BY msg_id DESC") or die (mysql_error());
while($buscar_conteudolinhaclosest = mysql_fetch_assoc($buscar_conteudoclosest)){}

$buscar_conteudotag = mysql_query("SELECT msg_message FROM flq_message WHERE msg_private LIKE 0 AND msg_message LIKE '%".trim(substr($siteuri, 1))."%' OR '%".trim(substr($siteuri, 1))."%' ORDER BY msg_id DESC") or die (mysql_error());
while($quantidade_de_tag = mysql_fetch_assoc($buscar_conteudotag)) {}

What I’m looking for in this case is a way to perform only one SELECT for all three whiles. is there? if anyone can help me in this factor.

Answer 1

From what you say in the description, it seems that the first search already gives you all the results you need, and your only problem is that mysql_fetch_assoc keeps changing the internal pointer until the end of the data during the while.

If so, there is the possibility of moving the pointer back to the first line of the result using mysql_data_seek before doing the next while, for example:

mysql_data_seek($buscar_conteudotag, 0)

Answer 2

What happens is that the mysql_fetch_assoc "consumes" lines, as it says in the PHP manual: http://php.net/manual/en/function.mysql-fetch-assoc.php

Returns an associative matrix that corresponds to the obtained line and moves the Data internal pointer ahead.

What you can do is save the result to an array...

$conteudotag = array();
$buscar_conteudotag = mysql_query('SELECT msg_message FROM ...') or die (mysql_error());
while ($quantidade_de_tag = mysql_fetch_assoc($buscar_conteudotag)) {
    $conteudotag[] = quantidade_de_tag;
}

...and then use it wherever it takes.