MYSQL_LIBS = no value

[shelbytll]

Hi,

i just installed apache, mysql and php on linux.
All are running fine until my php script want to connect to mysql.
It says Table 'DBName.TableName' doesn't exist
However, using mysqlcc to connect, I can see the database and tables. So i guess the prob should lies in PHP configuration.

I compiled PHP with:
./configure --prefix=/etc/php --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc/httpd/conf --with-mysql --with-system-regex

I never put in the path for mysql.
So i run phpinfo(). The MYSQL_LIBS directive says "no value".
Has it got to do with that? If yes how can I set the value?

[jstarkey]

Nah, it's probably just saying you didn't enter a value. My machines have the same result, and they're all running mysql and php fine.

What's a mysqlcc? 'DBName.TableName' -- is that just you replacing the names?

I'm moving this to the DB forum where you'll probably get better answers.

[shelbytll]

hi,

just realise that the table name is case sensitive. has nothing to do with mysql_lib.