Using Query Results

[hukadeeze]

Can you use a queries results only once? In this script I'm looping through a query and saving some values in an array. A little further through the script I need to use the same query for output. When I loop through nothing is echo'd to the browser. When I output a row count it shows that the correct number of records, so they must still be there.

[Barand]

use

 

mysql_data_seek($result,0);

 

to start back at row 0 again.

[hukadeeze]

'Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource'

 

I tried both:

 

mysql_data_seek($query,0);

 

and

 

$query = mysql_data_seek($query,0);

 

I'm running the code directly after I exit a loop using the query.

[Barand]

Is $query the value returned by mysql_query()?

[hukadeeze]

I'm not using that variable name, I was just using it as a representation of the resultset.

[hukadeeze]

bump!