During a recent system software upgrade (CentOS) on the front-end of our
computing cluster, the mysql area was upgraded without our realizing that it
was going to be. Now, php and mysql do not communicate well with one another.
The version of mysql on the system after the upgrade is 5.1.61
This question is strictly related to the mysql query not the php code.
I need to either create a new table from the old one or add columns.
The thing is don't know how to do it.
let me simplify things up:
I need a query to retrieve values from the table
PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS to a
you can do some thing like this.
create table new_table(id int, hair varchar(50),eyes varchar(50)) select
column1,column2,...from old_table;
On 7/3/08, axis [EMAIL PROTECTED] wrote:
This question is strictly related to the mysql query not the php code.
I need to either create a new table
Hi,
I want to create a new column or table from queries of the values of
columns I( already have.
My table is :
PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS
products_id products_extra_fields_id products_extra_fields_value
1
1
My apologies.. I scanned back looking for the reference but couldn't
find it... I thought it worth reiterating what turned out to be your
point because there seems to be so much confusion around this issue.
- michael
On 8/9/07, Brent Baisley [EMAIL PROTECTED] wrote:
Actually, I said to
Hi
I added the following statement at the end of the my.cnf file:
sql-mode=STRICT_ALL_TABLES,ALLOW_INVALID_DATES
but I still got the values 0 and 0.00 where no values were entered.
I did restart the the mysql daemon of course.
What am I still doing wrong?
Thanks.
On 8/8/07, Christian High
I did remove that column from the insert statement and no text appeared at
all in that field under that column. Not even the word NULL.
On 8/8/07, Christian High [EMAIL PROTECTED] wrote:
On 8/8/07, Brent Baisley [EMAIL PROTECTED] wrote:
One thing to check is to make sure you are not quoting
IF it is a null in that column, you should not see the word 'null'..
and the advise to put quotes around it I read earlier in this thread
is completely misguided.. If you insert the string 'null' or 'NULL'
into the database, you have just strored a string..
Perhaps it is the form of your
Hello
I have a table which contain a few numerical values.
I set the default values to be NULL.
When I insert values using phpMyAdmin, it sets the values to NULL correctly.
But when I insert using a PHP script that I wrote it sets the values
to 0.00or 0.
In my script I do test if the values are
That is MySQL, not PHP doing that to you. You need to set your
SQL_MODE to strict to get that kind of behavior.. there are other
implications to this mode so you should review:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- michael
On 8/8/07, Mahmoud Badreddine [EMAIL
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I have a table which contain a few numerical values.
I
On 8/8/07, Brent Baisley [EMAIL PROTECTED] wrote:
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I
I am getting this error and I do not know why?
Could not connect: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
I can access mysql from the command line and I can access it from
mysql Administrator. When I run a php program I get an error.
I
Nestor [EMAIL PROTECTED] wrote on 03/10/2006 02:33:50 PM:
I am getting this error and I do not know why?
Could not connect: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
I can access mysql from the command line and I can access it from
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dear MySQL users,
MySQL AB announces an updated release of the MySQL Connector/PHP for
MySQL and PHP, the Windows downloads for connecting MySQL to PHP, as
MySQL AB has released MySQL 4.1.18 [1].
The MySQL Connector/PHP consists of the mysql/mysqli
MySQL versions = 4.1 use a new, more secure authentication protocol. Probably
the version of PHP you are using does not support it.
Ah, here it is:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
HTH,
James Harvard
At 1:18 pm -0600 29/1/06, Philip R. Thompson wrote:
I just
Thanks to everyone's help. Instead of downgrading MySQL, I went ahead
and upgraded to PHP5. After I did that, it seemed to fix the
connection issue I was having.
~Philip
On Jan 30, 2006, at 4:41 AM, James Harvard wrote:
MySQL versions = 4.1 use a new, more secure authentication
]
Sent: Monday, January 30, 2006 9:33 AM
To: mysql@lists.mysql.com
Subject: Re: Support between MySQL and PHP
Thanks to everyone's help. Instead of downgrading MySQL, I
went ahead and upgraded to PHP5. After I did that, it seemed
to fix the connection issue I was having.
~Philip
On Jan
Hi all.
I figured this question was suitable for both the MySQL list and the
PHP-General list. Here's what I'm running into.
I just installed MySQL5 and currently have PHP 4.3.11 installed. I
am wanting to connect to the mysql database on localhost, but I
get the following results:
you get returned.
HTH
Keith
In theory, theory and practice are the same;
In practice they are not.
On Sun, 29 Jan 2006, Philip R. Thompson wrote:
To: mysql@lists.mysql.com, php-general@lists.php.net
From: Philip R. Thompson [EMAIL PROTECTED]
Subject: Support between MySQL and PHP
Hi all
[mailto:[EMAIL PROTECTED]
Sent: Sun 1/8/2006 8:42 PM
To: Andrew Burrows; MYSQL General List
Subject: Re: General Questions regarding mysql and php
Andrew,
I used to be a big redhat fan - but if you are looking to totally bring
everything up to date, I would suggested opensuse.
having used redhat
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few question to get me going after many years.
Was wondering what the best GUI based administration tool is used today, I
lasted used phpMyAdmin, is this still used or are there better
Andrew Burrows wrote:
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few question to get me going after many years.
Was wondering what the best GUI based administration tool is used today, I
lasted used phpMyAdmin, is this still used
- Original Message -
From: Andrew Burrows [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
Sent: Sunday, January 08, 2006 8:01 PM
Subject: General Questions regarding mysql and php
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
im DeBoer [EMAIL PROTECTED] wrote:
Hi everyone,
I've recently tried installing webcalander http://www.k5n.us/webcalendar.php on
my FBSD box.
I'm using version 5.1.1 of PHP, version 5.0.17 of MySQL, and
Hi everyone,
I've recently tried installing webcalander http://www.k5n.us/webcalendar.php on
my FBSD box.
I'm using version 5.1.1 of PHP, version 5.0.17 of MySQL, and version
1.0.2of Webcalander.
I've posted for help on the webcal list and the few respondents seemed to
think it might be a mysql
posted 10.2 Jaguar info, one version prior to 10.3
Panther which was itself released over a 18 months ago.
Thanks anyway. :)
Gil
On May 29, 2005, at 5:34 AM, [EMAIL PROTECTED] wrote:
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
re-send :
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
You haven't given us much
the relevant lines of code (hide the password, of course).
You say mysql, php, and apache are working separately. I take it that
php scripts are running via web access (apache)? I ask because some
previous Mac OS upgrades replaced the apache config with a newer one
with php turned off
. All I
did was restart Mysql. Php was already turned on in httpd this time
around, iirc. Test php info script work as well.
But when I try to connect to mysql with this script I can't connect:
?php
$server = localhost:/var/mysql/mysql.sock;
$user=mysuperuser;
$password=mypassword;
$db
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html
search them both for '2002' (multiple instances on one of the pages).
there a couple suggestions for things to try.
hth.
- philip
--
MySQL
one of the posts at the bottom of one of those pages mentions that the
permissions on the sock file might not be right.
mine is:
srwxrwxrwx 1 mysqlwheel0 29 May 06:41 mysql.sock
you probably already know all this, but just in case... to get those
permissions set up:
stop
I don't see anything I haven't tried there, i.e., defining the sock
in the connection.
Thanks.
On May 29, 2005, at 1:33 PM, Philip George wrote:
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
Ok, thanks all.
I believe I need a fresh installation.
What I do get is why running 'mysqladmin -variables' reports the
location of mysql.sock and there seems to be no mysql.sock anywhere
on this machine! Not in /tmp not /var/mysql (where it says it is).
Gil
On May 29, 2005, at 1:59 PM,
On May 29, 2005, at 11:13 AM, [EMAIL PROTECTED] wrote:
?php
$server = localhost:/var/mysql/mysql.sock;
$user=mysuperuser;
$password=mypassword;
$db = mysql;
mysql_connect($server, $user, $password);
mysql_select_db($db);
echo mysql_error();
phpinfo();
?
I get these:
Warning: mysql_connect():
mysqld won't start if it can't create the socket, so if mysqld is
running, you've got a socket somewhere. Once you find out where, you
can fix your connection problem by setting the appropriate path in your
php script.
I don't think you need a fresh install.
Michael
[EMAIL PROTECTED]
Philip George wrote:
one of the posts at the bottom of one of those pages mentions that the
permissions on the sock file might not be right.
mine is:
srwxrwxrwx 1 mysqlwheel0 29 May 06:41 mysql.sock
you probably already know all this, but just in case... to get those
permissions
re-submitted
re-send :
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED
mysql.sock is created by mysqld when it starts, and destroyed when it
stops.
haha. you're absolutely right. that doesn't make any sense. i wasn't
thinking about the nature of socket files when i wrote that.
now that i go back and read the post i was referring to, i think the
poster was
support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac
+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
You haven't given us much to go on, other than it doesn't
work, which
isn't
Remember guys, I went through this on the phpmyadmin list before
turning here.
I was told to run the command 'mysqladmin variables' to find out
where the the socket was; I did that successfully and it showed up
at /var/mysql/mysql.sock.
And viola, now with mysqld running, it does show up
Hi,
here is a workaround that might help you.
I guess you have a Network card. So instead of using 'localhost' as host
use your ip e.g '192.168.0.1;. That will force MySQl use TCP/IP instead
of socket.
Just have in mind that:
1. In /etc/my.cnf You should comment skip-networking if presenet
Gil,
THREE elements need to be match what is stored inside MYSQL DB.
1) username
2) password
3) hostname
You need to enable MYSQL logging, restart the DB, try to login from PHP.
Then, take a look at what MYSQL shows in its logfile post the results here!
YMMV
On 5/29/05, Peter [EMAIL
Ok, afraid I'm having to ask: how do access the mysql log file? Or,
how to enable logging... I gather this will cause a verbose mode from
the CLI?
Not sure what I should be doing here.
Thanks in advance.
As for the 3 elements listed below --wouldn't those be present in the
mysql db
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
You haven't given us much to go on, other
On May 29, 2005, at 5:34 AM, [EMAIL PROTECTED] wrote:
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL
, I should point out that while it is true that Mac OS X Server
10.4 ships with mysql and php, for some reason they've been shipped with
incompatible defaults, as you are seeing. Have you read what Apple has
to say on the matter
http://docs.info.apple.com/article.html?artnum=301457? If you
I'm on Mac OSX and Mysql is built-in, so is php.
My php has built-in support for mysql.
Both php and mysql are up and running. I have tested both. All this
is running on this machine, so is Apache.
I can log into mysql at the CLI with my superuser and access the
'mysql' db -the only one
be the the OS user that needs to be granted access to
MYSQL.
I'm willing to bet that the failure to connect into MYSQL via PHP from
Apache is due
to a permissions/login/authorization issue.
You also wrote:
If you enable LOGGING bounce the MYSQL DB, some clue about what is
or is not
happening
Hi,
Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not getting the desired output.
I had uncommented the php.ini file the entry named
Are you getting a MySQL error?
On 5/17/05, madderla sreedhar [EMAIL PROTECTED] wrote:
Hi,
Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not
indicates
that the mysql extension is not activated in PHP (in PHP 5.0 there is no
mysql included as default for various reasons).
You can find more on how to get this working at:
http://nl3.php.net/manual/en/faq.migration5.php#faq.migration5.mysql
Especially item 2. seems to be appropriate (about
Hi,
Iam using mysql 5.04 , php 5.0 with IIS 5.0
webserver and written some scripts and executed
on IE webbrowser but getting an fatal error
undefined function mysql_connect() in the code
kindly tell me where iam going wrong and also tell
the mysql username how to find it out becoz when
Iam
It seems like you got the same problem' as me :
Php (? ) do not have the librairies include, and you need to run a kink of
daemon in order to make t works.
Under linux, it is just a question of the good rpm to install (for me it was
php-mysql-4.3.9-3.i386.rpm).
Under windows, you'll need
The folks at http://us4.php.net/mailing-lists.php can help you.
In PHP 5, MySQL is no longer enabled by default, nor is the MySQL
library bundled with PHP.
http://us4.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
kgt
CIKALA Frédéric ROSI/SIPROD wrote:
It seems like you got
On Windows... Which do i install first? PHP or MySQL?
Thanks
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
On Windows... Which do i install first? PHP or MySQL?
[/snip]
It should not matter as you will have to tell PHP to load the proper
libraries. Install both (in any order) then configure PHP, then start
MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Wed, 29 Dec 2004 10:42:45 -0500
GH [EMAIL PROTECTED] wrote:
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
It doesn't really matter but I'd suggest MySQL first as I think there
is one file you need to copy from the MySQL installation to the
C:\Windows (or whatever
I am using IIS :(
On Wed, 29 Dec 2004 10:03:11 -0600, Josh Trutwin
[EMAIL PROTECTED] wrote:
On Wed, 29 Dec 2004 10:42:45 -0500
GH [EMAIL PROTECTED] wrote:
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
It doesn't really matter but I'd suggest MySQL first as I
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev box, it may not be that big of a deal.
PHP using IIS is a bit easier to install than Apache since PHP5 does not
have an installer that auto-configs Apache
use Apache/PHP. It's up to you which you pick.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Don Stefani [EMAIL PROTECTED] wrote on 12/29/2004 11:53:36 AM:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache
Hi!
Am Mit, 2004-12-29 um 18.09 schrieb [EMAIL PROTECTED]:
[[...]]
Of course, the WAMP alternative is always there, Apache is FREE and comes
with PHP. I have both IIS and Apache set up on my Win2K laptop (I usually
only run them one at a time to conserve resources), So instead of IIS/ASP,
On Wed, 29 Dec 2004 12:09:51 -0500
[EMAIL PROTECTED] wrote:
snip
Of course, the WAMP alternative is always there, Apache is FREE and
comes with PHP.
snip
FWIW, the download of apache from the Apache website
(http://httpd.apache.org/) does NOT include PhP, you still have to
download and
If you follow the instructions properly, you can get the ISAPI version
of PHP to run and it it runs pretty well once installed.
Curtis
Don Stefani wrote:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev
Hi all,
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some
You didn't say which Linux you were using and I am not sure about the rest,
but if you are using RedHat, you probably need to install php-mysql which
is A module for PHP applications that use MySQL databases. If you can
use up2date, you can type in up2date php-mysql and that will let you run
[snip]
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some
Jay Blanchard wrote:
snip
This is probably a better question for a PHP list.
Do you know of one? ;)
If you're running a rpm based distro (RedHat, Fedora, etc.), and you
have php installed by rpm, you should just need to install the php-mysql
rpm, and restart Apache.
--
John C. Nichel
ÜberGeek
nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast
On Thu, 16 Sep 2004 09:27:08 -0400, John Nichel [EMAIL PROTECTED]
said:
nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast time
was over a year
OS is W2K.
-Original Message-
From: nestor(earth) [EMAIL PROTECTED]
Sent: Sep 15, 2004 8:04 AM
To:
Cc: [EMAIL PROTECTED]
Subject: Mysql and PHP
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest
On Wed, 15 Sep 2004, nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote:
Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast time
was over
You will likely want to read this:
http://us4.php.net/mysql
In PHP 5, MySQL is no longer enabled by default, nor is the MySQL library
bundled with PHP. Read this FAQ for details on why. Because of this,
Windows users will need to enable php_mysql.dll inside of php.ini and either
copy
On Wed, 15 Sep 2004, Greg Donald wrote:
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote:
Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
Apologies - I should have said just php
You have to rebuild PHP against the new MySQL libraries.
Curtis
Greg Donald said:
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest
16:22
To: Greg Donald
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004, Greg Donald wrote:
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED]
wrote:
Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL
PROTECTED]
Sent: 15 September 2004 16:22
To: Greg Donald
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004, Greg Donald wrote:
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED]
wrote:
Did you build both php and apache with MySQL support?
I wasn't
]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does
PROTECTED]
Sent: Wednesday, September 15, 2004 11:10 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: Eve Atley
Sent: Tuesday, February 24, 2004 2:15 AM
Subject: Re: MySql and php
thanx alot for ur reply , i think better to send my
script to u .In third collom , there is two different status . I want
Subject: Re: MySql and php
thanx alot for ur reply , i think better to send my script to u .In third
collom , there is two different status . I want to highlight those with two
different colors.There is to be satisfied some simple condition , plz help
thanx
curlys
?php
/* Connecting, selecting
hi ,
i have a problem with Mysql Vs php . Can somebody
help me to sort out this problem ?
I wrote a php script to connet mysql data base and
get some data from some table of the database. It works well ..
1 data1
data2
5 ccc
xcx
3 aaa
123
2 klkl
opop
4 opop
pop
I want do the sort
There are some excellent tutorials for PHP at www.codewalkers.com under the
tutorials/basics section. You can sort the fields with SQL or with PHP (see
Sorting Database Results with PHP) and in the Display section of the
tutorials are Alternating row colors with PHP and MySQL and Multicolumn
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql 3.23.36, both
installed on linux RH 7.3.
Thanks
Mic.
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql
3.23.36, both installed on linux RH 7.3.
Install the php-mysql RPM.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hullos,
Am Montag, 16. Februar 2004 12:08 schrieb michele digioia:
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4,
mysql 3.23.36, both installed on linux RH 7.3.
If u compiled php urself u may wanna do it again with:
--with-mysql=/PATH to mysql
If its a finished packet
php-mysql RPM is already installed. In any case, I downloaded last php
version. Now configuration requires both mysql and apache path to specify
in --with-mysql and --with-apache options. But what are these paths? Mysql
and Apache files are everywhere.
Thanks a lot.
Mic.
- Original Message
, too, as I have been having to use thttpd for
serving images recently.
I'm not sure how horked up RHES3 is, but, std. RH7-9, Mandrake 7.2-9.2,
Debian 3+ (among others) seem to have no problem what so ever
connecting php-mysql out of the box, provided you have a user account
on mysql to connect
[EMAIL PROTECTED],Eric W.Holzapfel [EMAIL PROTECTED]
Subject: Re: Connect to MySQL via PHP
Date: Thu, 12 Feb 2004 13:05:00 -0500
Apache2 and php is a buggy combination? Not that I have seen.
Or are you referring to trying to use the Apache Worker (mutlithreaded) MPM
with php... I believe
about that with apache2, you can just add it to the httpd.conf.
Donny
-Original Message-
From: Mike Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 12:19 PM
To: [EMAIL PROTECTED]
Subject: Re: Connect to MySQL via PHP
The _only_ real benefit of Apache2 over Apache1
Hello MySQL email listers,
Success at last. The tips i received from the MySQL list, got me on track.
Finally got the PHP and MySQL set up correctly, thanks to the help from
this
list.
Thanks Again,
Eric
[EMAIL PROTECTED] wrote:
On 11-Feb-2004 Eric W. Holzapfel wrote:
Hello Listers,
I
Did you install PHP-mysql*.rpm?
Curtis
On Tue, 10 Feb 2004, Eric W. Holzapfel wrote:
Hello Listers,
I have a problem with my PHP/redhat setup, and possible problem with my
Mysql setup.
I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system.
I have MySql installed
.
Also my php will not connect to the database using a php script like:
mysql://user:[EMAIL PROTECTED] phpdemo where user is the username,
passwrd is the password, etc. I can log on locally to the Slackware
box, and connect to the db using the user and password, etc. And I can
also use ODBC from
You need to install the client side of mysql on the linux box (libmysql.*)
then compile php with the mysql modules (I think they exist in RPMs)
P
-Eric W. Holzapfel [EMAIL PROTECTED] wrote: -
To: [EMAIL PROTECTED]
From: Eric W. Holzapfel [EMAIL PROTECTED]
Date: 02/10/2004 02:55PM
Yes, you can download the package or install from RH CD:
php-mysql
http://rpmfind.net/linux/rpm2html/search.php?query=php_mysqlsubmit=Search+...system=arch=
This is required so PHP will have support for mysql functions. You
apache should be ok without changes.
Sincerely,
Szymon
Hello Listers,
I have a problem with my PHP/redhat setup, and possible problem with my
Mysql setup.
I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system.
I have MySql installed on a Slackware linux box.
I want to be able to use Apache/PHP to connect to the mysql database on
1 - 100 of 235 matches
Mail list logo