Results 1 to 5 of 5

Thread: [resolved]Num records in table (MySQL database manipulation with php)

  1. Oct 9th, 2006, 07:58 AM #1
    vagabon
    vagabon is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2005
    Posts
    74

    Resolved [resolved]Num records in table (MySQL database manipulation with php)

    Is there a way to get the number of entries (records, lines) in a table. I've been doing it a very ineffeciant way and I know I can't keep doing it. I've called Select (one column) from table then using msql_numrows on the result. There's got to be a better way. Also, if I can select the last entry it can tell me because it has a row with autoIncrements.
    Last edited by vagabon; Oct 11th, 2006 at 09:17 AM.
    Reply With Quote Reply With Quote
  2. Oct 9th, 2006, 10:41 AM #2
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594

    Re: Num records in table (MySQL database manipulation with php)

    Use the COUNT sql function.

    And no, selecting the last entry and checking its ID does not give you a reliable count. For one, the ID could wrap around eventually. More importantly, it would still count deleted rows.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
  3. Oct 10th, 2006, 09:43 AM #3
    vagabon
    vagabon is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2005
    Posts
    74

    Re: Num records in table (MySQL database manipulation with php)

    Whats the exact name of the function? I looked up count but that didn't seem as if it would work.
    Reply With Quote Reply With Quote
  4. Oct 10th, 2006, 11:14 AM #4
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594

    Re: Num records in table (MySQL database manipulation with php)

    Code:
    SELECT COUNT(*) FROM tablename
    As simple as it gets.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
  6. Oct 11th, 2006, 09:16 AM #5
    vagabon
    vagabon is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2005
    Posts
    74

    Re: Num records in table (MySQL database manipulation with php)

    Okay, thank you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width