Chris Haensel wrote: > Hi guys, > > maybe I am too stupid, but I can not see a solution for this. Have been > cracking up my brain for the last hours, so I finally dare to ask. > > I have a database table with some columns > > > text1 | text2 | text3 | text4 > ---------------------------------------------- > > > Now, for some stats thingy, I am trying to get the COUNT of distinct entries > So, i would like to get the count of entries where text2 is foo OR text3 is > foo > > I have 20.863 entries at the moment, and it takes quite a lot of time > reading through that stuff. > I have tried > > SELECT COUNT(*) as mycount FROM mytable WHERE text2 = 'foo' and text3 = > 'foo' > > but I neither get an error nor any output. It just loads and loads without > any output... > > I am out of ideas :o( Help, anybody? :o)) > > Chris > > > > The amount of records is not that big to slow things down. Did you use indexes on your database? And did you try running the query through commandline or phpMyAdmin? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
