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. T
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 tab
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 ne
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
; = OLD_PASSWORD('mypass');
> -Original Message-
> From: Philip Thompson [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 30, 2006 9:33 AM
> To: mysql@lists.mysql.com
> Subject: Re: Support between MySQL and PHP
>
> Thanks to everyone's
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
protocol
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 instal
alues 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 b
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:
--
e Law [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 r
ata.
--
George Law
- Original Message -
From: "Andrew Burrows" <[EMAIL PROTECTED]>
To: "MYSQL General List"
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 oth
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 or are there b
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 applicatio
.
> > >>>
> > >>> 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.
> > >>>
> &g
enable LOGGING & bounce the MYSQL DB, some clue about what
> >>> is or
> >>> is not
> >>> happening to MYSQL will be written to the logfile.
> >>>
> >>> Discern what the clues are reporting and fix the problem.
> >>>
> >&
me is the name of your machine). I don't think
the mysql log will help though, as the error appears to be on the php side.
Gil
Meanwhile, 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
incompat
pgrade install of Mac OSX 10.4 Server over 10.3 Server
(I'm not a wiz) but have used it long enough. I have changed
nothing
and it worked fine before.
Any suggestions? Again, I did not build this it's all built-in
and
working fine. I simply can't connect with php. Separatel
;> 'mysql' db -the only one I currently have.
> >>>
> >>> I have a good php test connect script but cannot connect to mysql.
> >>> I have checked the mysql variables and entered the socket location
> >>> into the script, no help.
> >>&
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 alread
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 PROTEC
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 presene
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
ot a wiz) but have used it long enough. I have changed
nothing
and it worked fine before.
Any suggestions? Again, I did not build this it's all built-
in and
working fine. I simply can't connect with php. Separately,
mysql
and php both work.
Thanks,
Gil
--
MySQL General Mailin
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 ac
>>
> > > >>> 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
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 se
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] wrote:
On May 29, 2005, at 11:13 AM, [EMAIL PROTECTED] wrote:
I get these:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock' (13) in
/Library/WebServer/testpad/test.php on line 3
Warning: mysql_select_db(): Can't connect to local MySQL server
th
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,
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
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.h
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:
chown
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 Gen
ossibly be wrong? Is there something in a mysql
config file or something that is off?
This is an upgrade install of Mac OSX 10.4 Server over 10.3 Server
(I'm not a wiz) but have used it long enough. I have changed
nothing
and it worked fine before.
Any suggestions? Again, I did not build this it's all built-in and
working fine. I simply can't connect with php. Separately, mysql
and php both work.
Thanks,
Gil
27;m not a wiz) but have used it long enough. I have changed nothing
and it worked fine before.
Any suggestions? Again, I did not build this it's all built-in and
working fine. I simply can't connect with php. Separately, mysql
and php both work.
Thanks,
Gil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is an upgrade install of Mac OSX 10.4 Server over 10.3 Server
(I'm not a wiz) but have used it long enough. I have changed nothing
and it worked fine before.
Any suggestions? Again, I did not build this it's all built-in and
working fine. I simply can't connect with php. Separately, m
t with php. Separately, mysql
and php both work.
Thanks,
Gil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 bo
On Wed, 29 Dec 2004 12:09:51 -0500
[EMAIL PROTECTED] wrote:
> Of course, the WAMP alternative is always there, Apache is FREE and
> comes with PHP.
FWIW, the download of apache from the Apache website
(http://httpd.apache.org/) does NOT include PhP, you still have to
download and install ph
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/AS
I thought you were building a local application, not a web-based app??
I believe you can still use PHP through WSH (instead of IIS) but you will
need to do some research, though. I know that Perl is supported by both
WSH and IIS (I have seen it working before) so I think that PHP and Python
and
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,
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 fir
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 syste
[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
To un
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]
Jay Blanchard wrote:
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
KegWor
[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 extension
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
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 extensio
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
>
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 t
MAIL 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
CTED]
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
&g
From: andy thomas [mailto:[EMAIL 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]>
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 y
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 l
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
2004 11:03 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
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
> 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
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
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
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 instal
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 M
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
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 to highlight those with two
different colors.There is to be satisfied some simple co
- 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 to
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 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 o
olzapfel" <[EMAIL PROTECTED]>
Date: 02/10/2004 02:55PM
Subject: MySQL and PHP
Hello Mysql listers,
I have a mysql db running on a Slackware Linux box. I have an Apache
webserver running on a Red Hat Enterprise box. (Mysql 4.0.15a, apached
2.0, php 4.3.2). I think (!!?) I have php o
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
Subject: MySQL and PHP
Hello Mysql listers,
I have a mysql db run
OTECTED]>
Date: 02/10/2004 02:55PM
Subject: MySQL and PHP
Hello Mysql listers,
I have a mysql db running on a Slackware Linux box. I have an Apache
webserver running on a Red Hat Enterprise box. (Mysql 4.0.15a, apached
2.0, php 4.3.2). I think (!!?) I have php on the Red hat box, version
4.
Hello Mysql listers,
I have a mysql db running on a Slackware Linux box. I have an Apache
webserver running on a Red Hat Enterprise box. (Mysql 4.0.15a, apached
2.0, php 4.3.2). I think (!!?) I have php on the Red hat box, version
4.3.2.
I have been trying without success to use php on apa
riginal Message -
From: "Casper Matthee" <[EMAIL PROTECTED]>
To: "<" <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 9:33 PM
Subject: MySQL and Php
> Hi all
>
> I am new to the programming world so please forgive!!!
>
> Would like to
->Sent: Thursday, October 09, 2003 12:34 PM
-->To: <
-->Subject: MySQL and Php
-->
-->Hi all
-->
-->I am new to the programming world so please forgive!!!
-->
-->Would like to get to get my hands on any info (Tutorials and such) to
-->help me on me way whith SQL
Hi all
I am new to the programming world so please forgive!!!
Would like to get to get my hands on any info (Tutorials and such) to
help me on me way whith SQL and Php
Would appreciate any help... links / text / whatever...
Thanx
Casper
South Africa
Casper Matthee
Consultant
IT3 Educ
.
Please let me know how to install Mysql and PHP machine. Please advice the
necessary steps for the installation.
With Warm Regards
Harpreet Singh Chana
Phone : @ 4326
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have an intranet, a database mysql (i admin with phpmyadmin)
I use a program java in order to put data in mysql and i want to know
if it is possible to put prog java in php page on my intranet ?
I want to start my program on the web ?
please help!
excuse me for my english
antoine
--
MySQL Ge
Message-
> From: Loren McDonald [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 01, 2003 5:16 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: What are the best MySQL and PHP resource books?
>
> HI
>
> Before I just go out and buy, I wanted to get some opi
MySQL and PHP resource books?
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it
On Sun, Feb 02, 2003 at 01:21:53PM +0100, Davy Obdam wrote:
> Hi Loren,
>
> I recomend to take a look at these books:
>
> -MySQL , Paul DuBois
Make sure to get the second edition of the MySQL book - it just came
out, so some stores may have the first edition still
--
Zak Greant <[EMAIL PR
Hi, Loren -
I'd first go with any book from O'Reilly (http://www.ora.com)
After that, I've found Welling and Thomson's PHP and MySQL Web Development
pretty good. http://www.sams.com
A couple of my students liked: Meloni's Teach Yourself PHP, MySQL and Apache
in 24 Hours, also at Sams (part of
cus on IIS, rather they assume Apache, but beyond the initial setup and
configuration I don't think it matters.
-Lisi
At 05:16 PM 2/1/03 -0500, Loren McDonald wrote:
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource b
best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it. In other words, I am NOT
looking for basic step by step books, but ones that have good, working
examples, are formatted so to make
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it. In other words, I am NOT
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it. In other words, I am NOT
"MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 18, 2002 1:32 AM
Subject: Re: MySQL and PHP question
> On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote:
> >while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
> >$num1 = $line['number
On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote:
>while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
>$num1 = $line['number'];
>}
Loop through the result and return the value from the last row?
Did you want "select sum(number) as SubTotal1 from table1 where
userid=$user1
ge -
From: "Steve Yates" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 5:12 PM
Subject: Re: MySQL and PHP question
> On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
>
> >I can not use two mysql queries
List
| Subject: MySQL and PHP question
|
|
| Hi,
|
| Why is it that I can not use two mysql queries in the same PHP
| file. I have
| tried to do this several times trying to put my site together and have had
| nothing but problems.
|
| The recent one is this:
|
| I use a SELECT statement to get some
On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
>I can not use two mysql queries in the same PHP file
Please post code snippets, this is possible.
- Steve Yates
- Burger Borg: We do it our way; yours is irrelevant.
~ Taglines by Taglinator - www.srtware.com ~
--
> Why is it that I can not use two mysql queries in the same PHP file.
You can, I assure you.
> Any info is appreciated.
Perhaps if you could provide your code? W/o it there is no way we can
determine where the problem might be coming from.
Chris
Hi,
Why is it that I can not use two mysql queries in the same PHP file. I have
tried to do this several times trying to put my site together and have had
nothing but problems.
The recent one is this:
I use a SELECT statement to get some info from a table, then I modify that
info and use an UPDA
Thank you Daniel,
You remided me that I once had a page with the following instead mysql_error()
and that gave me the verbosity that I needed to get things working. Looks like my
wife changed some fields in the database without thinking how they might affect the
script. Can't believe I didn't c
Why not change your error message display so it's more informative?
Instead of
die("Error in input query");
try this:
or die ("Error in input query: " . mysql_error() . "($query)");
That way, you can see exactly what MySQL says the error was, and exactly
how the query came out. It's really
Error in input query
start of php database code *
$connection = mysql_connect("localhost", "hostbyk1_admin",
"") or
die("Invalid
server or user");
mysql_select_db("hostbyk1_order",$connection);
/ ***
Make sure you repla
this is a vague one , would be good to copy and paste the php debug message
>= Original Message From Jerry M. Howell II <[EMAIL PROTECTED]> =
>Hello all,
>
> We are leasing a dedicated server and seem to pe having problems getting
our
>php script working with mysql. The script was workin
Hello all,
We are leasing a dedicated server and seem to pe having problems getting our
php script working with mysql. The script was working fine with the last server
we were on so I'm wondering if you all have any sugestions. We are hosting on a
redhat 7.3 server with MySQL-3.23.53a-1.i386.rp
great.
Thanks.
- Original Message -
From: "Mertens Bram" <[EMAIL PROTECTED]>
To: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 9:06 AM
Subject: Re: Gah, mysql and PHP woes
> On Sat, 2002-10-19 at 07:04, Dave Best wrote:
>
On Sat, 2002-10-19 at 07:04, Dave Best wrote:
> Anyone have any good information on how to setup PHP and mysql?
[snip]
I followed the instructions from the "Create dynamic sites with PHP &
MySQL" I downloaded from http//www.ibm.com/developerWorks (you have to
register first).
If you want I can m
On Sat, 2002-10-19 at 00:04, Dave Best wrote:
> I hope this is the right mailing list so here goes..
>
> Anyone have any good information on how to setup PHP and mysql?
>
> I downloaded the latest mysql binaries and placed them in
> /usr/local/mysql
>
> php was already installed on my system
1 - 100 of 149 matches
Mail list logo
