You are here: Re: SELECT COUNT(*) problem « MySQL Databases « IT news, forums, messages
Re: SELECT COUNT(*) problem

Posted by William Guion on 07/14/05 02:28

Did you spell testfeild correctly in your qurey?

-----===== Bill =====-----

In article <42d5455b$0$24849$edfadb0f@dread11.news.tele.dk>, JB
<nospam@nospam.dk> wrote:

> Hi
> Can somebody help me to get this to work.
> I want to count the only first 20 rows in my database width the contents
> '0' in the testfield
>
> I'v tried this, but it does not work.
> SELECT COUNT(*) FROM `testtable` WHERE testfeild ='0' limit 20
>
> Can somebody tell me what i'm doing wrong ?
>
> Regards
> Jorgen
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация