I notice you're incrementing the row offset.  You shouldn't use
mysql_result() to extract multiple fields like that.  It will be much
faster using mysql_fetch_array() once and then extracting any data you
need from the resulting associative array as many times as you need.
Mysql_result() is intended to be used when you need to extract the data
in one field in one column.
I can only think it has something to do with your $results_all.  Perhaps
there is a max size that it will accept?  Doesn't make sense though.  I
tried this and it worked fine:

// open dbase not shown
$query = "SELECT * FROM montileaux_events";
$result = mysql_query ($query, $db);
$num = mysql_num_rows($result);
for ($i=0; $i<$num; $i++)
        echo mysql_result($result, $i, "event_location") . "<br>";

For extracting multiple sets of data you should be using one of the
mysql_fetch_XXX() functions instead.  Example..

$row = mysql_fetch_array($result);
echo $row[event_location]. "<br>";


-----Original Message-----
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 22, 2002 9:27 AM
Subject: [PHP] Weird error...

What does this error mean??
Fatal error: Allowed memory size of 8388608 bytes exhausted at
zend_language_scanner.c:4248 (tried to allocate 9 bytes) in
/blah/blah/afteradmin2.php on line 37
here is line #37...
$usertemp = mysql_result($result_all, $i, "username");


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to