Re: PHP Data cache ideas/solutions
| From: | Matthew Fonda | Date: | Wed, 29 Sep 2004 14:05:23 +0000 |
| Subject: | Re: PHP Data cache ideas/solutions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-198190@lists.php.net to get a copy of this message | ||
You could do something like:
$result = mysql_query("SELECT * FROM whatever", $link);
while ($topic = mysql_fetch_assoc($result)) {
$all[] = $topic;
}
The array $all will contain all of the things fetched.
On Wed, 2004-09-29 at 02:04, Niklas Ojala wrote:
> Hello
>
> I am kind of new to this news thing, but here goes.
>
> I am looking for a class or some samples that would read a table from mysql
> and store it in an array variable, so that it will be avilable to other
> parts of the page without having to get it from the database again. So I
> would like to only get the table once per page load but I must be able to
> filter the table to get the data that I want.
>
> I am looking for some similar code to get me started or other ideas on how
> to make less queries to the database.
>
> /Niklas Ojala