1064 Error -- Baffled

Wynder

At the mysql command prompt in linux I type:

mysql_connect("localhost", "root");

And get this:

ERROR 1064: You have an error in your SQL syntax near 'mysql_connect("localhost", "root")' at line 1

Completely baffled -- anyone able to shed some light?

Wynder

nnichols

that is the php function for connecting to mysql.

Going by the error you recieved - you are already connected to mysql. Just select your db and query away

Wynder

I'm trying to get a web-package running.. php-csl and I'm getting this error:

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/include/config.php on line 4

The line of code it's refering to is:

return mysql_connect("localhost", "root");

I don't think that the webpage had connected, so I'm thinking it's related...

Wynder

nnichols

This probably means you have PHP compiled without mySQL support.

Use "phpinfo();" in a file of it's own and it will tell you what php modules are compiled in.

You can also check the settings for your php installation in the php.ini file.

Hope this helps 😉

Wynder

I had thought that initially too... however.

supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT

From the phpinfo() function.

It's just reeaaally wierd.

nnichols

What flavour of *nix are you running on? Is it on your local machine or remote server?

Wynder

Local machine running RedHat 7.3, PHP 4.2.2, and MySQL 3.23.52.

Wynder

nnichols

Have you installed php-mysql.rpm?

Wynder

Woot!

Just downloaded and installed -- works perfectly. Thanks a lot -- I REALLY appreciate you taking the time to help me through that mess. Unless you're in some type of body cast, please reach around and pat yourself on the back. 🙂

Best Regards,
Wynder