Click here to Skip to main content
15,884,388 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 0:04
djkee25-Nov-09 0:04 
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90425-Nov-09 0:08
fly90425-Nov-09 0:08 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 0:30
djkee25-Nov-09 0:30 
Here is the function am_queries Smile | :)

function am_queries($db, $sql, $verboseErr=3, $cacheCmd=1, $cache_dir = './cache/') {
	global $cache_config;
	global $cache_page_time;
	global $numberOfQueries; // Global value that can be used at the bottom of a page to report the number queries used.

	$exempt = false; // Queries that modify the database are automatically exempt.  This flag, when changed to true, indicates that the query should not be cached

	// Let's see if this is an UPDATE, INSERT, etc and if so, not use the cache
	$checkOne = explode(' ', $sql, 2);
	if (strtoupper($checkOne[0])=='INSERT' || strtoupper($checkOne[0])=='UPDATE' || strtoupper($checkOne[0])=='CREATE' || strtoupper($checkOne[0])=='DROP' || strtoupper($checkOne[0])=='DELETE') {
		$exempt = true;
	}


These are the errors i get when trying to output the query.

Warning: Missing argument 2 for am_getlatestscores(), called in /home/myusername/public_html/cache/%%45^45E^45E480CD%%index.tpl.php on line 36 and defined in /home/myusername/public_html/includes/gamefunctions.php on line 491

Warning: Invalid argument supplied for foreach() in /home/myusername/public_html/cache/%%45^45E^45E480CD%%index.tpl.php on line 37


Thanks for helping me fly904 Big Grin | :-D

modified on Wednesday, November 25, 2009 2:39 PM

GeneralRe: Help debug a php function with database and JOIN query. Pin
cjoki25-Nov-09 10:29
cjoki25-Nov-09 10:29 
QuestionImage uploads to server with php and mySQL Pin
wartotojas24-Nov-09 8:17
wartotojas24-Nov-09 8:17 
Questionpost data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 7:34
cjoki24-Nov-09 7:34 
AnswerRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 9:04
fly90424-Nov-09 9:04 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 10:01
cjoki24-Nov-09 10:01 
GeneralRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 10:14
fly90424-Nov-09 10:14 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth24-Nov-09 22:46
Marc Firth24-Nov-09 22:46 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki25-Nov-09 8:43
cjoki25-Nov-09 8:43 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth25-Nov-09 22:20
Marc Firth25-Nov-09 22:20 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki27-Nov-09 10:37
cjoki27-Nov-09 10:37 
QuestionProblem with Visual Cpp compiler Pin
Game-point23-Nov-09 18:10
Game-point23-Nov-09 18:10 
AnswerRe: Problem with Visual Cpp compiler Pin
Richard MacCutchan1-Dec-09 2:29
mveRichard MacCutchan1-Dec-09 2:29 
AnswerRe: Problem with Visual Cpp compiler Pin
LloydA11114-Jan-10 8:42
LloydA11114-Jan-10 8:42 
QuestionHelp with assigning variables to smarty template engine (php). Pin
djkee23-Nov-09 10:20
djkee23-Nov-09 10:20 
AnswerRe: Help with assigning variables to smarty template engine (php). Pin
fly90423-Nov-09 10:53
fly90423-Nov-09 10:53 
GeneralRe: Help with assigning variables to smarty template engine (php). Pin
djkee23-Nov-09 13:42
djkee23-Nov-09 13:42 
GeneralRe: Help with assigning variables to smarty template engine (php). Pin
fly90424-Nov-09 2:30
fly90424-Nov-09 2:30 
GeneralRe: Help with assigning variables to smarty template engine (php). Pin
djkee24-Nov-09 8:30
djkee24-Nov-09 8:30 
QuestionPERL Craps game Pin
Rhodge0923-Nov-09 9:30
Rhodge0923-Nov-09 9:30 
AnswerRe: PERL Craps game Pin
Rhodge0923-Nov-09 9:51
Rhodge0923-Nov-09 9:51 
Questionextract numeric values from string Pin
shaina223120-Nov-09 2:42
shaina223120-Nov-09 2:42 
AnswerRe: extract numeric values from string Pin
cjoki20-Nov-09 6:37
cjoki20-Nov-09 6:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.