PHP - Mysql_fetch_array () Expect Parameter 1 To Be Resource

When I run my code outside of a function it works but when i put it on this function I get these three errors: 
  1.  mysql_fetch_array() expects parameter 1 to be resource, null given on line 20 which is:
       "while($row = mysql_fetch_array($result, MYSQLI_ASSOC))"

  2.  on line 19: mysqli_query() expects parameter 1 to be mysqli, null given which is:
       "$result = mysqli_query($dbc, $q);"

  3. on line 19: Undefined variable: dbc
Here is the function call:   

<h5>Latest Posts</h5>
<div class="box">
<div class="content">
<ul>
<?php
latestpost();
?>
</ul>
</div>
</div>

Here is the function:



require_once ('mysqli_connect.php');


 function latestpost() {

    $q = "SELECT * FROM posts p, threads t, users u
        where t.thread_id = p.thread_id and u.user_id = t.user_id
        ORDER BY p.posted_on DESC LIMIT 0, 5";

                $result = mysqli_query($dbc, $q);
        while($row = mysql_fetch_array($result, MYSQLI_ASSOC))
               
      {

       extract($row);

echo "<li><a target='_blank' href='http://localhost/sample/forum/viewtopic.php?f=".      $p.post_id."&amp;t=".$t.thread_id."'>
                    <strong>".$subject."</strong></a><br /><small>Member since ".      $p.posted_on."</small></li>";
       }

}



Here is the connection:

<?php 

mysqli_connect.php is:

DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'database');

// Make the connection:

$dbc = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die ('Could not connect to MySQL: ' . mysqli_connect_error() );


// Set the encoding...
mysqli_set_charset($dbc, 'utf8');

// end

I am trying to install a comments box, im new to php and mysql so havent been able to work this out for myself following other threads, hope someone can shed some light on the problem.

The posts ive entered arent being returned to the page essentially and im getting the error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in commentbox.php on line 42.

This is the code from the entire page.

Code: [Select]
<?php
require('commentconnect.php');
$name=@$_POST['name'];
$comment=@$_POST['comment'];
$submit=@$_POST['submit'];
if($submit)
{
if($name&&$comment)
{
$insert=mysql_query("INSERT INTO commenttable (name,comment) VALUES ('$name','$comment')");
/*header("Location: index.php");*/
echo "<script>document.location.href='index.php'</script>";
echo "<script>'Content-type: application/octet-stream'</script>";
}
else
{
echo "Please fill out the fields";
}
}
?>

<div id="commentdiv">

<div id="commentinput">

<form action="index.php" method="POST">
<table>
<tr><td>Name: </td><td><input type="text" name="name" /></td></tr>
<tr><td colspan="2">Comment: </td></tr>
<tr><td colspan="2"><textarea name="comment"></textarea></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Comment" /></td></tr>

</table>
</form>

</div>

<div id="commentarea">

<?php
$getquery=mysql_query("SELECT * FROM commenttable ORDER BY id DESC");
while($rows=mysql_fetch_array($getquery))
{
$id=$rows['id'];
$name=$rows['name'];
$comment=$rows['comment'];
$dellink="<a href=\"delete.php?id=" . $id . "\"> Delete </a>";
echo $name . '' . '<br />' . $comment . '<br />' . '<hr/>';
} 
?>
</div>

</div>

Any help is greatly appreciated!

Hey guys, i was recently making a new PHP code and when i tested it out it gave me this error:
Code: [Select]
mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\tools\edit_infos.php on line 167
I don't know what the problem is.
Here is 'Line 167':
Code: [Select]
//Line 167
$dnn = mysql_fetch_array(mysql_query('select username,password,email,desc,keys,logo,webclient,forums,hiscores,chatbox,staff,newstitle,newsimage,news,op1,op2,op3 from users where username="'.$_SESSION['username'].'"'));
$username = htmlentities($dnn['username'], ENT_QUOTES, 'UTF-8');
$password = htmlentities($dnn['password'], ENT_QUOTES, 'UTF-8');
$email = htmlentities($dnn['email'], ENT_QUOTES, 'UTF-8');
$desc = htmlentities($dnn['desc'], ENT_QUOTES, 'UTF-8');
$keys = htmlentities($dnn['keys'], ENT_QUOTES, 'UTF-8');
$logo = htmlentities($dnn['logo'], ENT_QUOTES, 'UTF-8');
$webclient = htmlentities($dnn['webclient'], ENT_QUOTES, 'UTF-8');
$forums = htmlentities($dnn['forums'], ENT_QUOTES, 'UTF-8');
$hiscores = htmlentities($dnn['hiscores'], ENT_QUOTES, 'UTF-8');
$chatbox = htmlentities($dnn['chatbox'], ENT_QUOTES, 'UTF-8');
$staff = htmlentities($dnn['staff'], ENT_QUOTES, 'UTF-8');
$newstitle = htmlentities($dnn['newstitle'], ENT_QUOTES, 'UTF-8');
$newsimage = htmlentities($dnn['newsimage'], ENT_QUOTES, 'UTF-8');
$news = htmlentities($dnn['news'], ENT_QUOTES, 'UTF-8');
$op = htmlentities($dnn['op1'], ENT_QUOTES, 'UTF-8');
$opp = htmlentities($dnn['op2'], ENT_QUOTES, 'UTF-8');
$oppp = htmlentities($dnn['op3'], ENT_QUOTES, 'UTF-8');
And here is the whole page code if needed.

Code: [Select]
<?php
include('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" />
        <title>Edit my personnal informations</title>
    </head>
    <body>
    <div class="header">
        <a href="<?php echo $url_home; ?>"><img src="<?php echo $design; ?>/images/logo.png" alt="Members Area" /></a>
    </div>
<?php
//We check if the user is logged
if(isset($_SESSION['username']))
{
//We check if the form has been sent
if(isset($_POST['username'], $_POST['password'], $_POST['passverif'], $_POST['email'], $_POST['desc'], $_POST['keys'], $_POST['logo'], $_POST['webclient'], $_POST['forums'], $_POST['hiscores'], $_POST['donate'], $_POST['chatbox'], $_POST['staff'], $_POST['newstitle'], $_POST['newsimage'], $_POST['news'], $_POST['op1'], $_POST['op2'], $_POST['op3'], $_POST['desc']))
{
//We remove slashes depending on the configuration
if(get_magic_quotes_gpc())
{
$_POST['username'] = stripslashes($_POST['username']);
$_POST['password'] = stripslashes($_POST['password']);
$_POST['passverif'] = stripslashes($_POST['passverif']);
$_POST['email'] = stripslashes($_POST['email']);
$_POST['desc'] = stripslashes($_POST['desc']);
$_POST['keys'] = stripslashes($_POST['keys']);
$_POST['logo'] = stripslashes($_POST['logo']);
$_POST['webclient'] = stripslashes($_POST['webclient']);
$_POST['forums'] = stripslashes($_POST['forums']);
$_POST['hiscores'] = stripslashes($_POST['hiscores']);
$_POST['donate'] = stripslashes($_POST['logo']);
$_POST['chatbox'] = stripslashes($_POST['chatbox']);
$_POST['staff'] = stripslashes($_POST['staff']);
$_POST['newstitle'] = stripslashes($_POST['newstitle']);
$_POST['newsimage'] = stripslashes($_POST['newsimage']);
$_POST['news'] = stripslashes($_POST['news']);
$_POST['op1'] = stripslashes($_POST['op1']);
$_POST['op2'] = stripslashes($_POST['op2']);
$_POST['op3'] = stripslashes($_POST['op3']);
}
//We check if the two passwords are identical
if($_POST['password']==$_POST['passverif'])
{
//We check if the password has 6 or more characters
if(strlen($_POST['password'])>=6)
{
//We check if the email form is valid
if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email']))
{
//We protect the variables
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$email = mysql_real_escape_string($_POST['email']);
$desc = mysql_real_escape_string($_POST['desc']);
$keys = mysql_real_escape_string($_POST['keys']);
$logo = mysql_real_escape_string($_POST['logo']);
$webclient = mysql_real_escape_string($_POST['webclient']);
$forums = mysql_real_escape_string($_POST['forums']);
$hiscores = mysql_real_escape_string($_POST['hiscores']);
$donate = mysql_real_escape_string($_POST['donate']);
$chatbox = mysql_real_escape_string($_POST['chatbox']);
$staff = mysql_real_escape_string($_POST['staff']);
$newstitle = mysql_real_escape_string($_POST['newstitle']);
$newsimage = mysql_real_escape_string($_POST['newsimage']);
$news = mysql_real_escape_string($_POST['news']);
$op = mysql_real_escape_string($_POST['op1']);
$opp = mysql_real_escape_string($_POST['op2']);
$oppp = mysql_real_escape_string($_POST['op3']);
//We check if there is no other user using the same username
$dn = mysql_fetch_array(mysql_query('select count(*) as nb from users where username="'.$username.'"'));
//We check if the username changed and if it is available
if($dn['nb']==0 or $_POST['username']==$_SESSION['username'])
{
//We edit the user informations
if(mysql_query('update users set username="'.$username.'", password="'.$password.'", email="'.$email.'", desc="'.$desc.'", keys="'.$keys.'", logo="'.$logo.'", webclient="'.$webclient.'", forums="'.$forums.'", hiscores="'.$hiscores.'", chatbox="'.$chatbox.'", staff="'.$staff.'", newstitle="'.$newstitle.'", newsimage="'.$newsimage.'", news="'.$news.'", op1="'.$op1.'", op2="'.$op2.'", op3="'.$op3.'" where id="'.mysql_real_escape_string($_SESSION['userid']).'"'))
{
//We dont display the form
$form = false;
//We delete the old sessions so the user need to log again
unset($_SESSION['username'], $_SESSION['userid']);
?>
<div class="message">Your informations have successfuly been updated. You need to log again.<br />
<a href="connexion.php">Log in</a></div>
<?php
}
else
{
//Otherwise, we say that an error occured
$form = true;
$message = 'An error occurred while updating your informations.';
}
}
else
{
//Otherwise, we say the username is not available
$form = true;
$message = 'The username you want to use is not available, please choose another one.';
}
}
else
{
//Otherwise, we say the email is not valid
$form = true;
$message = 'The email you entered is not valid.';
}
}
else
{
//Otherwise, we say the password is too short
$form = true;
$message = 'Your password must contain at least 6 characters.';
}
}
else
{
//Otherwise, we say the passwords are not identical
$form = true;
$message = 'The passwords you entered are not identical.';
}
}
else
{
$form = true;
}
if($form)
{
//We display a message if necessary
if(isset($message))
{
echo '<strong>'.$message.'</strong>';
}
//If the form has already been sent, we display the same values
if(isset($_POST['username'],$_POST['password'],$_POST['desc'], $_POST['keys'], $_POST['logo'], $_POST['webclient'], $_POST['forums'], $_POST['hiscores'], $_POST['donate'], $_POST['chatbox'], $_POST['staff'], $_POST['newstitle'], $_POST['newsimage'], $_POST['news'], $_POST['op1'], $_POST['op2'], $_POST['op3']))
{
$pseudo = htmlentities($_POST['username'], ENT_QUOTES, 'UTF-8');
if($_POST['password']==$_POST['passverif'])
{
$password = htmlentities($_POST['password'], ENT_QUOTES, 'UTF-8');
}
else
{
$password = '';
}
$email = htmlentities($_POST['email'], ENT_QUOTES, 'UTF-8');
$desc = htmlentities($_POST['desc'], ENT_QUOTES, 'UTF-8');
$keys = htmlentities($dnn['keys'], ENT_QUOTES, 'UTF-8');
$logo = htmlentities($dnn['logo'], ENT_QUOTES, 'UTF-8');
$webclient = htmlentities($dnn['webclient'], ENT_QUOTES, 'UTF-8');
$forums = htmlentities($dnn['forums'], ENT_QUOTES, 'UTF-8');
$hiscores = htmlentities($dnn['hiscores'], ENT_QUOTES, 'UTF-8');
$chatbox = htmlentities($dnn['chatbox'], ENT_QUOTES, 'UTF-8');
$staff = htmlentities($dnn['staff'], ENT_QUOTES, 'UTF-8');
$newstitle = htmlentities($dnn['newstitle'], ENT_QUOTES, 'UTF-8');
$newsimage = htmlentities($dnn['newsimage'], ENT_QUOTES, 'UTF-8');
$news = htmlentities($dnn['news'], ENT_QUOTES, 'UTF-8');
$op = htmlentities($dnn['op1'], ENT_QUOTES, 'UTF-8');
$opp = htmlentities($dnn['op2'], ENT_QUOTES, 'UTF-8');
$oppp = htmlentities($dnn['op3'], ENT_QUOTES, 'UTF-8');
}
else
{
//otherwise, we display the values of the database
$dnn = mysql_fetch_array(mysql_query('select username,password,email,desc,keys,logo,webclient,forums,hiscores,chatbox,staff,newstitle,newsimage,news,op1,op2,op3 from users where username="'.$_SESSION['username'].'"'));
$username = htmlentities($dnn['username'], ENT_QUOTES, 'UTF-8');
$password = htmlentities($dnn['password'], ENT_QUOTES, 'UTF-8');
$email = htmlentities($dnn['email'], ENT_QUOTES, 'UTF-8');
$desc = htmlentities($dnn['desc'], ENT_QUOTES, 'UTF-8');
$keys = htmlentities($dnn['keys'], ENT_QUOTES, 'UTF-8');
$logo = htmlentities($dnn['logo'], ENT_QUOTES, 'UTF-8');
$webclient = htmlentities($dnn['webclient'], ENT_QUOTES, 'UTF-8');
$forums = htmlentities($dnn['forums'], ENT_QUOTES, 'UTF-8');
$hiscores = htmlentities($dnn['hiscores'], ENT_QUOTES, 'UTF-8');
$chatbox = htmlentities($dnn['chatbox'], ENT_QUOTES, 'UTF-8');
$staff = htmlentities($dnn['staff'], ENT_QUOTES, 'UTF-8');
$newstitle = htmlentities($dnn['newstitle'], ENT_QUOTES, 'UTF-8');
$newsimage = htmlentities($dnn['newsimage'], ENT_QUOTES, 'UTF-8');
$news = htmlentities($dnn['news'], ENT_QUOTES, 'UTF-8');
$op = htmlentities($dnn['op1'], ENT_QUOTES, 'UTF-8');
$opp = htmlentities($dnn['op2'], ENT_QUOTES, 'UTF-8');
$oppp = htmlentities($dnn['op3'], ENT_QUOTES, 'UTF-8');
}
//We display the form
?>
<div class="content">
    <form action="edit_infos.php" method="post">
        You can edit your informations:<br />
        <div class="center">
            <label for="username">Username</label><input type="text" name="username" id="username" value="<?php echo $username; ?>" /><br />
            <label for="password">Password<span class="small">(6 characters min.)</span></label><input type="password" name="password" id="password" value="<?php echo $password; ?>" /><br />
            <label for="passverif">Password<span class="small">(verification)</span></label><input type="password" name="passverif" id="passverif" value="<?php echo $password; ?>" /><br />
            <label for="email">Email</label><input type="text" name="email" id="email" value="<?php echo $email; ?>" /><br />
            <label for="desc">Webclient/Server Description</label><textarea name="desc" id="desc" rows="3" value="<?php echo $desc; ?>"></textarea><br />
            <label for="keys">Webclient/Server Tags<span class="small">(Seperate with comma's)</span></label><input type="text" name="keys" id="keys" value="<?php echo $keys; ?>" /><br />
            <label for="logo">Website/Server Logo Link</label><input type="text" name="logo" id="logo" value="<?php echo $logo; ?>" /><br />
            <label for="webclient">Webclient Link</label><input type="text" name="webclient" id="webclient" value="<?php echo $webclient; ?>" /><br />
            <label for="forums">Forums Link</label><input type="text" name="forums" id="forums" value="<?php echo $forums; ?>" /><br />
            <label for="hiscores">Hiscores Link</label><input type="text" name="hiscores" id="hiscores" value="<?php echo $hiscores; ?>" /><br />
            <label for="chatbox">Chatbox Html</label><textarea name="chatbox" rows="3" id="chatbox" value="<?php echo $chatbox; ?>" ></textarea><br />
            <label for="staff">Staff Page Link</label><input type="text" name="staff" id="staff" value="<?php echo $staff; ?>" /><br />
            <label for="newstitle">News Article Title</label><input type="text" name="newstitle" id="newstitle" value="<?php echo $newstitle; ?>" /><br />
            <label for="newsimage">News Article Image Link<span class="small">(Displayed under title)</span></label><input type="text" name="newsimage" id="newsimage" value="<?php echo $newsimage; ?>" /><br />
            <label for="news">News Article</label><textarea name="news" rows="3" id="news" value="<?php echo $news; ?>" ></textarea><br />
<label for="op1">Optional Link #1</label><input type="text" name="op" id="op" value="<?php echo $op; ?>" /><br />
<label for="op2">Optional Link #2</label><input type="text" name="opp" id="opp" value="<?php echo $opp; ?>" /><br />
<label for="op3">Optional Link #3</label><input type="text" name="oppp" id="oppp" value="<?php echo $oppp; ?>" /><br />
            <input type="submit" value="Send" />
        </div>
    </form>
</div>
<?php
}
}
else
{
?>
<div class="message">To access this page, you must be logged.<br />
<a href="connexion.php">Log in</a></div>
<?php
}
?>
<div class="foot"><a href="<?php echo $url_home; ?>">Go Home</a> - <a href="http://www.webestools.com/">Webestools</a></div>
</body>
</html>Anyway, i hope someone can help me solve this.
Thanks

HELP ME TO CHANGE THE ERROR


<?PHP
//Include connection to database
include('connect.php');

//Get posted values from form
$status=$_POST['status'];
$date=$_POST['date'];

//Strip slashes
$status = stripslashes($status);
$date = stripslashes($date);
 
//Strip tags
$status = strip_tags($status);
$date = strip_tags($date);

//Inset into database

$insert_status = mysql_query(" insert into status (status) value ('$status')") or die (mysql_error());
$insert_status = mysql_query("insert into status (date) value ('$date')") or die (mysql_error());

while($row = mysql_fetch_array($insert_status)) {  (ERROR IS IN THIS LINE)
$status=$row['status'];
$date=$row['date'];
}


//Line break after every 80
$status = wordwrap($status, 80, "\n", true);

//Line breaks
$status=nl2br($status);

//Display status from data base
echo '<div class="load_status">
<div class="status_img"><img src="blankSilhouette.png" /></div>
<div class="status_text"><a href="#" class="blue">Anonimo</a><p class="text">'.$status.'</p>
<div class="date">'.$date.' &middot; <a href="#" class="light_blue">Like</a> &middot; <a href="#"
class="light_blue">Comment</a></div>
</div>
<div class="clear"></div>
</div>';
?>