Result status

[ballouta]

Hello

I have the following query, i want to display the table header if the result was > 0

I was trying this but it is not working:

<?php
$sql = mysql_query("SELECT * from members where `username` LIKE '%$usr%' ");
if (mysql_num_rows($sql) > 0)
    {
   //print table header

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

        //print members found
             }


    }
else
{
//no members found
{
?>

 

please help

Thank you

[JonnoTheDev]

Your code is fine. What is the issue? If 0 results are found check that your query is correct.