PHP - Warning: Mysql_num_rows() Error For My Uni Project

i give it up after 4 h.

please help me, what i do wrong

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 14.

<?PHP
require_once("dbcheck.php");
require_once("check.php");
$Username=$_COOKIE['Username'];
$Password=$_COOKIE['Password'];
$Nickname=$_COOKIE['Nickname'];
$Username=mysql_real_escape_string($Username);
$Password=mysql_real_escape_string($Password);

date_default_timezone_set('Asia/Calcutta');

$action = $_GET['do'];
$Result=mysql_query("SELECT * FROM Checks WHERE UserName='$Username'");
$Rowexist=mysql_num_rows($Result);
if($Rowexist!=0){
while($Rows=mysql_fetch_array($Result))
{
$Serial    = $Rows['Serial'];
$Banned    = $Rows['Banned'];
$IP       = $Rows['IP'];
$Used       = $Rows['Used'];
$First       = $Rows['First'];
$Duration    = $Rows['Duration'];
$Total       = $Rows['Total'];
$Time       = $Rows['Time'];
}
if($action=="" || $action=="Banlist"){
mysql_query("UPDATE Checks SET NickName='$Nickname' WHERE UserName='$Username'");
?>

some please help - basically have a simple password change php page

$sql="UPDATE t_members SET Password = '$New_Password' WHERE Username = '$My_Username' AND  Password = '$Old_Password'";
   
   echo $sql;
   
   $result=mysql_query($sql) or die(mysql_error());
   $firstcount = mysql_num_rows($result);

and i get this annoying error Warning: mysql_num_rows(): supplied argument is not a valid

the sql statement works as i see it updating the database correctly

Hi,

After moving server my script started showing this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/user/public_html/blog.php on line 107

Here is the code on line 107:
if(mysql_num_rows($ExeqryComm)!=0){

Any help please?

Thank you all

Hi all, complete newbie here.

i have copied this example php code to insert data and a picture into a mysql database. however i get this error.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

can be seen here : http://wycombedjs.co.uk/mix/sqltest.php

Any help would be much appreciated.. thanks


Code: [Select]
<?php
$db_host = 'xxx'; // don't forget to change 
$db_user = 'xxx'; 
$db_pwd = 'xxx';

$database = 'mixdb';
$table = 'ae_gallery';
// use the same name as SQL table

$password = '123';
// simple upload restriction,
// to disallow uploading to everyone


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s)
{
    if (get_magic_quotes_gpc())
        $s = stripslashes($s);

    return mysql_real_escape_string($s);
}

// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
    // cleaning title field
    $title = trim(sql_safe($_POST['title']));

    if ($title == '') // if title is not set
        $title = '(empty title)';// use (empty title) string

    if ($_POST['password'] != $password)  // cheking passwors
        $msg = 'Error: wrong upload password';
    else
    {
        if (isset($_FILES['photo']))
        {
            @list(, , $imtype, ) = getimagesize($_FILES['photo']['tmp_name']);
            // Get image type.
            // We use @ to omit errors

            if ($imtype == 3) // cheking image type
                $ext="png";   // to use it later in HTTP headers
            elseif ($imtype == 2)
                $ext="jpeg";
            elseif ($imtype == 1)
                $ext="gif";
            else
                $msg = 'Error: unknown file format, .png, .jpeg, .gif only!';

            if (!isset($msg)) // If there was no error
            {
                $data = file_get_contents($_FILES['photo']['tmp_name']);
                $data = mysql_real_escape_string($data);
                // Preparing data to be used in MySQL query

                mysql_query("INSERT INTO {$table}
                                SET ext='$ext', title='$title',
                                    data='$data'");

                $msg = 'Success: image uploaded to Mix db';
            }
        }
        elseif (isset($_GET['title']))      // isset(..title) needed
            $msg = 'Error: file not loaded';// to make sure we've using
                                            // upload form, not form
                                            // for deletion


        if (isset($_POST['del'])) // If used selected some photo to delete
        {                         // in 'uploaded images form';
            $id = intval($_POST['del']);
            mysql_query("DELETE FROM {$table} WHERE id=$id");
            $msg = 'Photo deleted';
        }
    }
}
elseif (isset($_GET['show']))
{
    $id = intval($_GET['show']);

    $result = mysql_query("SELECT ext, UNIX_TIMESTAMP(image_time), data
                             FROM {$table}
                            WHERE id=$id LIMIT 1");

    if (mysql_num_rows($result) == 0)
        die('no image');

    list($ext, $image_time, $data) = mysql_fetch_row($result);

    $send_304 = false;
    if (php_sapi_name() == 'apache') {
        // if our web server is apache
        // we get check HTTP
        // If-Modified-Since header
        // and do not send image
        // if there is a cached version

        $ar = apache_request_headers();
        if (isset($ar['If-Modified-Since']) && // If-Modified-Since should exists
            ($ar['If-Modified-Since'] != '') && // not empty
            (strtotime($ar['If-Modified-Since']) >= $image_time)) // and grater than
            $send_304 = true;                                     // image_time
    }


    if ($send_304)
    {
        // Sending 304 response to browser
        // "Browser, your cached version of image is OK
        // we're not sending anything new to you"
        header('Last-Modified: '.gmdate('D, d M Y H:i:s', $ts).' GMT', true, 304);

        exit(); // bye-bye
    }

    // outputing Last-Modified header
    header('Last-Modified: '.gmdate('D, d M Y H:i:s', $image_time).' GMT',
            true, 200);

    // Set expiration time +1 year
    // We do not have any photo re-uploading
    // so, browser may cache this photo for quite a long time
    header('Expires: '.gmdate('D, d M Y H:i:s',  $image_time + 86400*365).' GMT',
            true, 200);

    // outputing HTTP headers
    header('Content-Length: '.strlen($data));
    header("Content-type: image/{$ext}");

    // outputing image
    echo $data;
    exit();
}
?>
<html><head>
<title>MySQL Blob Image Gallery Example</title>
</head>
<body>
<?php
if (isset($msg)) // this is special section for
                 // outputing message
{
?>
<p style="font-weight: bold;"><?=$msg?>
<br>
<a href="<?=$PHP_SELF?>">reload page</a>
<!-- I've added reloading link, because
     refreshing POST queries is not good idea -->
</p>
<?php
}
?>
<h1>Blob image gallery</h1>
<h2>Uploaded images:</h2>
<form action="<?=$PHP_SELF?>" method="post">
<!-- This form is used for image deletion -->

<?php
$result = mysql_query("SELECT id, image_time, title FROM {$table} ORDER BY id DESC");
if (mysql_num_rows($result) == 0) // table is empty
    echo '<ul><li>No images loaded</li></ul>';
else
{
    echo '<ul>';
    while(list($id, $image_time, $title) = mysql_fetch_row($result))
    {
        // outputing list
        echo "<li><input type='radio' name='del' value='{$id}'>";
        echo "<a href='{$PHP_SELF}?show={$id}'>{$title}</a> &ndash; ";
        echo "<small>{$image_time}</small></li>";
    }

    echo '</ul>';

    echo '<label for="password">Password:</label><br>';
    echo '<input type="password" name="password" id="password"><br><br>';

    echo '<input type="submit" value="Delete selected">';
}
?>

</form>
<h2>Upload new image:</h2>
<form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
<label for="title">Title:</label><br>
<input type="text" name="title" id="title" size="64"><br><br>

<label for="photo">Photo:</label><br>
<input type="file" name="photo" id="photo"><br><br>

<label for="password">Password:</label><br>
<input type="password" name="password" id="password"><br><br>

<input type="submit" value="upload">
</form>
</body>
</html>

Hi, I am having an issue with a piece of code. I am getting the following error, any ideas please?

Quote

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ...


Code: [Select]
<?php
include "scripts/connect.php";

$last = $_GET['ref']; // This will be the ID of the page

echo "the ref number is $last";

$query = mysql_query("SELECT * FROM news WHERE `ref` = '$last'");

if(mysql_num_rows($query)==0){

die("Something went wrong, contact Administrator!");

  }else{
 
while($info = mysql_fetch_array($query)){
$title = $info ['title'];

echo "<p><a href=\"..news.php\" target=\"_blank\">$title >></a></p>";

}
}
?>

Get an error saying:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\admin\delete.php on line 16
Sorry, but we can not find an entry to match your query

Surely this means the code has worked because of the last line, but i can't get rid of the error!


$q = "DELETE FROM `stocklist` WHERE `Stock Number`='".$rec."'";

$res = mysql_query($q, $link)
 or die (mysql_error());
 
$anymatches = mysql_num_rows($res); 
if ($anymatches == 0)
die ('Sorry, but we can not find an entry to match your query<br><br>'); 
 
  echo '<h1>Entry has been deleted!</h1><br><br>';

mysql_close($link);

Here is my CODE which is showing some error:

Code: [Select]
<?php
include('dbcon.php');
session_start();
$usname=$_POST['usname'];
$password=$_POST['password'];
$usname = stripslashes($usname);
$password = stripslashes($password);
$usname = mysql_real_escape_string($usname);
$password = mysql_real_escape_string($password); 
$check="y";
$sql = "select * from usname where usname='$usname' and password='$password'"; 
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count==1)
{
$sqlq = "select * from usname where usname='$usname' and password='$password' and check='$check'"; 
$resultq=mysql_query($sqlq);
$countq=mysql_num_rows($resultq);
if($countq==1)
{$_SESSION['usname']=$usname;
header('location:fire.php');}
else
{$_SESSION['status']="Admin Didnt grant you the permission to access the things";
header('location:index.php');}
}
else
{$_SESSION['status']="Wrong username and password";
header('location:index.php');}

die(" ");
?>


And here are the ERRORS when the username and passwords are correct but the check is not equal to 'y'....



Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\money\verify.php on line 18

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\money\verify.php:18) in C:\xampp\htdocs\money\verify.php on line 24


Please tell me where is the mistake...........

Hi guys, one of the last questions from me for a while i hope lol

i am trying to check if a phone number allready exists in a database using mysql_num_rows


The code is this:
Code: [Select]
$SQL = "SELECT * FROM postcode WHERE phone = $phone";
$result = mysql_query($SQL);
$num_rows = mysql_num_rows($result);

if ($num_rows > 0) {
$errorMessage = "It seems that this phone number is already been entered into our database";
}

else {bla bla bla

But i keep getting a warning message: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in

I am at my wits end with this and done a lot of searching to try and find out why this is, but obviously i am dim and need it to be explained in english.
Cheers!

I'm trying to check the number of results returned in a query.  Currently there is one result being returned but i'm getting this error when I try to run line 38: Code: [Select]
$num_rows = mysql_num_rows($ratings);


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haas12/public_html/login/rateVideo.php on line 38
Rows

Code: [Select]
$ratingsQuery = "SELECT * FROM haas12_test.ratings ";

$ratings = mysqli_query($conn, $ratingsQuery)
or die ("Couldn't execute query.");

$num_rows = mysql_num_rows($ratings);
echo "$num_rows Rows\n";

Hello there,

I'm having a issue where when I run the following statement:


$Session = $Module['MySQL']->RowCount("SELECT * FROM xhost_accounts WHERE (account_username = '{$Module['MySQL']->Escape($AccountUsername)}' OR account_email = '{$Module['MySQL']->Escape($AccountUsername)}') AND account_password = MD5('{$AccountPassword}')") == 1 ? true:false;


I am proceeded by the following error:

Code: [Select]
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\Backend\MySQL-Module.php on line 49

Yet when I do the following statement:


echo $Module['MySQL']->RowCount("SELECT * FROM xhost_accounts WHERE (account_username = '{$Module['MySQL']->Escape($AccountUsername)}' OR account_email = '{$Module['MySQL']->Escape($AccountUsername)}') AND account_password = MD5('{$AccountPassword}')")


It gives me the output of 2 (That's the correct table row count)?

Does anybody have any insight into why this could be happening thanks.

Trying to get this to work but I know I'm missing something here. It's a form that is meant to update a record in DB.
I am getting errore reference to first if (mysql_num_rows($result) == 1) in code and error message: Error has occurred.



$connection = mysql_connect("xxxxxxxx","xxxxxx","xxxxxx");
if (!$connection) {
  die("Error connecting to database " . mysql_error());
}
if (isset($_POST['submitted']))

$name = $_POST['name'];
$email = $_POST['email'];
$PHOTOGRAPHERID = $_POST['PHOTOGRAPHERID'];

$query = "SELECT * FROM Photographers WHERE PHOTOGRAPHERID = $PHOTOGRAPHERID";
$result = mysql_query($query);
if (mysql_num_rows($result) == 1){

// Make the query.
$query = "UPDATE Photographers SET name='$name',email='$email' WHERE PHOTOGRAPHERID=$PHOTOGRAPHERID";
$result = @mysql_query ($query); // Run the query.
if (mysql_affected_rows() == 1) { // If it ran OK.

header("Location: http://".$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF'])."/"."search.php");


} else { // If it did not run OK.
echo '<h1 id="mainhead">System Error</h1>
<p class="error">The name could not be edited due to a system error. We apologize for any inconvenience.</p>'; // Public message.
echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message.
exit();
}

} else { 
echo '<h1 id="mainhead">Error!</h1>
<p class="error">Error has occurred.</p>';

}


$query = "SELECT name, email FROM Photographer WHERE PHOTOGRAPHERID=$PHOTOGRAPHERID";
$result = @mysql_query ($query); // Run the query.

// Create the form.
echo '<h2>Edit a User</h2>
<form action="update.php" method="post">
<p>Name: <input type="text" name="name" size="60" maxlength="60" value="' . $row[0] . '" /></p>
<p>Email: <input type="text" name="email" size="60" maxlength="60" value="' . $row[1] . '" /></p>
<p><input type="submit" name="submit" value="Submit" /></p>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="PHOTOGRAPHERID" value="' . $id . '" />
</form>';

I have tried to create a basic login form.
When I enter the username and password I get this error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in login.php on line 10

Code: [Select]
<?php
require("connection.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$username=mysql_real_escape_string($_POST['username']);
$password=mysql_real_escape_string($_POST['password']);
$password=md5($password);
$sql="SELECT id FROM user WHERE username='$username' and password='$password'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);


if($count==1)
{
header("location: dashboard.php");
}
else
{
$error="Invalid username or password";
}
}
?>
<form action="login.php" method="POST">
<table class="ltext">
<tr>
<td>
Username
</td>
<td>
<input type="text" name="usename" class="input" />
</td>
</tr>
<tr>
<td>
Password
</td>
<td>
<input type="password" name="password" class="input" />
</td>
</tr>
</tr>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Login" name="submit" class="input" />
<input type="reset" value="Clear" name="clear" class="input" />
</td>
</tr>
</table>
</form>
I can't figure out why I am getting that error message does anyone have any ideas?