MySQL Error

bxflow · Jun 23, 2010

Im installed some script but i get this errors

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 99

line 99: while ($y=mysql_fetch_assoc($x))

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 80

Line 80:while ($y=mysql_fetch_assoc($x))

same thing for line 51

server php version is 5.2.13
MySQL version is 5.1.46-log

edit: more info

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/index.php on line 51

(code in red is line 51)

Code:

        </script>
    </head>
    
    <body>
        <div id="fb-root"></div>
        <script>
          window.fbAsyncInit = function() {
            FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status:  true, cookie: true,
                     xfbml: true});
          };
          (function() {
            var e = document.createElement('script'); e.async = true;
            e.src = document.location.protocol +
              '//connect.facebook.net/en_US/all.js';
            document.getElementById('fb-root').appendChild(e);
          }());
        </script>
        
    <div id="header">
            <a href="index.php"  id="branding"><span>LikeItNow</span></a>
            <p id="total_pages" class="rounded"><span  id="count"> <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT  0,1");
        $nr=0;
       [COLOR=Red][B]while ($y=mysql_fetch_assoc($x)) {[/B][/COLOR]
            $id=$y['id'];
            $like=$y['like'];
            ?>
        
              <?=$id?><? echo substr(0,44);?>
              
         <?
    }
    ?></span> pages created</p>
        </div>
        
        <div id="page_details" class="rounded">
            <h2>Create a New Page</h2>
            <p id="character_count"><span  id="characters">50</span> characters available</p>
            <form method="POST" action="index.php">
                <input type="text" name="like" class="comments"  maxlength="50" value="Type your page name here ...">
                <p id="url"></p>

            <button id="create_button"  type="submit"></button>
            </form>
        </div>

DEMO of the SCRIPT: HERE

the its only 1 table in the Database.

here is the whole Index.php file

Code:

<? 
include ("config.php");
if ($_POST["like"]) {
    $like=$_POST["like"];
    mysql_query("INSERT INTO fblike VALUES(NULL, '$like', '1')");
    $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 1");
    while ($y=mysql_fetch_assoc($x)){
$id=$y['id'];
}
    ?>
    <script type="text/javascript">  window.location.href="<?=$url_site?>like.php?id=<?=$id?>";</script>
    <?
}
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"  "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en">
    <head>
        <title>Websie Title.</title>

        <link rel="stylesheet" href="styles.css">
        
        <script type="text/javascript"  src="js/jquery.js"></script>
        <script type="text/javascript"  src="js/jquery.corner.js"></script>
        <script type="text/javascript"  src="js/main.js"></script>

            
        </script>
    </head>
    
    <body>
        <div id="fb-root"></div>
        <script>
          window.fbAsyncInit = function() {
            FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status:  true, cookie: true,
                     xfbml: true});
          };
          (function() {
            var e = document.createElement('script'); e.async = true;
            e.src = document.location.protocol +
              '//connect.facebook.net/en_US/all.js';
            document.getElementById('fb-root').appendChild(e);
          }());
        </script>
        
    <div id="header">
            <a href="index.php"  id="branding"><span>LikeItNow</span></a>
            <p id="total_pages" class="rounded"><span  id="count"> <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT  0,1");
        $nr=0;
       while ($y=mysql_fetch_assoc($x)) {
            $id=$y['id'];
            $like=$y['like'];
            ?>
        
              <?=$id?><? echo substr(0,44);?>
              
         <?
    }
    ?></span> pages created</p>
        </div>
        
        <div id="page_details" class="rounded">
            <h2>Create a New Page</h2>
            <p id="character_count"><span  id="characters">50</span> characters available</p>
            <form method="POST" action="index.php">
                <input type="text" name="like" class="comments"  maxlength="50" value="Type your page name here ...">
                <p id="url"></p>

            <button id="create_button"  type="submit"></button>
            </form>
        </div>
        
        <div id="popular_pages" class="rounded box_420">
            <h2>Most Popular Pages</h2>
            <ul>
                                    <? 
    $x=mysql_query("SELECT * FROM fblike ORDER BY hits DESC LIMIT  0,10");
    $nr=0;
    while ($y=mysql_fetch_assoc($x)) {
        $id=$y['id'];
        $like=$y['like'];
        ?>
        
              <li><a href='like.php?id=<?=$id?>'><?  echo substr($like, 0,44);?></a><br>
              </li>
         <?
    }
    ?>
                            </ul>
        </div>
        
        <div id="new_pages" class="rounded box_420">
            <h2>New Pages</h2>
            <ul>
                                     <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT  0,10");
        $nr=0;
        while ($y=mysql_fetch_assoc($x)) {
            $id=$y['id'];
            $like=$y['like'];
            ?>
            
           <li><a href='like.php?id=<?=$id?>'><?  echo substr($like, 0,44);?></a><br></li>
             <?
        }
        ?>

                                
            </ul>
        </div>
        
            <p id="footer" class="rounded">LikeItNow &copy;  2010. LikeItNow is not related to Facebook</p>

    </body>
</html>

NewEraCracker · Jun 23, 2010

MySQL version?

bxflow · Jun 23, 2010

5.1.46

8char

l0calh0st · Jun 23, 2010

what is sum script? we need this info to fix this.

bxflow · Jun 23, 2010

its some facebook like script

Lock Down · Jun 23, 2010

If this is still not working then try adding this line in front of the lines where it blows up so you can see the contents of $x.

var_dump($x);

Also showing s 10 lines in front and behind the actual error line could be helpful.

bxflow · Jun 24, 2010

that didn't work.

Mr Happy · Jun 24, 2010

It's a custom script or a script we're not familiar with. It could be a hundred things. We need a lot more code. Either link us to the script or post the file here. We need to know what $x is earlier in the script. Ideally we'd need to know what tables it's trying to connect to and if the tables and fields exist.
If it was vB or IPB fine as we have a copy of it but for this we need a lot more code to look at.

bxflow · Jun 24, 2010

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/index.php on line 51

(code in red is line 51)

Code:

        </script>
    </head>
    
    <body>
        <div id="fb-root"></div>
        <script>
          window.fbAsyncInit = function() {
            FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status: true, cookie: true,
                     xfbml: true});
          };
          (function() {
            var e = document.createElement('script'); e.async = true;
            e.src = document.location.protocol +
              '//connect.facebook.net/en_US/all.js';
            document.getElementById('fb-root').appendChild(e);
          }());
        </script>
        
    <div id="header">
            <a href="index.php" id="branding"><span>LikeItNow</span></a>
            <p id="total_pages" class="rounded"><span id="count"> <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1");
        $nr=0;
       [COLOR=Red][B]while ($y=mysql_fetch_assoc($x)) {[/B][/COLOR]
            $id=$y['id'];
            $like=$y['like'];
            ?>
        
              <?=$id?><? echo substr(0,44);?>
              
         <?
    }
    ?></span> pages created</p>
        </div>
        
        <div id="page_details" class="rounded">
            <h2>Create a New Page</h2>
            <p id="character_count"><span id="characters">50</span> characters available</p>
            <form method="POST" action="index.php">
                <input type="text" name="like" class="comments" maxlength="50" value="Type your page name here ...">
                <p id="url"></p>

            <button id="create_button" type="submit"></button>
            </form>
        </div>

DEMO of the SCRIPT: HERE

the its only 1 table in the Database.

here is the whole Index.php file

Code:

<? 
include ("config.php");
if ($_POST["like"]) {
    $like=$_POST["like"];
    mysql_query("INSERT INTO fblike VALUES(NULL, '$like', '1')");
    $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 1");
    while ($y=mysql_fetch_assoc($x)){
$id=$y['id'];
}
    ?>
    <script type="text/javascript"> window.location.href="<?=$url_site?>like.php?id=<?=$id?>";</script>
    <?
}
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en">
    <head>
        <title>Websie Title.</title>

        <link rel="stylesheet" href="styles.css">
        
        <script type="text/javascript" src="js/jquery.js"></script>
        <script type="text/javascript" src="js/jquery.corner.js"></script>
        <script type="text/javascript" src="js/main.js"></script>

            
        </script>
    </head>
    
    <body>
        <div id="fb-root"></div>
        <script>
          window.fbAsyncInit = function() {
            FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status: true, cookie: true,
                     xfbml: true});
          };
          (function() {
            var e = document.createElement('script'); e.async = true;
            e.src = document.location.protocol +
              '//connect.facebook.net/en_US/all.js';
            document.getElementById('fb-root').appendChild(e);
          }());
        </script>
        
    <div id="header">
            <a href="index.php" id="branding"><span>LikeItNow</span></a>
            <p id="total_pages" class="rounded"><span id="count"> <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1");
        $nr=0;
       while ($y=mysql_fetch_assoc($x)) {
            $id=$y['id'];
            $like=$y['like'];
            ?>
        
              <?=$id?><? echo substr(0,44);?>
              
         <?
    }
    ?></span> pages created</p>
        </div>
        
        <div id="page_details" class="rounded">
            <h2>Create a New Page</h2>
            <p id="character_count"><span id="characters">50</span> characters available</p>
            <form method="POST" action="index.php">
                <input type="text" name="like" class="comments" maxlength="50" value="Type your page name here ...">
                <p id="url"></p>

            <button id="create_button" type="submit"></button>
            </form>
        </div>
        
        <div id="popular_pages" class="rounded box_420">
            <h2>Most Popular Pages</h2>
            <ul>
                                    <? 
    $x=mysql_query("SELECT * FROM fblike ORDER BY hits DESC LIMIT 0,10");
    $nr=0;
    while ($y=mysql_fetch_assoc($x)) {
        $id=$y['id'];
        $like=$y['like'];
        ?>
        
              <li><a href='like.php?id=<?=$id?>'><? echo substr($like, 0,44);?></a><br>
              </li>
         <?
    }
    ?>
                            </ul>
        </div>
        
        <div id="new_pages" class="rounded box_420">
            <h2>New Pages</h2>
            <ul>
                                     <? 
        $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,10");
        $nr=0;
        while ($y=mysql_fetch_assoc($x)) {
            $id=$y['id'];
            $like=$y['like'];
            ?>
            
           <li><a href='like.php?id=<?=$id?>'><? echo substr($like, 0,44);?></a><br></li>
             <?
        }
        ?>

                                
            </ul>
        </div>
        
            <p id="footer" class="rounded">LikeItNow &copy; 2010. LikeItNow is not related to Facebook</p>

    </body>
</html>

litewarez · Jun 24, 2010

lol your Query is wrong

PHP:

$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT  0,1');

//Try dump out whit it is, using the code below
var_dump($x); //See if it comes back as a resource.

if it returns (bool) false then the table fblike does not exists or the column id does not exist.

natsu90 · Jun 25, 2010

i'm not real smart but try to help. also got this error once ago and solved. try changing into another name instead 'like' on your db. it's a reserved word. don't forget to change the name on php too. regard.

edit: i mean 'like' on column name of 'fblike' table, not on the db name

bxflow · Jun 25, 2010

litewarez said:
lol your Query is wrong

PHP:

$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1'); //Try dump out whit it is, using the code below var_dump($x); //See if it comes back as a resource.

if it returns (bool) false then the table fblike does not exists or the column id does not exist.

i tried it and it returned (bool) false

the database is there so is the table fblike
so idk wtfak is wrong

Whoo · Jun 25, 2010

Before you do something with the $x, and after the query, add this:

PHP:

if(mysql_num_rows($x)){
  //Do your stuff
}else{
  //No results found
}

Lock Down · Jun 25, 2010

That won't help except to say there is an error/empty just like the var_dump did.

replace

var_dump($x);

with

if (mysql_error()){echo "<br>Error on fblike table: ".mysql_error();}

litewarez · Jun 25, 2010

No dont do all that, whoo your wrong, you cant count the rows if mysql_result returns false;

Copy the query and run it within phpMyAdmin and send us the error. IF there is no error, make sure your selecting the correct db in your config.

bxflow · Jun 26, 2010

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1')' at line 1

Mr Happy · Jun 26, 2010

bxflow said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1')' at line 1

The only part you run in PHPmyadmin is

Code:

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

Anyway a bit offtopic but you should escape this and make it safe:

PHP:

$like=$_POST["like"];

PHP:

$like=mysql_real_escape_string($_POST["like"]);

It will help prevent hacking and make your script safer.

More info here http://php.net/manual/en/function.mysql-real-escape-string.php

litewarez · Jun 26, 2010

yea what he said.

Whoo · Jun 26, 2010

litewarez said:
No dont do all that, whoo your wrong, you cant count the rows if mysql_result returns false;

Copy the query and run it within phpMyAdmin and send us the error. IF there is no error, make sure your selecting the correct db in your config.

Using the code I have given it won't do anything if the result is 0 :P , but yeah it won't help fixing a error in the query.

bxflow · Jun 26, 2010

Mr Happy said:
The only part you run in PHPmyadmin is

Code:

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

Anyway a bit offtopic but you should escape this and make it safe:

PHP:

$like=$_POST["like"];

PHP:

$like=mysql_real_escape_string($_POST["like"]);

It will help prevent hacking and make your script safer.

More info here http://php.net/manual/en/function.mysql-real-escape-string.php

thanx,

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1' at line 1

MySQL Error

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

The Wise One

Active Member

Active Member

Active Member

Active Member

Active Member

The Wise One

Active Member