[PHP-DB] Re: Newbie Setup Trouble
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
extension=php_mysql and delete the ; in front of it, if present.
Stop and start webserver and try again.
Alternatively you should install XAMPP or similar which installs Apache,
PHP and MySQL at once. This makes life easier for beginners.
Stefan
Mike Rondeau wrote:
Hello,
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
already. I must be a REAL dummy! I have installed all 3 programs but
something is not right somewhere. Being so new to this I am having a real
time trying to figure out which program is messed up. Certain things work,
but others don't.
For instance, my book told me how to make a phpinfo.php page, which works
fine. But it also tells me to create some other pages to test if PHP and
MySQL are working or not. I followed the scripts provided exactly but keep
getting syntax errors, even though the script is just what the authors
wrote. For instance, it said to make a page and call it mysql_up.php. Here's
the script for it:
html
headtitleTest MySQL/title/head
body
!-- mysql_up.php --
?php
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo bError . mysql_errno() . :
. mysql_error() . /b;
}
else
{
?
!-- Table that displays the results --
table border=1
trtdbVariable_name/b/tdtdbValue/b
/td/tr
?php
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo TR;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result); $j++)
{
echo TD . $row_array[$j] . /td;
}
echo /tr;
}
?
/table
?php } ?
/body/html
But when I open it in my browser I get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10
Could anyone of you smart people point me in the right direction? I'd be
pulling my hair out if I had any left :)
I can't make any progress with this study until I know my 3 programs are
talking to eachother properly, but my book gives no info on this error.
Thanks a millionfold for any advice, and I appologise for the length of
this post.
Sincerely,
Mike Rondeau
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysqli connection problem
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 about how to get rid of this error? Configuration: * RedHat Enterprise Linux AS3 * Apache 2.0.46 * PHP 5.0.2 * MySQL 4.1.9, mysqli ext. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysqli connection problem
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 anyone have any ideas about how to get rid of this error? Configuration: * RedHat Enterprise Linux AS3 * Apache 2.0.46 * PHP 5.0.2 * MySQL 4.1.9, mysqli ext. Thanks! [Note: reply-to set to php-db as it's multimailed and I don't see this as a mysql general issue, nor php general, but feh.] Looks to be set blank/null/etc. You may be slightly tricked by the existence of both of these - from your standard php.ini... - ; Default socket name for local MySQL connects. If empty, uses the built-in mysql.default_socket = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysqli.default_socket = - I can't see any reason why you wouldn't be able to use the same socket - you're connecting to the same exact server, it's just a path. You should be perfectly able to set your mysqli.default_socket to the same as the mysql.default_socket. I can't tell you what the default for your system is, but there are php functions to get configuration options, if you don't have it in any obvious places. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie Setup Trouble
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. I would recommend you use
a
PHP software installation package (it basically installs everything for
you).
I think this installation kit supports windoze + Linux:-
http://www.apachefriends.org/en/xampp.html
Hope that helps,
Gareth
On 7 Feb 2005, at 14:55, [EMAIL PROTECTED] wrote:
html
headtitleTest MySQL/title/head
body
!-- mysql_up.php --
?php
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo bError . mysql_errno() . :
. mysql_error() . /b;
}
else
{
?
!-- Table that displays the results --
table border=1
trtdbVariable_name/b/tdtdbValue/b
/td/tr
?php
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo TR;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result); $j++)
{
echo TD . $row_array[$j] . /td;
}
echo /tr;
}
?
/table
?php } ?
/body/html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Newbie Setup Trouble
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);//or in a separate
line with the function
mysql_select_db(database name,$link)//where $link
is the connection info above
And then use in the line:
$result = mysql_query($link, $sql); //this enable the
query to find the connection and the code.
I hope this makes sense. I have only been doing this a couple of weeks.
Some books have the ($link,$sql) order reversed which will also give you
an error. IN ADDITION, if you are using mysqli you need to enter this
ext in the PHP.ini file. I can only connect using mysqli and not mysql.
Good luck,
jzf
This should help you.
Mike Rondeau wrote:
Hello,
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 already. I must be a REAL dummy! I have installed all 3
programs but something is not right somewhere. Being so new to this I
am having a real time trying to figure out which program is messed
up. Certain things work, but others don't.
For instance, my book told me how to make a phpinfo.php page, which
works fine. But it also tells me to create some other pages to test
if PHP and MySQL are working or not. I followed the scripts provided
exactly but keep getting syntax errors, even though the script is
just what the authors wrote. For instance, it said to make a page and
call it mysql_up.php. Here's the script for it:
html
headtitleTest MySQL/title/head
body
!-- mysql_up.php --
?php
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo bError . mysql_errno() . :
. mysql_error() . /b;
}
else
{
?
!-- Table that displays the results --
table border=1
trtdbVariable_name/b/tdtdbValue/b
/td/tr
?php
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo TR;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result); $j++)
{
echo TD . $row_array[$j] . /td;
}
echo /tr;
}
?
/table
?php } ?
/body/html
But when I open it in my browser I get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10
Could anyone of you smart people point me in the right direction? I'd
be pulling my hair out if I had any left :)
I can't make any progress with this study until I know my 3 programs
are talking to eachother properly, but my book gives no info on this
error.
Thanks a millionfold for any advice, and I appologise for the length
of this post.
Sincerely,
Mike Rondeau
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie Setup Trouble
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 Trouble
Date: Mon, 07 Feb 2005 16:17:45 +0100
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
extension=php_mysql and delete the ; in front of it, if present. Stop
and start webserver and try again.
Alternatively you should install XAMPP or similar which installs Apache,
PHP and MySQL at once. This makes life easier for beginners.
Stefan
Mike Rondeau wrote:
Hello,
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
already. I must be a REAL dummy! I have installed all 3 programs but
something is not right somewhere. Being so new to this I am having a real
time trying to figure out which program is messed up. Certain things work,
but others don't.
For instance, my book told me how to make a phpinfo.php page, which
works fine. But it also tells me to create some other pages to test if PHP
and MySQL are working or not. I followed the scripts provided exactly but
keep getting syntax errors, even though the script is just what the
authors wrote. For instance, it said to make a page and call it
mysql_up.php. Here's the script for it:
html
headtitleTest MySQL/title/head
body
!-- mysql_up.php --
?php
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo bError . mysql_errno() . :
. mysql_error() . /b;
}
else
{
?
!-- Table that displays the results --
table border=1
trtdbVariable_name/b/tdtdbValue/b
/td/tr
?php
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo TR;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result); $j++)
{
echo TD . $row_array[$j] . /td;
}
echo /tr;
}
?
/table
?php } ?
/body/html
But when I open it in my browser I get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10
Could anyone of you smart people point me in the right direction? I'd be
pulling my hair out if I had any left :)
I can't make any progress with this study until I know my 3 programs are
talking to eachother properly, but my book gives no info on this error.
Thanks a millionfold for any advice, and I appologise for the length of
this post.
Sincerely,
Mike Rondeau
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Newbie Setup Trouble
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 package.
Hope this helps
Vikas
[EMAIL PROTECTED] wrote:
php-db Digest 7 Feb 2005 14:55:25 - Issue 2811
Topics (messages 38485 through 38486):
Newbie Setup Trouble
38485 by: Mike Rondeau
mysqli connection problem
38486 by: Denis Gerasimov
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
php-db@lists.php.net
--
ATTACHMENT part 2 message/rfc822
To: php-db@lists.php.net
From: Mike Rondeau
Date: Sun, 6 Feb 2005 17:57:17 -0800
Subject: Newbie Setup Trouble
Hello,
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
already. I must be a REAL dummy! I have installed all 3 programs but
something is not right somewhere. Being so new to this I am having a real
time trying to figure out which program is messed up. Certain things work,
but others don't.
For instance, my book told me how to make a phpinfo.php page, which works
fine. But it also tells me to create some other pages to test if PHP and
MySQL are working or not. I followed the scripts provided exactly but keep
getting syntax errors, even though the script is just what the authors
wrote. For instance, it said to make a page and call it mysql_up.php. Here's
the script for it:
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo Error . mysql_errno() . :
. mysql_error() . ;
}
else
{
?
Variable_nameValue
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo ;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result); $j++)
{
echo . $row_array[$j] . ;
}
echo ;
}
?
But when I open it in my browser I get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10
Could anyone of you smart people point me in the right direction? I'd be
pulling my hair out if I had any left :)
I can't make any progress with this study until I know my 3 programs are
talking to eachother properly, but my book gives no info on this error.
Thanks a millionfold for any advice, and I appologise for the length of
this post.
Sincerely,
Mike Rondeau
ATTACHMENT part 3 message/rfc822
From: Denis Gerasimov
To:
, MySQL General List ,
PHP General List
Date: Mon, 7 Feb 2005 17:52:50 +0300
Subject: mysqli connection problem
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 about how to get rid of this error?
Configuration:
* RedHat Enterprise Linux AS3
* Apache 2.0.46
* PHP 5.0.2
* MySQL 4.1.9, mysqli ext.
Thanks!
-
ALL-NEW Yahoo! Messenger - all new features - even more fun!
Re: [PHP-DB] Re: Newbie Setup Trouble
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 = 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);//or in a separate line with the function mysql_select_db(database name,$link)//where $link is the connection info above And then use in the line: $result = mysql_query($link, $sql); //this enable the query to find the connection and the code. I hope this makes sense. I have only been doing this a couple of weeks. Some books have the ($link,$sql) order reversed which will also give you an error. IN ADDITION, if you are using mysqli you need to enter this ext in the PHP.ini file. I can only connect using mysqli and not mysql. Good luck, jzf -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with an update after an insert: MySQL
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 = mysql_num_rows($result);
$row = mysql_fetch_row($result);
$gotToken = $row[0];
$generatedToken = date(YmdHis);
$result = mysql_query(insert into tokenuserid values ('$generatedToken',
'$none'));
$result = mysql_query(update tokenUserid set userid = '$userid' where
token = '$gotToken');
if (!$result)
echo can't find user;
I can't get this update to take. Actually, I can get this to work on one
implementation of this database and on the next implementation of this it
doesn't work. returning the error after the update. The MySQL version is
3.23.52.
Is it because I have a capital U in the name tokenUserid in the update
statement? I could believe this as a reason since the table is defined as:
tokenuserid - (without any caps). If this is the problem then why does it occur
in one
implementation and not the other?
[PHP-DB] Re: Newbie Setup Trouble
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
already. I must be a REAL dummy!
That is where your wrong in my opinion, only dummies
would understand that book, smart people would NOT
understand it. So your the smart one. :)
I have installed all 3 programs but
something is not right somewhere.
Your not a dummy if you know there is something wrong,
somewhere. ;) (seriously)
Being so new to this I am having a
real
time trying to figure out which program is messed up.
We all learn and start somewhere. ;)
Certain things
work,
but others don't.
Reminds me of Windows! ;)
For instance, my book told me how to make a
phpinfo.php page, which
works
fine.
Your phpinfo() is working. YAY!
But it also tells me to create some other pages to
test if PHP
and
MySQL are working or not. I followed the scripts
provided exactly but
keep
getting syntax errors, even though the script is just
what the authors
wrote.
Yes depends on PHP version, mysql version to start
with, some are different and also can depend on linux
type/version if things work or not exactly as they are
written.
For instance, it said to make a page and call it
mysql_up.php.
Here's
the script for it:
Lets see!
html
headtitleTest MySQL/title/head
body
!-- mysql_up.php --
?php
$host=localhost;
$user=blablablabla;
$password=blablabla;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo bError . mysql_errno() . :
. mysql_error() . /b;
}
else
{
?
!-- Table that displays the results --
table border=1
trtdbVariable_name/b/tdtdbValue/b
/td/tr
?php
for ($i = 0; $i mysql_num_rows($result); $i++) {
echo TR;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j mysql_num_fields($result);
$j++)
{
echo TD . $row_array[$j] . /td;
}
echo /tr;
}
?
/table
?php } ?
/body/html
But when I open it in my browser I get this error:
Fatal error: Call to undefined function
mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line
10
Could anyone of you smart people point me in the right
direction? I'd
be
pulling my hair out if I had any left :)
First off is the database name and password created as
the code says? You need to create the connection to
the database as a username before php can use it.
I can't make any progress with this study until I
know my 3 programs
are
talking to eachother properly, but my book gives no
info on this error.
Thanks a millionfold for any advice, and I appologise
for the length
of
this post.
Sincerely,
Mike Rondeau
That's a starting point..
http://mysql.net
Search : Creating a User Account
...Reveals how to...
Than Search : Connection String or Creating a
Connection String
...Reveals how to...
Experiment with the site and or http://mysql.com and
http://php.net with the search terms above. If it
relates to database be on mysql site and if it relates
to using php to use mysql look on php site.
Learn to use the site with the search, instead of us
posting URL's here for you as shortcuts and you not
learning how to use the site I suggest you try the
site and if problems occour mail us. :)
I hope this helps somewhat and points you into the
right direction.
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Error 1251 / phpMyAdmin
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 //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Problem with an update after an insert: MySQL
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: [PHP-DB] Problem with an update after an insert: MySQL
Date: Mon, 7 Feb 2005 11:31:52 EST
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 = mysql_num_rows($result);
$row = mysql_fetch_row($result);
$gotToken = $row[0];
$generatedToken = date(YmdHis);
$result = mysql_query(insert into tokenuserid values ('$generatedToken',
'$none'));
$result = mysql_query(update tokenUserid set userid = '$userid' where
token = '$gotToken');
if (!$result)
echo can't find user;
I can't get this update to take. Actually, I can get this to work on one
implementation of this database and on the next implementation of this it
doesn't work. returning the error after the update. The MySQL version is
3.23.52.
Is it because I have a capital U in the name tokenUserid in the update
statement? I could believe this as a reason since the table is defined as:
tokenuserid - (without any caps). If this is the problem then why does it
occur in one
implementation and not the other?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin
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 mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: 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 //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with an update after an insert: MySQL
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, _http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html_ (http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html)
[PHP-DB] JOIN problem
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 that wont work, as i saw from sql joint docs, using OUTER JOIN significate that we want to join the 2 tables where the inverse of (a.UserName=b.username) is, so it's equivalent of (a.UserNameb.username) and the LEFT option is about to show the lines from the left side table wich is a (table1) in my query why didnt that work fine ? how to resolve it and is my view on sql joins is incorect ? thanks all -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] NLP to SQL queries
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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin
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 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 mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: 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 //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] JOIN problem
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 +0100, Zouari Fourat [EMAIL PROTECTED] 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 : SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON (a.UserName = b.username) and that wont work, as i saw from sql joint docs, using OUTER JOIN significate that we want to join the 2 tables where the inverse of (a.UserName=b.username) is, so it's equivalent of (a.UserNameb.username) and the LEFT option is about to show the lines from the left side table wich is a (table1) in my query why didnt that work fine ? how to resolve it and is my view on sql joins is incorect ? thanks all -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] JOIN problem
:( 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 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 +0100, Zouari Fourat [EMAIL PROTECTED] 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 : SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON (a.UserName = b.username) and that wont work, as i saw from sql joint docs, using OUTER JOIN significate that we want to join the 2 tables where the inverse of (a.UserName=b.username) is, so it's equivalent of (a.UserNameb.username) and the LEFT option is about to show the lines from the left side table wich is a (table1) in my query why didnt that work fine ? how to resolve it and is my view on sql joins is incorect ? thanks all -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin
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 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 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 mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: 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 //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] JOIN problem
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 you're using you may be able to do this: SELECT a.username FROM table1 a WHERE a.username NOT IN ( SELECT b.username FROM table2 b ) cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie Setup Trouble
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 search as Jerry suggested, I bet all will go much more smoothely now, hehe. Just wanted to affirm to you all that your assistance was appreciated :) ~Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
