Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnectOff Off
The machine I compiled PHP on does not have mysqli.so, and so I am
recieving the fatal call to undefined function mysql_connect()
error. Can someone tell me how to compile php from source with mysql
support
mysql_connect()
error. Can someone tell me how to compile php from source with mysql
support, but actually mysql is installed on a different server?
Can I download a precompile mysqli anywhere? The PHP version is 5.1.49
as noted earlier.
Thanks in Advance,
Nick
You've only compiled in MySQLi
()
error. Can someone tell me how to compile php from source with mysql
support, but actually mysql is installed on a different server?
install it locally.otherwise impossible.
Can I download a precompile mysqli anywhere? The PHP version is 5.1.49
as noted earlier.
Thanks in Advance
Sorry, just noticed that I had this line in the post. (should not post
before coffee).
$sql = INSERT INTO contact comments, VALUES = $test WHERE contact_id =
33;
It is supposed to be
$sql = UPDATE contact comments = '$test' WHERE contact_id = '33'
Gary gwp...@ptd.net wrote in message
Thanks all, I appreciate the follow ups and the help with the code. I'm
still relatively new with this stuff, and never had any formal training,
it's all just been learn as I go, and I have to learn fast as this project
is relatively urgent to get completed. I plan on going through all of my
Vinny Gullotta wrote:
What I want to do is find the top 10 servers where the column steps =
iisreset. The following code works great except that the page is not
displaying the servername in the 'Server Name' column of my results
(nothing appears, the column is just blank).
servername and
While it's true that '.' concatenates and ',' is a list separator, The
comma is actually more appropriate in this instance since you are just
outputting each piece. It saves the overhead of concatenation before
output.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
learn something new every day! cheers Micah :)
Micah Gersten wrote:
While it's true that '.' concatenates and ',' is a list separator, The
comma is actually more appropriate in this instance since you are just
outputting each piece. It saves the overhead of concatenation before
output.
Thank
1: SQL
in mysql queries /should/ use backticks (`) around database, table and
column names, stop's them getting confused with variables or reserved
words (like timestamp) and saves you future trouble :)
.. which is a mysql-ism - no other database supports this. As soon as
you need to use
-2.1021-4.EL3
qt-MySQL-3.1.2-17.RHEL3
php-mysql-4.3.2-43.ent
MySQL-devel-community-5.0.45-0.rhel3
Now I'm even more confused, the 5.0.45 devel package *is* there.
I would imagine (don't know) that PHP would use the mysql_config
program
to work out which mysql is installed and get the relevent
-0.9.1-6
libdbi-dbd-mysql-0.6.5-5
perl-DBD-MySQL-2.1021-4.EL3
qt-MySQL-3.1.2-17.RHEL3
php-mysql-4.3.2-43.ent
MySQL-devel-community-5.0.45-0.rhel3
Now I'm even more confused, the 5.0.45 devel package *is* there.
Yeah that looks pretty OK to me (tho' not overly knowledgeable with
Fedora/Centos
On 23. Oct 2007, at 21:07, Colin Guthrie wrote:
No, I reckon Jul 5th could be about right when was .45 released? I
had it in my head it was august but Jul doesn't seem too far before
that
so entirely possible.
Ah sorry, I was thinking about source installs. RPMs keep the
original
David Christopher Zentgraf wrote:
$ rpm -V MySQL-devel-community-5.0.45-0.rhel3
missing d /usr/share/man/man1/comp_err.1.gz
missing d /usr/share/man/man1/mysql_config.1.gz
I suppose this is, albeit not ideal, tolerable?
Yeah this is fine. Your system is probably not setup to install docs
David Zentgraf wrote:
Hi,
I'm trying to upgrade a server running CentOS 3 to an up-to-date MySQL 5
installation + PHP4. I installed the MySQL 5 package, server and client,
via RPMs and they work fine, the client tells me it's version 5.0.45. I
went on to recompile PHP 4.4.7 --with-mysql
David Christopher Zentgraf wrote:
On 23. Oct 2007, at 17:22, Colin Guthrie wrote:
Do rpm -qa --nosignature | grep -i mysql and see what old libraries you
have lying around. Specifically look for the devel libraries/packages.
Remove the 3.x versions via RPM and make sure you've installed the
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number
of characters and then the 'you have an error in your SQL syntax' error. I
am saving in as a LONGBLOB so it should not be a data type
2007. 05. 29, kedd keltezéssel 10.29-kor blueboy ezt írta:
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number
of characters and then the 'you have an error in your SQL syntax' error. I
Zoltán Németh wrote:
2007. 05. 29, kedd keltezéssel 10.29-kor blueboy ezt írta:
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number
of characters and then the 'you have an error in your
I think up2date is *not* up2date ;-)
Google for 'yum' and all its flags for usage...
-B
Jonathan Kahan wrote:
Hi all,
I am attempting to start the mysql rpm in Red hat as a first step
prior to downloading and activating the php-mysql rpm. I was
attempting to follow steps based on the link
I am attempting to start the mysql rpm in Red hat as a first
step prior to
downloading and activating the php-mysql rpm. I was
attempting to follow
steps based on the link below. the php rpm is loaded and
activated as I have
been able to execute php scripts. When I attempt to follow
:[EMAIL PROTECTED]
I think up2date is *not* up2date ;-)
Google for 'yum' and all its flags for usage...
-B
Jonathan Kahan wrote:
Hi all,
I am attempting to start the mysql rpm in Red hat as a first step prior
to downloading and activating the php-mysql rpm. I was attempting to
follow steps
Jonathan Kahan wrote:
Hi all,
I am attempting to start the mysql rpm in Red hat as a first step prior
to downloading and activating the php-mysql rpm. I was attempting to
follow steps based on the link below. the php rpm is loaded and activated
as I have been able to execute php scripts
PROTECTED] wrote in message news:
[EMAIL PROTECTED]
I think up2date is *not* up2date ;-)
Google for 'yum' and all its flags for usage...
-B
Jonathan Kahan wrote:
Hi all,
I am attempting to start the mysql rpm in Red hat as a first step
prior to downloading and activating the php-mysql rpm. I
) a
php-mysql rpm?
- Original Message -
From: Edward Vermillion [EMAIL PROTECTED]
To: Jonathan Kahan [EMAIL PROTECTED]
Cc: php Lists php-general@lists.php.net
Sent: Monday, March 12, 2007 6:27 PM
Subject: Re: [PHP] Installing php and mysql on linux
You've either got path problems
post. Does anyone know
where I can go to download (aside from the red hat site where i
would need to gather license info) a php-mysql rpm?
- Original Message - From: Edward Vermillion
[EMAIL PROTECTED]
To: Jonathan Kahan [EMAIL PROTECTED]
Cc: php Lists php-general@lists.php.net
Sent
SELECT id FROM dates WHERE FROM_UNIXTIME($date_string) = date
then
SELECT id FROM dates WHERE UNIX_TIMESTAMP(date) = $date_string
neither is working. Am I making some fundamental error here or missing
something? Any help appreciated!
I know yui've alreayd solved this, but for what
Upgrade your MySQL distribution to the latest version (5+).
Upgrade any shared MySQL libraries to the latest distribute.
Recompile MySQL with mysqli support.
http://php.net/mysqli
And use that instead of the regular MySQL functions.
That's what I did and it has made a huge
Dear All subscribers,
my intention, through this e-mail, is to submit to your attentions one PHP class
devoted to translate input native language commands for database into MYSQL
commands lines.
Download the code from:
Dear All subscribers,
my intention, through this e-mail, is to submit to your attentions one PHP class
devoted to translate input native language commands for database into MYSQL
commands lines.
The goal of this class is to provide a comfortable code interface to let
programmers
implement
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use it for
php4, i get a msg, stating that it can't find the MySQL Headers...
can anybody provide any pointers as far as what the Headers are for mysql,
and
with the mysqli
extension you have to use the same client library to avoid any
conflicts.
===
PHP4 doesn't support the mysqli extension, so you must compile PHP w/
--with-mysql=/your/mysql/prefix/dir
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a binary if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
that PHP5 has released...i dont see any good reason why u r
still using php 3.
/sagar
- Original Message -
From: M. Sokolewicz [EMAIL PROTECTED]
To: php-general@lists.php.net
Sent: Saturday, January 08, 2005 9:55 PM
Subject: [PHP] Re: PHP any Mysql connection- new b
php 3.0???!
man, you
php 3.0???!
man, you seriously need to think about upgrading :| PHP 3 is seriously
outdated
- tul
Babu wrote:
Hi all,
I am using php 3.0 and mysql and win xp.
i want to add users to database through php page.
adduser.php
html
FORM METHOD=post ACTION=add.php
Real Name: INPUT TYPE=text
Bingo. Many thanks.
Barley wrote:
If I run the script from a shell prompt as root, it outputs Yes. If I
run
as any other user, it outputs No. It also gives this error:
Warning: mysqli_connect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (13)
Check
Barley wrote:
If I run the script from a shell prompt as root, it outputs Yes. If I run
as any other user, it outputs No. It also gives this error:
Warning: mysqli_connect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (13)
Check permissions on /var/lib/mysql.
connect to MySql via a PHP script if I run
that script as root. Here is the example script I have been using:
?php
$DB = mysqli_connect(localhost,user,pass);
if (! $DB) {
echo No.;
} else {
echo Yes.;
}
?
If I run the script from a shell prompt as root, it outputs Yes. If I run
as any other user
Hello,
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
I appreciate your thoughts.
Thanks.
--
PHP General Mailing List (http
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
PHP 4 is compatible with MySQL 4.1. My caution to you would be using
.
On Nov 11, 2004, at 3:05 PM, C.F. Scheidecker Antunes wrote:
Hello,
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
I appreciate your
4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
I appreciate your thoughts.
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit
with these servers I wonder what PHP 4
version would be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
I appreciate your thoughts.
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
In my previous email OLDPASSWORD() should have been OLD_PASSWORD()
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP doesn't detect anything. You need to have your mysql server running and
you try with mysql_connect() or mysql_pconnect() to see if you can connect
to the server
Sean Vasey [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Does anyone know how to get PHP to detect MySQL after it has
Hello ,
How can I compile PHP so that it does not mater what version of
mysql is installed.
If I compile it for mysql 3.X and then upgrade mysql to ver 4
PHP will not install.
I get error while loading shared libraries: libmysqlclient.so.12: cannot open shared
object file
--- Richard Kurth [EMAIL PROTECTED] wrote:
Hello ,
How can I compile PHP so that it does not mater
what version of
mysql is installed.
If I compile it for mysql 3.X and then upgrade
mysql to ver 4
PHP will not install.
I get error while loading shared libraries
Webmaster [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello i need help with mysql_create_db i found the solution once but cant
remember what it was if someone could tell me the proper way to create a
database with php and mysql i would be greatly thankfull.
Thank you.
?php
Hello,
I want to know how to control php program connect to MySQL Database
System ( another computer machine ) ?
Thank a lots.
Ed.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
snip
I want to know how to control php program connect to MySQL Database
System ( another computer machine ) ?
/snip
http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/function.mysql-pconnect.php
--
PHP General Mailing List (http://www.php.net
Does older than php 4.2.2 support with this function ?
Matt Matijevich wrote:
snip
I want to know how to control php program connect to MySQL Database
System ( another computer machine ) ?
/snip
http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en
On Tuesday 24 February 2004 22:47, [EMAIL PROTECTED] wrote:
Does older than php 4.2.2 support with this function ?
As has already been suggested, could you try reading the manual? Please?
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web
Hello Everyone,
I'm still having problems compiling the latest version of PHP. I have
several issues
- The apache 2 that was installed was from a Red Hat package. From what I
can tell it is configured in a manner that is similar to the
with-apxs2filter. The configuration file that point to this
Hi James,
James Marcinek wrote:
Hello Everyone,
I'm still having problems compiling the latest version of PHP. I have
several issues
- The apache 2 that was installed was from a Red Hat package. From what I
can tell it is configured in a manner that is similar to the
with-apxs2filter. The
and/or times in a MySQL DB for PHP to
work later?
Thanks in advanced,
___
Cesar L. Aracena
Commercial Manager / Developer
ICAAM Web Solutions
2K GROUP
Neuquen, Argentina
Tel: +54.299.4774532
Cel: +54.299.6356688
E-mail: [EMAIL PROTECTED]
The best way is to use a datetime or timestamp
the
possible formats work with each other so my question is what is the best
(or
recommended) method to store dates and/or times in a MySQL DB for PHP to
work later?
Thanks in advanced,
___
Cesar L. Aracena
Commercial Manager / Developer
ICAAM Web Solutions
2K
Cesar Aracena wrote:
I tried what both of you told me and I found very easy to use the datetime
value under MySQL and then fetch it using strtotime() as fireball at
sizzling dot com recommended at the User Contributed Notes of php.net's
function.date.php page rather than using mktime() which can
I've been working on this for a few days and can't get it.
I would like to stick some php code into a sql databases and be able to
evaluate it when it's called up.
Foe example, let's say there's some text in a table in MySql that says
blah blah blah ? $mysql_query(SELECT * FROM X WHERE 1);
($fh);
include($file);
}
It should work.
Javier Tacón Iglesias.
-Mensaje original-
De: Michael Winston [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 18 de septiembre de 2003 17:20
Para: [EMAIL PROTECTED]
Asunto: [PHP] embedding PHP in MySQL
Importancia: Baja
I've been working
By default the evaled code is php, so you need to escape first:
eval('?'.$your_code_pulled_from_db.'?php');
Michael Winston wrote:
I've been working on this for a few days and can't get it.
I would like to stick some php code into a sql databases and be able to
evaluate it when it's called up.
As mysql is from an rpm, I bet it is in /usr, so use --with-mysql=/usr
Also make sure mysql-devel rpm is installed.
Mark McCulligh wrote:
I am trying to ./configure PHP 4.3.3 on a system that already has MySQL
4.0.14 on it.
In the configure line --with-mysql=/path/to/mysql were is the path for RPM
I am trying to ./configure PHP 4.3.3 on a system that already has MySQL
4.0.14 on it.
In the configure line --with-mysql=/path/to/mysql were is the path for RPM
versions of MySQL. I have search the computer but it looks like the mysql
files are all over the place. Database files are in
example:
./configure --with-mysql
./configure --with-mysql-sock=/var/lib/mysql/mysql.sock
hth
--
BigDog
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
or --with-mysql-sock
example:
./configure --with-mysql
./configure --with-mysql-sock=/var/lib/mysql/mysql.sock
hth
--
BigDog
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. Database files are in /var/lib/mysql
BIN
files are in /usr/bin/, etc...
use --with-mysql or --with-mysql-sock
example:
./configure --with-mysql
./configure --with-mysql-sock=/var/lib/mysql/mysql.sock
hth
--
BigDog
--
PHP General Mailing List (http://www.php.net
Ok,
when I compiled with --with-mysql only, phpinfo() said:
Client API version: 3.23.49
I will recompile PHP with --with-mysql-sock instead.
I want to make sure PHP is using the right MySQL Client version.
Thanks,
Mark.
Ray Hunter [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED
Mark McCulligh wrote:
when I compiled with --with-mysql only, phpinfo() said:
Client API version: 3.23.49
I will recompile PHP with --with-mysql-sock instead.
I don't think this will change the client version. It is my
understanding that this will just tell the client to look in a specific
place
, I'd
probably use the mysql version just for the ease of use factor.
If you really care, just make a program like this and do some MD5() calls in
both mysql and php to see which is faster. I'd be curious to know as well...
You'll have to modify appropriately, and only do a single MD5 check because
I
* Thus wrote Daevid Vincent ([EMAIL PROTECTED]):
If you really care, just make a program like this and do some MD5() calls in
both mysql and php to see which is faster. I'd be curious to know as well...
You'll have to modify appropriately, and only do a single MD5 check because
I think
Hello,
This question has been lingering in my mind for some time -
Say we have a function such as MD5, which is available on both PHP and MySQL? Which is
faster - the PHP version or the MySQL one. Have any benchmarks been made on this? We
can use the same question for say... arithmetic
Hello,
I have a class that just does that ::
http://www.devhome.org/php/scripts/authlib.html
- Original Message -
From: Matt Babineau [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 8:30 AM
Subject: [PHP] How to Authenitcate using PHP (RH9, PHP
4.3.2, MySQL 4
/article/319
Justin
On Tuesday, August 12, 2003, at 11:30 PM, Matt Babineau wrote:
I was wondering if anyone had any suggestions on how to properly
authenticate users using redhat php and mysql. Currently we are using
.htaccess files, but I was thinking it may be easier to manage this via
a php
Hi All-
I was wondering if anyone had any suggestions on how to properly
authenticate users using redhat php and mysql. Currently we are using
.htaccess files, but I was thinking it may be easier to manage this via
a php/mysql admin interface... I imagine plenty of authentication
schemes have
Here is the script for what it's worth.
...
body bgcolor=#FF text=#00
h2IS IT WORKING?/h2
plt;?php
phpinfo();
?gt; /p
/body
/html
and the result is
IS IT WORKING?
?php phpinfo(); ?
are your trying to fool the list?
whate else do you expect than when you write gt; ??
would ASP work if
Bob G [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Please help I am going quite mad.
... The PHP.INI file is in the PHP directory.
the php.ini in your PHP directory is useless
It needs to be in 1 of 3 places...
1) the IIS root directory, meaning where IIS EXE is at,
*not*
for better understanding:
phpCode
$conn1 = mysql_connect(localhost, user, pwd);
mysql_select_db(database1, $conn1);
$conn2 = mysql_connect(localhost, user, pwd);
mysql_select_db(database2, $conn2); // select two diff. DBs
echo $conn1.br;
echo $conn2.br;
/phpCode
returns:
Resource id
See the new_link parameter option for mysql_connect. It should solve
your problem. On the other hand, what you are doing is fine, I did it
for my pool since I can't use the new_link option because I'm retaining
compatibility back to PHP 4.1.2
Cheers,
Rob.
dorgon wrote:
for better
Hello people, greet for all
I tried to install these:
Win95 as operating system
PHP as parser
Apache as Web server
Mysql as DB server
I tried to configure these platforms, and when I write http://localhost
, it doesn't work, I think the problem is the web server, but I don't
understand
Hello people, greet for all
I tried to install these:
Win95 as operating system
PHP as parser
Apache as Web server
Mysql as DB server
I tried to configure these platforms, and when I write
http://localhost
, it doesn't work, I think the problem is the web server, but I don't
At 00:56 5-4-2003, you wrote:
Hello people, greet for all
I tried to install these:
Win95 as operating system
PHP as parser
Apache as Web server
Mysql as DB server
I tried to configure these platforms, and when I write
http://localhost
, it doesn't work, I think the problem is the
Chris Hayes wrote:
At 00:56 5-4-2003, you wrote:
Hello people, greet for all
I tried to install these:
Win95 as operating system
PHP as parser
Apache as Web server
Mysql as DB server
I tried to configure these platforms, and when I write
http://localhost
, it doesn't work, I think
]
Newsgroups: php.general
To: [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:53 PM
Subject: php and mysql
I have a db with events in it. i would like to pull the events out via
php,
but i would like them to be ordered by month number (1-12). When I do this
(Select blah blah From blah Order
automatically appears (and if there should be a power failure orWindows
crashes, or whatever else - I want the process to start at the last player
being updated - I don't want to have to start again from player one). I'm
not sure if this is more a PHP or MySQL question - or both - so I have sent
the next one
automatically appears (and if there should be a power failure
orWindows
crashes, or whatever else - I want the process to start at the last
player
being updated - I don't want to have to start again from player one).
I'm
not sure if this is more a PHP or MySQL question - or both - so I
I've got both MySQL and PHP working independantly on my Linux web
server. That is, I can view PHP web pages via Apache and I can access
MySQL from the command line, set up databases, tables, etc.
What I can't do is get them working together.
When trying to make a connection in the usual way
On Thursday 06 March 2003 13:32, John Almberg wrote:
You have started a new thread by taking an existing posting and replying to
it while you changed the subject.
That is bad, because it breaks threading. Whenever you reply to a message,
your mail client generates a References: header that tells
, January 07, 2003 5:06 PM
Subject: Re: [PHP] Re: PHP and MySQL bug
@mysql_select_db(be); -- this failed
do echo mysql_error(); to see what went wrong
Nuno Lopes wrote:
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server
4:12 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
Since nobody is jumping in to say it is some simple configuration/setting
personally my next step would be to shut down all services on the box that
aren't absolutely necessary and stop everything in the registry under run
and stop anything
:28 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
This definitely sounds like a buggy installation or there may be some
problem with the communication between the web server and the mysqld. Is
the db on a different machine? Try using mysql_pconnect instead of
connect
just to see what result you
')
- Original Message -
From: David Freeman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this
query doesn't work
Personally, I'd call it bad programming
I'm using Windows 2000.
- Original Message -
From: Cleber [EMAIL PROTECTED]
To: Nuno Lopes [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 10:23 AM
Subject: Re: [PHP] Re: PHP and MySQL bug
Try add to /etc/hosts the name and ip of DB is located
- Original Message -
From
, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this
query doesn't work
Personally, I'd call it bad programming practice to do a database update
and not check to see if it worked or not. In this case, how are you
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From: Larry Brown [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 4:16
: Monday, January 06, 2003 10:09 AM
To: MySQL List; [EMAIL PROTECTED]
Subject: Re: PHP and MySQL bug
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From
Here is the source code:
?
@MYSQL_CONNECT(localhost, nlopes, testing) or die(Erro 1);
@mysql_select_db(be);
$r=MYSQL_QUERY(SELECT n,u,m,h FROM d WHERE id='$id');
if (mysql_num_rows($r)==0) {
die (Erro);
} else {
$re=mysql_fetch_array($r, MYSQL_NUM);
$nome=$re[0];
$url=$re[1];
$mirrors=$re[2];
@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this
query doesn't work
Personally, I'd call it bad programming practice to do a database update
and not check to see if it worked or not. In this case, how are you
determining that the query did not work? Are you manually checking
">news:003a01c2b3de$95004650$0100a8c0@pc07653...
Dear Sirs,
I'm using PHP and MySQL to make my programs. But I think I discovered a
bug
in PHP or in MySQL (I don't know!).
In one of my files I have the following:
MYSQL_CONNECT(localhost, **user**, **pass**);
mysql_select_db(
Personally I say get yourself a good simple dbconnect class and make life easy.
Also if you ever change users, database name etc, you onlu have one place to replace
it in your code.
I wrote mine based on http://www.vtwebwizard.com/tutorials/mysql/
Take a look at it. Nice and simple.
Mike
Personally I think the problem lies somewhere between the chair and the keyboard
(Sorry, couldn't resist) :-)
*** REPLY SEPARATOR ***
On 04/01/2003 at 4:58 PM Stefan Hinz, iConnect (Berlin) wrote:
It doesn't work because of the /* Some code including ... */ part ;-)
04, 2003 11:46 AM
Subject: PHP and MySQL bug
Dear Sirs,
I'm using PHP and MySQL to make my programs. But I think I discovered
a bug
in PHP or in MySQL (I don't know!).
In one of my files I have the following:
MYSQL_CONNECT(localhost, **user**, **pass**);
mysql_select_db(be);
$r
That's how you do it. Hopefully you've figured it out already.
---John Holmes.
-Original Message-
From: dwalker [mailto:dwalker;healthyproductsplus.com]
Sent: Saturday, October 19, 2002 7:51 PM
To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL
1 - 100 of 145 matches
Mail list logo