Hi!
first of all, the fatal error indicates that the mysql extension is
missing or just disabled. To find out what's wrong check for the file
php_mysql.(so|dll) [using *nix|Windows] in the php-extension directory.
If present, then open the php.ini file and search for the string
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does anyone have any ideas
Denis Gerasimov wrote:
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does
The code appears to be correct. But it sounds like a problem with the
php/mysql
integration. Try reinstalling PHP with the correct mysql libraries. In
phpinfo check
that mysql support is enabled. If you are not technical and would just
like to learn
the PHP language not how to configure it etc.
Mike,
There is no database sepcified in your code anywhere. The line:
$result = mysql_query($sql);
does not specify which database you are connecting to either. You can
specify the database in the line:
$link =
mysql_connect($host,$user,$password,$database);
Its very likely that he has installed the latest versions of mysql and php
and is using the incorrect library to try and make it go...change to the
latest mysqli librabry and try again
basiten
From: Stefan Reimers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Re: Newbie Setup
Hi Mike
I am using the same book and am very much a newbie also, I had loads of
problems just like your having. The best way I think just to set it up and run
programs is to use Easyphp. You can get it at www.easyphp.org. It will install
everything for you (php, mysql + apache) in one
To all, I am sorry the correct line is:
mysql_select_db($link,database name)
If you are missing the database name you will get an error concerning
undefined function.
jzf
J. Connolly wrote:
Mike,
There is no database sepcified in your code anywhere. The line:
$result =
I'm having trouble with having trouble with doing an update after doing an
insert on and a select on a table. The order of execution is:
$result = mysql_query(select token from tokenuserid where userid =
'$none' );
if (!$result)
echo mysql_error();
$numresult =
To: php-db@lists.php.net
From: Mike Rondeau [EMAIL PROTECTED]
Date: Sun, 6 Feb 2005 17:57:17 -0800
Subject: Newbie Setup Trouble
Hello,
Hi :)
I have just begun study of using PHP, MySQL and
Apache server. Right
now
I'm following a book, PHP and MySQL For Dummies and
am having trouble
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
Change yourr code to place the sql into a variable and the echo the variable
out to see what the problem might be. You can also cut'n'paste the variable
into the the mysql gui of your choice to see if there are other errors
Bastien
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message says, doesn't support the new, more
secure authentication protocol. Your choices are to tell mysql to use the
older, less-secure protocol, or build a copy of php using your current
Bastien, Thanks for your help!.
I think I found the answer to my problem. My system is a windows based
system and it is not windows based. The system where the code doesn't work is
Unix
and is case sensitive. I went online to the mysql reference and found this
link,
Hello
I have 2 tables with two columns in each one (cloned tables) like this :
ID int(6)
UserName varchar(25)
and i would like to select usernames from table1 that doesnt appear in table2
so i did this :
SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON
(a.UserName = b.username)
and
hiya guys, just trying to find the best way of translating natural
language queries to sql queries to put in a website, i will be glad if
you can help or point me towards the right direction
Thanks for your help
Jonathan
--
Jonathan Trepczyk
--
PHP Database Mailing List (http://www.php.net/)
I am still new to the PHP scene could you tell me how I rebuild the
PHP with the client library...
On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message
that wont work :(
and either when changing RIGHT to LEFT JOIN that wont work
On Mon, 7 Feb 2005 13:41:01 -0500, Joseph Crawford [EMAIL PROTECTED] wrote:
try doing this
SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON
(a.UserName != b.username)
On Mon, 7 Feb 2005 19:22:15
:( nothing
On Mon, 7 Feb 2005 14:10:10 -0500, Joseph Crawford [EMAIL PROTECTED] wrote:
try INNER JOIN?
On Mon, 7 Feb 2005 19:47:29 +0100, Zouari Fourat [EMAIL PROTECTED] wrote:
that wont work :(
and either when changing RIGHT to LEFT JOIN that wont work
On Mon, 7 Feb 2005
The short answer is, download the php source and add
--with-mysql=/your/path/to/mysql
to your build options. The long answer is in the directions in the php
manual http://us4.php.net/manual/en/install.unix.php.
Michael
GH wrote:
I am still new to the PHP scene could you tell me how I rebuild
On Monday 07 February 2005 18:22, Zouari Fourat wrote:
Hello
I have 2 tables with two columns in each one (cloned tables) like this :
ID int(6)
UserName varchar(25)
and i would like to select usernames from table1 that doesnt appear in
table2 so i did this :
Depending on which database
Hello list,
I'd just like to thank everyone who jumped right in with their insights and
suggestions to my troubles. There's a lot to get me going there! Every one
of those posts was helpful.
I have downloaded XAMPP and am going to install it here in a minute. Armed
with that, and the use of
22 matches
Mail list logo