Weird MySQL error, why am I recieving this?

Posted on 16th Feb 2014 07:03 pm by admin

PHP Code:


<?php require "global_settings.php"; ?>
<title><?php echo $sitetitle; ?></title>
<center><style type="text/css">

a:link {
color:#24374C;
text-decoration:bold;
}

a:visited {
color:#24374C;
text-decoration:bold;
}

a:active {
outline: none;
color:#24374C;
text-decoration:bold;
}

body {background-color:#b0c4de}

div.box {
width:250px;
padding:10px;
border:3px double #000000;
margin:10px;
background-color:#74AFF2;
}

p
{
border-top-style:dotted;
border-right-style:solid;
border-bottom-style:dotted;
border-left-style:solid;
}

div.menu-blue {
BORDER-RIGHT: #333366 1px solid;
BORDER-LEFT: #6699cc 1px solid;
BORDER-TOP: #6699cc 1px solid;
BORDER-BOTTOM: #333366 1px solid;

FONT-WEIGHT: normal;
FONT-SIZE: 2px;
COLOR: #ffffff;
FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif;
BACKGROUND-COLOR: #23559C;
TEXT-DECORATION: none;
font-stretch : condensed;
}

.menu-top {
BORDER-RIGHT: 1px solid #333366; BORDER-TOP: 1px solid #6699CC; FONT-WEIGHT: normal; FONT-SIZE: 2px; BORDER-LEFT: 1px solid #6699CC; COLOR: #FFFFFF; BORDER-BOTTOM: 1px solid #333366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #23559C; TEXT-DECORATION: none;
font-stretch : condensed
}

</style>
<center>
<div class='menu-blue'>
<div align="center">
<table width="600" cellspacing="1" cellpadding="5" style="background-color:#23559C">
<tr>
<td style="background-color:#FFFFFF">


<div align="center">
<table border="0">

</form>
</table>
<?php

$con = mysql_connect("$dbhost", "$dbuser", "$dbpassword") or die(mysql_errno());
if (function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc())
{
$_POST = array_map('stripslashes', $_POST);
}

$name = $_POST['name'];
$message = $_POST['message'];

//getting the data if the user is banned or not
$get = mysql_query("SELECT * FROM users");
while ($row = mysql_fetch_assoc($get))
{
// get data
$ban_check = $row['banned'];

if ($ban_check ==1) {
echo "Your account has been disabled. You are no longer allowed to post.";
}
else {

if (!$name) {
echo "<div class='box'><b><span style='color:red'>You must be logged in to post!</span></b></div>";
}
else
{

//connect
$connect = mysql_connect("$dbhost","$dbuser","$dbpassword") or die("Connection failed!");
mysql_select_db("$db") or die("Database fail!");

//write
$write = mysql_query("INSERT INTO posts VALUES ('','$name','$message')") or die(mysql_error());
$postcount = mysql_query("UPDATE users SET post_count = post_count + 1 WHERE username='$name'");

echo "<div class='box'><font face='arial'><b><span style='color:green'>Posted! Your name was:</span> $name</b> - Your message was....

<b>$message - <a href='bbdemo.php'>View it!</a></b>";
}

}
}
?>


Error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a5488351/public_html/post.php on line 86

Your Answer:

Login to answer

Other forums

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec

have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

Contents of variable not echoing
Hey guys, hopefully this is an easy one...

In this line, the variables are not echoing out. T

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

Not "Just Another" MMORPG - text based.
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing