Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: total values in row

    Can I have a field in a mysql table that counts the occurances of a character "Y" or "y" in the record (row) and updates itself with each record update?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    can you have a column that holds a count? sure, use INTEGER

    can it update itself? no
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2004
    Posts
    38
    Well, There is no need to have an automatic update field like this because every coder implements procedures to do this.

    Analyzer

  4. #4
    Join Date
    Jun 2004
    Posts
    2
    Any hints at how I can do it? I want to add a field to the table on this page...http://www.lakeside-graphics.com/beefs/avail3.php, that counts the Y's and y's.

Posting Permissions

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