PHP - Resource Id #2 (old Error?)

I am currently trying create a sales system where it checks the user's username against the database to check whether they are in the list of buyers.

The mysql query returns "Resource id #35", I need it to return the actual username (which I manually inserted into the database to test).


PHP code that fetches from database:


<?php
$con = mysql_connect("x","x","x");
if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

mysql_select_db("x", $con);

$check_buyer = "SELECT * FROM Buyers WHERE Buyer='x'";

        $buyer = mysql_query($check_buyer);
?>



Product page:

<?php
include("/home/x/public_html/scripts/buyer.php");

if ($user->data['user_id'] == ANONYMOUS)
{
echo 'To use ' . $product . 'you must be logged in!';
    echo '<br /><a href="http://x/forum/ucp.php?mode=register">Register</a>';
echo ' or ';
     echo '<a href="http://x/forum/ucp.php?mode=login">Sign In</a>';
}

elseif ($user->data['username_clean'] == $buyer)
{
echo "<h3>Welcome to x</h3>";
}

else
{
    echo "You need to buy this product to use it!";

echo $user->data['username_clean']; //test whether username is outputted correctly - which it did
echo $buyer; //Fetched from mysql - returned "Resource id #35", not the desired username
}
?>


Any help would be great!


Thanks,

otester

I created this function to update my tour system.  The query is working and is updating one row in the table, but I get a resource boolean error in the return section of the function.  Any idea why?

Code: [Select]
function update_tour($uid, $step)
{
$step = (int)$step;
$uid = (int)$uid;

$sql = "UPDATE `users`
SET
`tour_step` = ${step}
WHERE `id` = '${uid}'";

$q = mysql_query($sql) or die(mysql_error());

return (mysql_num_rows($q) === 1) ? mysql_result($q, 0): false;
}

I keep getting this error when I run the following code: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\vitamin-k-tracker\my-meal-planner.php on line 29

Code: [Select]
<?php include 'top.php'; ?>
<?php

if (!loggedin())
{//1 if start
header('Location: need-to-log-in-mmp.php');
}//1 if end
?>
    <title>My Meal Planner - Vitamin K Tracker</title>
</head>

<div id="container">

<?php include 'header.php'; ?>

<?php include 'nav.php'; ?>
<?php
//do sql query to return the foods and nutrients that a person added to their que
//
// we're doing a left join between the foods and user foods table connected by the id


$queryc = "SELECT
 `foods.id`, `foods.name`, `foods.source`, `users_foods.food_id`
 FROM `foods`
 LEFT JOIN users_foods
 ON foods.id=users_foods.food_id";
$query_runc = mysql_query($queryc);

//error on the line below:
while ($rowc = mysql_fetch_array($query_runc)){

echo 'ok';
}
     

?>




<div id="content-container">

<div id="content_for_site">
<h2>My Meal Planner</h2> <br />
                     
     


     
       
                        My Meal Que:
<br />
<ul>
<form>
<li><input type="checkbox" name="meal_one" value="meal_one" /> Meal One</li>
How many servings will you have? <input type="text" name="meal_one_servings"><br /><br />
<li><input type="checkbox" name="food_one" value="food_one" /> Food One</li>
How many servings will you have? <input type="text" name="meal_one_servings">
</form>

</ul>
<input type="submit" value="delete" name="delete"><br />
<input type="submit" value="add to calendar" name="add_to_calendar">

<br /><br />
<a href="create-a-meal.php">Create A Meal & add to your Meal Que</a><br />
<a href="find-a-meal.php">Find a Meal or Food to Add to your Meal Que</a>

</div>




<div id="clear"></div>
<?php include 'footer.php'; ?>


</div>
</div>

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

This is a new error for me.  I tried looking through some older posts and so far nothing had fixed it and thus I am stumped.

Any idea what could be throwing this error?

Code: [Select]

<table>
  <?php
//open DB connection
include 'dbconn.php';
$sql = "select * tbl_test";
$result = mysql_query($sql,$conn);

print $sql;

while ($row = mysql_fetch_array($result)){
$status = $row['status'];
$space = $row['spacename'];

if ($status=="reserved") {

echo <<<END
<tr>
<td style="background-color:#F00; color:#FFF;" align="center">Reserved</td>
</tr>
END;

    } else {

echo <<<END
<tr>
<td align="center">$space</td>
</tr>
END;

}
}
?>
</table>