Can you give me a syntax example. I've found my sock file but seem to be having trouble getting it right on the mysql_pconnect line,
my sock is /var/lib/mysql/mysql.sock Thanks in advance! So close but yet so far. :) My first MySql project. "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Figure out where your mysql.sock file is and provide the path right in > your mysql_connect() call. "mysqladmin version" tells you the path. > > -Rasmus > > On Sat, 23 Mar 2002, Jim Hankins wrote: > > > I'm doing a simple database connection using the follow syntax: > > > > <html> > > <head> > > <title>Book-O-Rama Search Results</title> > > </head> > > <body> > > <h1>Book-O-Rama Search Results</h1> > > <? > > if (!$searchtype || !$searchterm) > > { > > echo "You have not entered search details. Please go back and try > > again."; > > exit; > > } > > > > $searchtype = addslashes($searchtype); > > $searchterm = addslashes($searchterm); > > > > @ $db = mysql_pconnect("localhost", "bookorama", "bookorama123"); > > > > if (!$db) > > { > > echo "Error: Could not connect to database. Please try again later."; > > exit; > > } > > > > When I go to the search page and hit submit (after removing the @ to see an > > error on the mysql_pconnect line) > > I get Warning: Can't connect to local MySQL server through socket > > '/tmp/mysql.sock' (2) in /home/jhankins/public_html/mydirectory/results.php > > on line 17 > > > > I can telnet to the host and with the same username and password access the > > database tables etc. What gives? I'm using > > 4.0.6 of PHP and apache under Redhat Linux 7.2. Mysql is working fine from > > command line and remote via odbc? > > > > Also tryed mysql_connect with same problem. > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
