Disappear the arrays generated with mysql_fetch_array() after use?

Question

I have a typical database query:

$query = mysql_query('SELECT titulo,referencia FROM cursos WHERE tipo=1 AND estado=1');

and I can convert it in an array and print the data:

while ($results=mysql_fetch_array($query)): ?>
echo $results['referencia'];
// and so...
endwhile;

but in some cases I need to print the same data in another part of the web page, but the $results array seems to be empty (I use var_dump($results) and I get bool(false)). I plan to use what I learned reading Create PHP array from MySQL column, but not supposed to mysql_fetch_array() creates an array? So, what happen?

Are you sure your query is correct and returns results?

Anthony Forloney
– Anthony Forloney

2010-01-27 03:33:10 +00:00
Commented Jan 27, 2010 at 3:33 — Anthony Forloney
– Anthony Forloney, Commented Jan 27, 2010 at 3:33
Yeah, the first time I do the query the data are printed.

Tae
– Tae

2010-01-27 03:41:34 +00:00
Commented Jan 27, 2010 at 3:41 — Tae
– Tae, Commented Jan 27, 2010 at 3:41

Sean Vieira · Accepted Answer · 2010-01-27 04:55:56Z

2

Tae, the reason that your $result is false at the end of the while loop is that mysql_fetch_array returns false when it reaches the end of the query set. (See the PHP Docs on the subject) When you reach the end of the query set $results is set to false and the while loop is exited. If you want to save the arrays (database row results) for later, then do as Chacha102 suggests and store each row as it is pulled from the database.

$data = array();
while($results = mysql_fetch_array($query)) {
    $data[] = $results;
}
foreach ($data as $result_row) {
    echo $result_row['referencia'];
    ... etc.
}

answered Jan 27, 2010 at 4:55

Sean Vieira

161k34 gold badges321 silver badges297 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tyler Carter · Accepted Answer · 2010-01-27 03:35:30Z

1

Try this

while($results = mysql_fetch_array($query))
{
    $data[] = $results;
}

Now, all of your results are in $data, and you can do whatever you want from there.

As Anthony said, you might want to make sure that data is actually being retrieved from the query. Check if any results are being returned by echo mysql_num_rows($query). That should give you the number of rows you got

edited Jan 27, 2010 at 3:35

answered Jan 27, 2010 at 3:33

Tyler Carter

61.7k22 gold badges133 silver badges153 bronze badges

1 Comment

Tae Over a year ago

Thanks Chacha102, that's the method I supposed to be used and I'll try it, but I still wonder why the arrays generated by mysql_fetch_array() seem to disappear.

Collectives™ on Stack Overflow

Disappear the arrays generated with mysql_fetch_array() after use?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related