January 15th, 2004, 11:04 AM
|
|
Junior Member
|
|
Join Date: Jan 2004
Location: Almere, The Netherlands
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
One time database check in a function
I made a function
PHP Code:
function get_admin_vars($adminfield){
switch($adminfield){
case 'general':
$result = mysql_query( 'SELECT site_name, site_address, site_description, site_status, secretword,
timezone, ow_timezone, dateformat, ow_dateformat, timeformat, ow_timeformat
FROM xp_settings');
return mysql_fetch_array($result);
break;
case 'register':
$result = mysql_query( 'SELECT reg_enable, reg_email_ban, def_status, reg_act, reg_user_min,
reg_user_max, reg_pass_min, reg_pass_max, reg_dbl_mail, reg_age_min,
def_rank, def_title, def_rights, def_access, def_glowname, reg_email_nor
reg_email_par, reg_email_kid
FROM xp_settings');
return mysql_fetch_array($result);
break;
}
}
This function is called multiple times in one page request, what do I have to do to make it save the data, and just make it return the saved data after the first request?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
