Daimler Posted July 15, 2010 Share Posted July 15, 2010 I have installed a dating script and get the fallowing errors. Can someone help me please ? im a very beginner at php. Thank you Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\x\include\site_functions.php on line 96 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\x\include\site_functions.php on line 21 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\x\include\site_functions.php on line 22 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\x\include\site_functions.php on line 21 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\x\include\site_functions.php on line 22 Table 'cristi.ifdate_users' doesn't exist and this is the code: <? ///////////////////////////////////////////////////////////////////////// // iFdate v.2.0 Copyright // // By using this software you agree to the terms & conditions // // www.ifdate.com - www.ifusionservices.co.uk // ///////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////// // iFdate Functions // ///////////////////////////////////////////////////////////////////////// function getSqlRow($query) { $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result); mysql_free_result($result); return $row; } function getSqlNumber($sqlQuery) { $query=mysql_query($sqlQuery); $result=mysql_num_rows($query); mysql_free_result($query); return $result; } function getSqlField($sqlQuery,$field) { $isQuery = getSqlNumber($sqlQuery); $query = mysql_query($sqlQuery); if ($isQuery>0) { $result=mysql_result($query,0,$field); } else $result="n/a"; mysql_free_result($query); return $result; } function uploadFile($file,$fileName,$destDir,$overwrite=FALSE) { $success = FALSE; if ($file!=""&&$file!="none") { if(file_exists($destDir.$fileName)) unlink($destDir.$fileName); $success = TRUE; $copyPath = $destDir.$fileName; if (!copy($file, $copyPath)) { print ("Error: Failed to copy $file...<br>"); $success = FALSE; } } return $success; } function paginate($start,$limit,$total,$filePath) { global $lang; if ($start>0) { $newLimit = $start-$limit; $pagination = "<a href=\"".$filePath."?start=".$newLimit."\">Prev</a> "; } $pageCounterLink=0; $pageCounter=1; while ($pageCounterLink<$total) { $pagination .= "<a href=\"".$filePath."?start=".$pageCounterLink."\">".$pageCounter."</a> "; $pageCounterLink += $limit; $pageCounter++; } $tempVar = $start+$limit; if ($tempVar<$total) { $newLimit = $start+$limit; $pagination = "<a href=\"".$filePath."?start=".$newLimit."\">Next</a> "; } echo $pagination; } function get_age($birth_day,$birth_month,$birth_year) { $d_stamp = date("d.m.Y",mktime()); list($cur_day,$cur_month,$cur_year) = explode(".",$d_stamp); $year_diff = $cur_year-$birth_year; if(($birth_month > $cur_month) || ($birth_month == $cur_month && $cur_day < $birth_day)) { $age = $year_diff-1; } else { $age = $year_diff; } return $age; } // Timeout if ($_COOKIE['iFdate']=="Active"){ mysql_query("UPDATE ifdate_users SET account_timeout='".time()."' WHERE id='".$_COOKIE['iFdate_id']."'"); } $get_logged_users = mysql_query("SELECT * FROM ifdate_users WHERE active_status='Online'"); while ($got_logged_users = mysql_fetch_array($get_logged_users)){ $logged_users = getSqlField("SELECT account_timeout FROM ifdate_users WHERE id='".$got_logged_users['id']."'",'account_timeout'); if ($logged_users<time()-1800){ mysql_query("UPDATE ifdate_users SET active_status='Offline' WHERE id='".$got_logged_users['id']."'"); } } ?> Quote Link to comment https://forums.phpfreaks.com/topic/207866-mysql-fetch-array/ 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.