help with php search

Question

How would I do let the user know if there wasnt any rows found? And if it finds (for example) 26 rows I want it to print that it found 26 hits (Your search for "hey" gave 26 results)

$name = mysql_real_escape_string($_POST['player_name']);

$q = mysql_query("SELECT * FROM players WHERE name LIKE '%$name%'");

while ($row = mysql_fetch_array($q)) { 

$name  = $row['name']; 

    echo "<ul>\n"; 
    echo "<li>" . "<a  href=\"player-info.php?id=\">"   .$name . " </a></li>\n"; 
    echo "</ul>"; 
}

Will Vousden · Accepted Answer · 2010-01-04 11:19:53Z

3

Use mysql_num_rows:

$rowCount = mysql_num_rows($q);
if ($rowCount === 0)
{
    echo 'Found nothing!';
}
else
{
    echo "Found $rowCount rows!";
    while ($row = mysql_fetch_array($q))
    { 
        $name  = $row['name'];
        echo "<ul>\n"; 
        echo "<li>" . "<a  href=\"player-info.php?id=\">"   .$name . " </a></li>\n"; 
        echo "</ul>"; 
    }
}

answered Jan 4, 2010 at 11:19

Will Vousden

33.5k9 gold badges89 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Emil Vikström · Accepted Answer · 2010-01-04 11:17:33Z

1

Check out mysql_num_rows

answered Jan 4, 2010 at 11:17

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

Comments

Simon · Accepted Answer · 2010-01-04 11:18:48Z

1

mysql_num_rows

$numberOfResults = mysql_num_rows($q);

answered Jan 4, 2010 at 11:18

Simon

38k2 gold badges37 silver badges27 bronze badges

Collectives™ on Stack Overflow

help with php search

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related