The problem may be your variable variable syntax... See if the following
works:
while ($row = mysql_fetch_array($result))
{
session_register('config_'.$row['config_id']);
${'config_'.$row['config_id']} = $row['config_value'];
}
Although I personally prefer using the session superglobal over
session_register, which means you'd just need a string for the key
value and can avoid variable variables altogether...
while ($row = mysql_fetch_array($result))
{
$_SESSION['config_'.$row['config_id']] = $row['config_value'];
}
mh.
On Wed, 15 Jan 2003, Stephen of Blank Canvas wrote:
> Hi Everyone,
>
> I'm trying to use MySQL to store some general settings for a site I am
> working on, which I was then going to access as session variables on
> pages as needed without having to call the dB each time. However I am
> having problems setting the name of the session variable in a way that I
> can reference it later. The code I am trying to use is:
>
> ===============================================================
> session_start();
> $connection =
> @mysql_connect("$MySQLHost","$MySQLUser","$MySQLPassword") or
> die("Unable to connect to MySQL Host. ".mysql_error() );
> $db = @mysql_select_db($MySQLdB, $connection) or die("Unable to
> connect to MySQL dB. ".mysql_error() );
> $query = "SELECT * FROM config WHERE status = 1";
> $result = @mysql_query($query,$connection) or die("Unable to execute
> select query. ".mysql_error() );
> $num_rows = mysql_numrows($result);
>
> while ($row = mysql_fetch_array($result))
> {
> $config_$row[config_id] = $row[config_value];
> session_register(config_$row[config_id]);
> }
>
> mysql_free_result($result);
> mysql_close($connection);
> ===============================================================
>
> Any pointers much appreciated.
>
> Stephen
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
