Re: [PHP-DB] SQL error:

2001-07-06 Thread Andrei Skorokhod
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

Re: [PHP-DB] count function?

2001-03-30 Thread Andrei Skorokhod
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,