karimali831 Posted August 29, 2011 Share Posted August 29, 2011 Hi! For all my queries I use safe_query() and this function returns mysql_query() Now I want to count how many queries is being returned in this function... can someone modify the code and assign a variable to return max returns please? I would be grateful, thanks! // -- MYSQL QUERY FUNCTION -- // $_mysql_querys = array(); function safe_query($query="") { global $_mysql_querys; if(stristr(str_replace(' ', '', $query), "unionselect")===FALSE AND stristr(str_replace(' ', '', $query), "union(select")===FALSE){ $_mysql_querys[] = $query; if(empty($query)) return false; if(DEBUG == "OFF") $result = mysql_query($query) or die('Query failed!'); else { $result = mysql_query($query) or die('Query failed: ' .'<li>errorno='.mysql_errno() .'<li>error='.mysql_error() .'<li>query='.$query); } return $result; } else die(); } Quote Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/ Share on other sites More sharing options...
AyKay47 Posted August 29, 2011 Share Posted August 29, 2011 else { $result = mysql_query($query) or die('Query failed: ' .'<li>errorno='.mysql_errno() .'<li>error='.mysql_error() .'<li>query='.$query); $num_rows = mysql_num_rows($result); } return $result.$num_rows;// display however you want Quote Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/#findComment-1263213 Share on other sites More sharing options...
karimali831 Posted August 29, 2011 Author Share Posted August 29, 2011 What is wrong with me.. no idea why I didn't think of this thanks a lot! Quote Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/#findComment-1263219 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.