SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    exit();
    Join Date
    Jul 2000
    Posts
    759
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In mySQL, I have an ID column, if I type:

    SELECT ID FROM content; in Telnet...

    it will list

    1
    2
    3
    4

    etc then says 4 rows or whatever at the bottom.

    Is there a way that I can display the total amount of rows in that column?

    Thanks..



    ------------------
    ICQ Me! (73902680)

  2. #2
    SitePoint Evangelist
    Join Date
    May 2000
    Location
    Canada
    Posts
    533
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SELECT count(*) as count FROM content;

    should do the trick

    hope that helps
    --------------------
    SitePoint Moderator
    We eat,sleep,drink PHP. are you looking for a PHP host?

  3. #3
    exit();
    Join Date
    Jul 2000
    Posts
    759
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you! I will try this...

    ------------------
    ICQ Me! (73902680)


Bookmarks

Posting Permissions

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