How to count total number of results found in php?

Discussion in 'PHP/MySql' started by ststacytucker9, May 29, 2010.

Remove these ads by signing in
Remove these ads by signing in
  1. ststacytucker9 New Member

    Member Since:
    Feb 20, 2010
    Message Count:
    5
    Likes Received:
    0
    Hello everyone

    anyone can please help me I want to show total number of records search by string at the top of my page. Please help me how can I do this?
    [FONT=&quot]
    Thanks in advance[/FONT]
  2. SCHripts New Member

    Member Since:
    Jun 14, 2010
    Message Count:
    16
    Likes Received:
    0
    Not sure if this is gonna help much, your question isn't the most direct!

    mysql_query("SELECT * FROM tablename");

    is the query to select everything from a table
  3. balajia New Member

    Member Since:
    Jul 1, 2010
    Message Count:
    27
    Likes Received:
    1
    Occupation:
    Web Developer
    Location:
    India
  4. PradeepKr New Member

    Member Since:
    Aug 16, 2010
    Message Count:
    22
    Likes Received:
    0
    mysql_num_rows(); in PHP gives the number of rows in the resultset.
  5. dianatheprinces New Member

    Member Since:
    Aug 11, 2010
    Message Count:
    54
    Likes Received:
    1
    you can use count function for counting number of records
  6. jennifersmith New Member

    Member Since:
    Nov 16, 2010
    Message Count:
    67
    Likes Received:
    1
    first select the database
    $total_number_of_records = count($fetched_records_from_db);
    insert query display result..
  7. IdealTech New Member

    Member Since:
    Nov 16, 2010
    Message Count:
    21
    Likes Received:
    0
    Location:
    Illinois, USA
    mysql_numrows() function returns the number of rows returned from an fetched SQL.

Share This Page