Store Values => Easy One, I think

NoFear

Ok, this should be a quick "duh, I knew that" question, but I can't figure it out.

I want to use the results of a query twice, in two different spots in the script. I'm using mysql_fetch_array, so I want to be able to call main array using column names rather than column numbers.

Example:

while($var = mysql_fetch_array($query_result))
{
//put result in an array where I can reference it the same way as I called this while statement as many times as I like throughout the script.
}

Of course, if I could just rewind this query, that would work, too.... though I can't seem to find a function for that, either.

I'm sure this is very simple. Anybody?

OhLordy

<?
for($i=0;$i<mysql_num_rows($query_result);$i++) {
$result_array[$i]=mysql_fetch_array($query);
}
?>

This will give you an array of $i=mysql_num_rows($query_result) elements each element being a result row from the query. You can then loop through this array later on in the script.

Hope this is what you mean
Rob

NoFear

Originally posted by OhLordy
<?
for($i=0;$i<mysql_num_rows($query_result);$i++) {
$result_array[$i]=mysql_fetch_array($query);
}
?>
This will give you an array of $i=mysql_num_rows($query_result) elements each element being a result row from the query. You can then loop through this array later on in the script.

Hope this is what you mean
Rob [/B]

Kind of, but not quite. This is easy enough, but I want to reference by the column names, not the $i value.

example:

$result_array['column']
instead of
$result_array[0]

quick fixes??

OhLordy

That is what my code will do.However if your query returns more than one row (there is more than one match) it will create more rows in the array so you would access 'column_name' from the first reult like this

$result_array[$i]['column_name']

See?
Rob

superwormy

This rewinds the query to any row you'd like it to rewind to:
http://www.php.net/manual/en/function.mysql-data-seek.php

OhLordy

WOW! I never realised you could do that. I guess I should be reading the manual more :rolleyes:
Cheers
Rob

NoFear

Originally posted by superwormy
This rewinds the query to any row you'd like it to rewind to:
http://www.php.net/manual/en/function.mysql-data-seek.php

TY TY TY TY TY TY TY TY =)

Works perfectly, exactly what I was looking for. I knew there had to be something, I just couldn't find it. In fact, I even looked at this function last night, well, glanced over it quickly, but it didn't catch my eye.

Thanks much!