#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    schwaz
    Posts
    1
    Rep Power
    0
    I use phpgem to generate forms. it works fine, just one problem with count, I get error messages like this (from the php-script - NOT when i query mysql directly!):
    SQL query: SELECT COUNT(*) FROM hupoterm WHERE (LOWER(gruppe) LIKE '%e%')
    Warning: count not found in MySQL result index 2 in sql.php3 on line 255

    Could this mean a problem with my table syntax? since 6 days i changed almost all config-parameters in the script, in the table ..... but the error message is still there ...
    please help, thanks!!!

    GREAT! it seems to work - thanks for the tip!
    a big step for me and a small step for mankind

    [This message has been edited by juan (edited February 03, 2000).]
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Try this:

    SELECT COUNT(*) as count FROM hupoterm WHERE (LOWER(gruppe) LIKE '%e%'

Similar Threads

  1. SELECT and COUNT
    By bradbrevet in forum MySQL Help
    Replies: 1
    Last Post: February 16th, 2004, 05:01 PM
  2. SELECT COUNT(), JOIN AND GROUP Problem...
    By DustinDavis in forum MySQL Help
    Replies: 9
    Last Post: February 5th, 2004, 03:06 PM
  3. Replies: 1
    Last Post: January 13th, 2004, 06:14 PM
  4. select count from multiple table errors
    By pf_langan in forum MySQL Help
    Replies: 2
    Last Post: December 12th, 2003, 09:07 PM
  5. Query with count & select columns not working?
    By Falsedawn in forum MySQL Help
    Replies: 4
    Last Post: December 11th, 2003, 06:47 AM

IMN logo majestic logo threadwatch logo seochat tools logo