Easier solution: mysql_data_seek (resource result_identifier, int
row_number)
Example:
$query = "SELECT * FROM mytable";
$result = mysql_query($query) or die("Error: ".mysql_error());
while ($row = mysql_fetch_row($result) )
{
...do some stuff...
}
mysql_data_seek($result, 0 );
while ($row = mysql_fetch_row($result) )
{
...do some other stuff...
}
Thus, you don't have to store it in an array.
-----Original Message-----
From: Chris Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 7:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Using A Query Results Multiple Times
just put it in a loop.
while($val = mysql_fetch_result($result))
$array[] = $val;
foreach($count = 0; $count < count($array); $count++)
echo $array[$count]['product_name'];
foreach($count = 0; $count < count($array); $count++)
echo $array[$count]['product_name'];
php4 has foreach() its better, think of upgrading, there are numerous
reasons.
--
Chris Lee
[EMAIL PROTECTED]
"Adam Douglas" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have an instance where I have to query my MySQL database and then
> use the multiple row results to create multiple pull down menus on a web
> page. My problem is how can I take the results of the query and use them
> more the once to create pull down menus? I've always used a while look to
> fetch each row of the results and have it create the pull down menu as it
> goes through each row. But doing it this way only stores one row of
results
> in a variable. Is there a way I can grab all the results from a query that
> would go into an array so I could use it multiple times? I've lookingere
> briefly for a function to MySQL that would allow me to do this but haven't
> found anything unless I misunderstand mysql_fetch_array function. At first
I
> thought I could loop through my while loop and have it put the results
from
> the query of each row in to a multidimensional array. But then how would I
> add to the array after the initial row?
>
> BTW, I'm using PHP 3.0.16.... so I can't use the added array functions
that
> PHP 4 has. I do plan on upgrading soon.
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
