Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Feb 2007
    Location
    FL
    Posts
    35
    Thanks
    4
    Thanked 0 Times in 0 Posts

    # of return records

    Does any one know how to display how many records i get back from the DB on a query?

    PHP Code:
    $MySQL_SelecttSearch mysql_query(
                
    "SELECT * FROM Video " 
    This is my Query
    Thanks

  • #2
    Senior Coder
    Join Date
    Apr 2007
    Location
    Quakertown PA USA
    Posts
    1,028
    Thanks
    1
    Thanked 125 Times in 123 Posts
    PHP Code:
    $rec_count mysql_num_rows($MySQL_SelectSearch);

    echo 
    $rec_count

  • Users who have thanked PappaJohn for this post:

    moiseszaragoza (12-01-2008)

  • #3
    New Coder
    Join Date
    Feb 2007
    Location
    FL
    Posts
    35
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks that helps allot

  • #4
    Regular Coder ohgod's Avatar
    Join Date
    Jun 2008
    Location
    Ohio
    Posts
    579
    Thanks
    6
    Thanked 69 Times in 69 Posts
    and just in case it comes in handy...

    http://us.php.net/manual/en/book.mysql.php


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •