Which user are you connected as?
Who owns the table?
unless you connected as the user who owns the table or table is owned by dbo
you have to specify username.TBL_DEPT (where username is the name of the
user who owns the table)
At 16:47 06.07.2001 +0800, you wrote:
>[EMAIL PROTECTED]
--
PHP
if you just need the number
SELECT COUNT(*) FROM table where
At 06:34 PM 3/30/2001 +0100, DC wrote:
>Hi All
>I cant quite work out how to count the number of rows in my mysql db that
>match a certain critieria and the show that number numericaly in my pages.
>
>Checked books, ph
The article on PHP builder on the topic
http://www.phpbuilder.com/columns/alberto2919.php3
At 04:56 PM 3/29/2001 -0500, David L Jarvis wrote:
>Greetings
>
>I have a Red-Hat Linux 6.2 web server with Apache 1.3.9
>and PHP3 (would like to move to PHP4 immediately),
>and the database server is Wi