note 108680 deleted from function.mysql-fetch-array by danbrown
| From: | danbrown@php.net | Date: | Thu, 17 May 2012 14:50:57 +0000 |
| Subject: | note 108680 deleted from function.mysql-fetch-array by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-188035@lists.php.net to get a copy of this message | ||
Note Submitter: Anonymous
----
I have hosted a new BUX site crimsonbux.co.cc but I am getting MYSQL errors again and again. I am
getting the following error.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/home/a5842986/public_html/config.php on line 53
And this my config.php file.
<?php
//Connect to MySQL server///////////////////////////////////////////////////////////////
////
$con = mysql_connect($dhost, $dusername, $dpassword) or die("Cannot Connect"); ////
mysql_select_db($ddatabase, $con); ////
////
if($_COOKIE["usNick"] and $_COOKIE["usPass"])
////
{ ////
$q = mysql_query("SELECT * FROM tb_users WHERE
username='{$_COOKIE['usNick']}' AND
password='{$_COOKIE['usPass']}'") or die(mysql_error());
////
if(mysql_num_rows($q) == 0) ////
{ ////
$_COOKIE['usNick'] = false; ////
$_COOKIE['usPass'] = false; ////
} else { ////
$loggedin = 1; ////
$r = mysql_fetch_array($q); ////
} ////
} ////
$da = date("j"); ////
////
$queryxx = "DELETE FROM ad_clicks WHERE day!='$da'";
////
mysql_query($queryxx); ////
////
$q2 = mysql_query("SELECT * FROM settings"); ////
while($r2=mysql_fetch_array($q2)) ////
{ ////
$set[$r2[setname]]=$r2["setvalue"]; ////
} ////
mysql_query("UPDATE settings SET setvalue='0', set_day='{$da}' WHERE
set_day!='{$da}' AND set_day>'0'") or die(mysql_error());
////
$user=$_COOKIE['usNick']; ////
?>
Any Solution friends? Please help me out.