Click here to Skip to main content
13,143,774 members (31,511 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hi! So I'm a super noob beginner in pHp and I'm just doing my best to understand all of this.
I've managed to fix every problem that I've come in contact with except this one.

mysql_num_rows() expects parameter 1 to be resource, boolean given

I get this error from trying to run this

if(isset($_POST['search_name'])) {
    $search_name = $_POST['search_name'];
    if(!empty($search_name)) {
        $query = "SELECT guild, focus, website, leader, members, voip, post, yes_no_website, single_multiple_leadersw FROM guilds WHERE guild LIKE '%".mysql_real_escape_string($search_name)."%'";
        $query_run = mysql_query($query);
                if (mysql_num_rows($query_run)>=1) {
                    while ($query_row = mysql_fetch_assoc($query_run))  {
                        echo $query_row['guild'];

                echo 'No results found.';

And I have no idea how to fix this, I apologize if I didn't post in the correct format or something.

Thanks for any help
Posted 31-Mar-13 15:45pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

According to documentation,for SELECT and other statements returning resultset, mysql_query()[^] returns a resource on success, or FALSE on error. Check your query in console or any MySQL gui tool.
Place breakpoint (if you are using some intelligent IDE) or var_dump($query_run) after mysql_query($query) and you will see, what the function call returned.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170915.1 | Last Updated 31 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100