Click here to Skip to main content
11,702,981 members (60,576 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: PHP MySQL
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
0 Maciej Los 415
1 Sergey Alexandrovich Kryukov 325
2 OriginalGriff 260
3 CHill60 120
4 Andy Lanng 119
0 OriginalGriff 8,379
1 Sergey Alexandrovich Kryukov 7,587
2 CPallini 4,947
3 Maciej Los 4,501
4 Mika Wendelius 3,566

Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 31 Mar 2013
Copyright © CodeProject, 1999-2015
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