Still think we need to see the PHP code before determining that it is an SQL
problem.
Regards,
J
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November
the month starts at 1, at the moment I'm just hard coding the month into the statment.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November 2002 00:46, Griffiths
Hi,
Since i dont know any mysql group, i will try here - it is anyway related to
php.
When i want to make php/mysql application i have mysql on the server and i
connect to it with mysql_pconnect(localhost,root,) and it works.
I assume that any user or hacker could connect to mysql database like
Hi,
Since i dont know any mysql group, i will try here - it is
anyway related to
php.
When i want to make php/mysql application i have mysql on the
server and i
connect to it with mysql_pconnect(localhost,root,) and it works.
I assume that any user or hacker could connect to mysql
how i do this in mysql.
If this is offtopic can someone point me to any mysql newsgroup.
I would say this is very offtopic, but this query should do the trick:
GRANT select, update, insert ON your_db_name.* TO
your_username@localhost IDENTIFIED BY 'your_password'
Take a look in the MySQL
Making an update query that adapts to the number of fields that are to be
updated
Is there anyway to do like a for loop to create the values part of the query
then combine it with the first part of the string.
something like what i have below... although something that works correctly
as
$query = UPDATE tablename SET ;
foreach($_POST AS $key = $value)
$query .= $key = '$value',;
$query[strlen($query)-1] = ;
$query .= WHERE id = '$_GET[id]';
Or something?
On Tue, 2002-11-12 at 13:58, David Rice wrote:
Making an update query that adapts to the number of fields that
How about:
function do_query ($table, $fields, $where)
{
$sql = 'update ' . $table . ' Set ';
foreach ($fields as $k=$v)
$sql = $k . ' = \'' . $v . '\',';
return mysql_query ($sql);
}
Not sure if it adapts 100% to your case but you can probably fix it
Hi
I am interested in the limits of MySql.
I have a site which is growing. The biggest tables are currently about 750K
but this will grow to the 3-10M record mark over the next 6 months. The
databases are well designed and are currently running smoothly on 2x1GHz
PIII and 512MB RAM.
I am
Make the include file (or wherever your page with the pass is)
encrypted, see ioncube.com they charge by the amount of code you
incrypt, for a simple database include file, I think it would
be $1 or less.
On Wed, 2002-11-06 at 16:04, William Trappeniers wrote:
Hi all
I was wondering if it is
Hi all
I was wondering if it is possible to protect my password to the MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets to
see my php-sourcecode also can see my (not protected/not encrypted)
password.
How can I change this?
Thanks,
William
---
William
I was wondering if it is possible to protect my password to the
MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets to
see my php-sourcecode also can see my (not protected/not encrypted)
password.
How can I change this?
You can't, unless you want to put it in
;charter.net]
Sent: Wednesday, November 06, 2002 4:16 PM
To: William Trappeniers; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
I was wondering if it is possible to protect my password to the
MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets
You could put it anywhere. Stick it in a text file somewhere, fopen()
and read the file for the password. Or keep it in a php script outside
of the web root if that's the issue, then just include() it when you
need to.
Of course any file you put it in will have to be readable by whatever
user
John W. Holmes' [EMAIL PROTECTED]; William Trappeniers
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:30 PM
Subject: RE: [PHP-DB] MySQL password protection?
actually you can make a .php file with your connection info, include it in
your .php files at the top
in it.
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 4:16 PM
To: William Trappeniers; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
I was wondering if it is possible to protect my password to the
MySQL
And make sure you make sure the webserver will not SERVE that file!!! You
see the source, see that you are fopening the file, I'll find it on your
system and get it from the web server and I have your password!
Make sure the file is NOT in the document root that the web server serves
from. You
The standard apache install filters anything named .ht*. on the web
tree.
-- Josh
-Original Message-
From: Peter Beckman [mailto:beckman;purplecow.com]
Sent: Wednesday, November 06, 2002 6:44 PM
To: Steve Cayford
Cc: [EMAIL PROTECTED]; William Trappeniers
Subject: Re: [PHP-DB] MySQL
PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
Create a user nobody with no password and give that user select,
update,
delete and insert capabilities in your DB and can only connect from
localhost (or a certain host). This way they have to be on localhost in
order to gain access
One thing I do with Postgres that I'm not sure MySQL supports is
Kerberos5 authentication. This way, a user logs in (and they have a user
account on the DB) and I use their remote user name and their Kerberos
ticket to authenticate them to the DB. That works without having to
store a password
Is there any way to change how many connections mysql allows? I keep
getting the too many connections error... (not using pconnect)
--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
--
PHP
I am having trouble with a canned calendar application and I think
that maybe the problem is the crypt function. Does anyone know of a good
way to test the crypt function? I need to figure out somehow if this is the
source of the problem or not. Thanks.
Scott Nipp
Phone: (214)
Hello,
Given a datetime field in a MySql database, how can i list all the records
that are dated back to yesterday or to 'N' days in the past?
Thanks,
Elias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Given a datetime field in a MySql database, how can i list all the
records
that are dated back to yesterday or to 'N' days in the past?
SELECT * FROM your_table WHERE TO_DAYS(date_column) =
TO_DAYS(CURRENT_DATE) - N
Where N is how many days you want to go back.
---John Holmes...
--
PHP
On Monday 21 October 2002 22:07, lallous wrote:
TO_DAYS() applied on datetime field is returning different values on
different times but same date!
How can I pass to TO_DAYS() only the DATE part of my datetime field?
As far as I can tell, TO_DAYS() does only use the DATE part regardless
Whilereading the MySQL manual for INSERT SELECT, I was
not able to determine how to includeall 5 fields of one table into another
table (containing 100 fields) into SPECIFIC data fields. Do I need to
explicitly list all the fields within the table of 5 fields? If so, would
the statement be:
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
.
-Original Message-
From: John W. Holmes [EMAIL PROTECTED]
To: 'dwalker' [EMAIL PROTECTED]; 'professional php'
[EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED];
[EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, October 19, 2002 7:24 PM
Subject: RE: [PHP-DB] MySQL Insert Select statement
That's
]
10/19/2002 08:32 PM cc:
Please respond to Subject: Re: [PHP-DB] MySQL
Insert Select statement
Hi All
I have created a function and insde that function it dose a standard
select, fetch_arry, while loop.
I get a error from mysql saying not a vaild resource but if I take the
statemnet out of the function all works fine and dandy.
Are there things I should be aware of when trying to include
you should return the results.
hope that helps.
-rob
-Original Message-
From: Dave Carrera [mailto:dave;davecarrera.com]
Sent: Friday, October 18, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql Statement inside a function?
Hi All
I have created a function and insde
]
Sent: Friday, October 18, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql Statement inside a function?
Hi All
I have created a function and insde that function it dose a standard
select, fetch_arry, while loop.
I get a error from mysql saying not a vaild resource but if I
Hi People.
I need import some data from a Paradox table, i used the script below, it worked just
fine..but all the data was imported without the ç or á or é , understand???
portuguese words all this changes to some wierd caracter is there a way to fix
this, since my table is
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 8:26 AM
Subject: [PHP-DB] MySQL REGEXP functionality... any way to make this easier?
Right now, a sample query I might have would be...
SELECT * FROM ospd WHERE word REGEXP '^([a]?[p]?[e]?)$|^[p]?[a]?[e]?$|^[a
]?[e]?[p]?$|^[p]?[e
combination by
yourself
greet
martin
- Original Message -
From: Xepherys [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 8:26 AM
Subject: [PHP-DB] MySQL REGEXP functionality... any way to make this easier?
Right now, a sample query I might have would be...
SELECT
Right now, a sample query I might have would be...
SELECT * FROM ospd WHERE word REGEXP '^([a]?[p]?[e]?)$|^[p]?[a]?[e]?$|^[a
]?[e]?[p]?$|^[p]?[e]?[a]?$|^[e]?[p]?[a]?$|^[e]?[a]?[p]?$';
where basically I need to query every combination of a, p and e. This is a
pain, but for only three letter is
New MySQL is out I noticed (4.0.4). Is there any way to make it work
correctly with PHP? I haven't seen any modules for download or comments
about this issue.
I'm just wondering if there is some modifications I can make or if I'm just
stuck with MySQL 3.x until something new is released by the
New MySQL is out I noticed (4.0.4). Is there any way to make it work
correctly with PHP? I haven't seen any modules for download or
comments
about this issue.
I'm just wondering if there is some modifications I can make or if I'm
just
stuck with MySQL 3.x until something new is released
Hi,
I don't know if I'm right at this list.
I have installed the mysql server on my debian Linux Server and it runs
perfectly if I'm connecting it from my Puretec Webspace. But if I'm
connecting from Apache with PHP4 running on localhost with the same script
it won't run but no Error are logged
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]]
Sent: 23 September 2002 18:09
I've been running into a strange problem on my server with
scripts that
take form input and reformat it into SQL. It only happens
with statements
that insert or update data, the
Hi peoples,
The company I'm about to partner with for hosting my websites is using
postgresql for their database server. I currently use mysql for all of
mine.
What I'm trying to find out is peoples experiences using postgresql, any
plusses or minusses, is it worth using these guys or finding
Hi peoples,
The company I'm about to partner with for hosting my websites is using
postgresql for their database server. I currently use mysql for all of
mine.
What I'm trying to find out is peoples experiences using postgresql, any
plusses or minusses, is it worth using these guys or
Hi,
I've been running into a strange problem on my server with scripts that
take form input and reformat it into SQL. It only happens with statements
that insert or update data, the first four characters of the POST variables
starting at the fourth variable passed are dropped.
So lately if I
Hi all,
I have a table in MySQL with the following field:
'time_date' timestamp(14) NOT NULL
When a record is inserted into the table, NULL is inserted into the
time_date field giving me a normal timestamp with the time of the INSERT.
That much is fine.
However, it is necessary for me to
At 11:59 -0500 9/11/02, Rob Day wrote:
Hi all,
I have a table in MySQL with the following field:
'time_date' timestamp(14) NOT NULL
When a record is inserted into the table, NULL is inserted into the
time_date field giving me a normal timestamp with the time of the INSERT.
That much is
Hi
you have to restart your mysqld server with
--default-character-set=greek option. You can either do this by
explicitly giving it in the command line when restarting your mysqld, or
you can add that line to your global my.cnf file.
See:
http://www.mysql.com/doc/en/Command-line_options.html
Hi, I have a MySQL problem but due to small problem of my email I can't subscribe to a
MySQL list so I wonder if someone from you can answer (actually I'm sure about it...)
My problem is that I have a query that fetches all data from a table in alphabetical
order using the ...order by col_name
how would i go about making a few queries into a transaction - that is, if
one of them fails, the previous queries get rolled back...
cheers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 04, 2002 3:04 PM
Subject: [PHP-DB] [mysql] query atomicity
how would i go about making a few queries into a transaction - that is,
if
one of them fails, the previous queries get rolled back...
cheers
--
PHP Database Mailing Li
this function doesnt work
function query($sql)
{
return mysql_query($sql, $this-mysql_link) or die(query
failed: $sql);
}
but this one does
function query($sql)
{
$mysql_result = mysql_query($sql, $this-mysql_link) or
what would happen if i do not use mysql_free_result() and mysql_close() for
my scripts.
i presuming it doesnt leak memory. if so, then why not just forget about
them, and let the automatic freeing thingie's do the work?
cheers
--
PHP Database Mailing List (http://www.php.net/)
To
Where can I find a good manual/tutorial on how to access mySQL w/PHP. Keep in mind
that I am new to both PHP and mySQL, and my database theory is sketchy at best.
Thanks.
try a little thought...
http://www.google.com/search?sourceid=navclientq=php+mysql+tutorial
// -Original Message-
// From: Bryan McLemore [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 30 August 2002 2:52 PM
// To: PHP LIST
// Subject: [PHP-DB] MySQL/PHP
//
//
// Where can I find
i have a simple guest book script from a book by jay greenspan i think ,
when i run seems oikay i fill in the form and click submit, after submitting
iam getting this error ?
PHP Warning: Failed opening 'dbconnect.php' for inclusion
(include_path='c:\php\includes') in
On Wednesday 28 August 2002 20:48, R Strang wrote:
i have a simple guest book script from a book by jay greenspan i think ,
when i run seems oikay i fill in the form and click submit, after
submitting iam getting this error ?
PHP Warning: Failed opening 'dbconnect.php' for inclusion
8:17 AM
Subject: Re: [PHP-DB] MySQL and BLOB
On Thursday 22 August 2002 13:57, Andy wrote:
Hi there,
I am storing via PHP pictures into BLOB fields. Worked fine so far for
over
200 images.
Now an error has occured with a particular picture. No error msg. Just
does
not work
Hi there,
I am storing via PHP pictures into BLOB fields. Worked fine so far for over
200 images.
Now an error has occured with a particular picture. No error msg. Just does
not work. The wired thing is that the thumbnail does. So I guess the BLOB
field is just to small for the image.
How many
On Thursday 22 August 2002 13:57, Andy wrote:
Hi there,
I am storing via PHP pictures into BLOB fields. Worked fine so far for over
200 images.
Now an error has occured with a particular picture. No error msg. Just does
not work. The wired thing is that the thumbnail does. So I guess the
Read about GRANT function in the MySQL manual.
-Joni-
--
// Joni Järvinen
// [EMAIL PROTECTED]
// http://www.reactorbox.org/~wandu
On Sunday 18 August 2002 09:54, Georgie Casey wrote:
rite,
i run a web server and sell space to workers. my admin setup apache,
mysql
and php with all the
, as that is naturally a massive
security hole.
~ Matthew
-Original Message-
From: Georgie Casey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 9:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mySQL settings
rite,
i run a web server and sell space to workers. my admin setup apache,
mysql
rite,
i run a web server and sell space to workers. my admin setup apache, mysql
and php with all the settings. each customers gets one sql db with a host
acc. the system runs ensim. but now i want one of my accounts do be able to
access the database of another, but it wont let me. what setting
On Sunday 18 August 2002 09:54, Georgie Casey wrote:
rite,
i run a web server and sell space to workers. my admin setup apache, mysql
and php with all the settings. each customers gets one sql db with a host
acc. the system runs ensim. but now i want one of my accounts do be able to
access
for some reason in my mysql selecct statements in my php pages, when i
upload them to my web server, they just return a blank record set. no errors
or anything, just blank. i can insert fine but no select. it works fine on
my test win32 apache/mysql
--
Regards,
Georgie Casey
[EMAIL PROTECTED]
George,
It is likely that your win32 system did not care about case. If you are
using a *nix host it is case sensitive, and its installation of MySQL, by
extension, is as well.
Try echo'ing the select statement to see what you have.
Miles
At 10:42 PM 8/14/2002 +0100, Georgie Casey wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
I have a database thats taking a bit of a hammering - enough so that the
number of connections spirals up and out of control.
max_connections was originally at the default of 100 - but rising above 50 or
so meant actual throughput dropped so
I would suggest looking into MySQL's replication support. Split reads and
writes so they go to separate servers. That is, create a master server
where you send all database writes. And do all reads on the replicated
slave servers.
Have a look at this presentation I gave last week on this
hello..
i have a pretty wired query to do with php/mysql .
i don't manage to do
mysql_query($qry,$connection); .
(query bellow)
so i found a quick and dirty solution.see bellow .
but it's no realy elegant .
any ideea how can i do multiple queries at once with mysql_query() ?
function
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
Error
SQL-query :
CREATE TABLE hospital (
id smallint(5) unsigned NOT NULL auto_increment,
heath_system_id smallint(5) unsigned default NULL,
name_long tinytext NOT NULL,
name_short
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I was using phpMyAdmin to do an export from one machine to another and on
import
Try [desc]
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, July 10, 2002 10:51 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent
I can't say for sure, but perhaps desc is a reserved word, short for
describe. What happens if you say something like description?
Chip
On Wed, 10 Jul 2002, Michael Zornek wrote:
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
Error
DESC is a reserved word in SQL, standing for Descending Order. That is why you can't
use it as a table column name.
HTH
Martin
Michael Zornek [EMAIL PROTECTED] 07/10/02 12:49PM
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
Error
Sorry, [desc] won't work either. :-(
-Original Message-
From: Chip Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:54 AM
To: Michael Zornek
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I can't say for sure, but perhaps desc
On Thursday 11 July 2002 01:00, Ryan Jameson (USA) wrote:
Sorry, [desc] won't work either. :-(
Try `desc`.
But it's best not to use 'desc' at all, it will save you confusion in the long
run.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
*
Twas 7/10/02 12:55 PM, when Martin Clifford [EMAIL PROTECTED] said:
DESC is a reserved word in SQL, standing for Descending Order. That is why
you can't use it as a table column name.
Ok, that makes sence - thanks!
Although I find it a bit curious that building the DB in phpMyAdmin let me
:
http://www.mysql.com/doc/L/e/Legal_names.html
Gurhan
- Original Message -
From: Michael Zornek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 1:30 PM
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
Twas 7/10/02 12:55 PM, when Martin Clifford [EMAIL
I seem to have run into another problem with a query that I am doing
exactly like the example in the MySQL documentation, I think. The following
query is not working on my PHP page, and it is not working from a MySQL
command line either. This looks exactly the same as an example in the
Hey guys... I know that this is not specifically on topic for this
group, but I promise this is an easy one.
I am developing a web app, and need to create a development copy of
the production database. I have created the new database, now I just need
to export and import the
, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 12:26 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MySQL test database creation...
Hey guys... I know that this is not specifically on topic for this
group, but I promise this is an easy one.
I am developing
Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 18:26
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MySQL test database creation...
Hey guys... I know that this is not specifically on topic for this
group, but I promise this is an easy one.
I am
In need of some help. I have a PHP form page that is updating a
MySQL database that is not working. Here is the code for the three pages
that work together for this application. The oncall_new.php works fine to
insert new records into the database, and the oncall_log.php works fine to
I didn't get your attachements. Maybe paste them in a row into the email?
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 10:07 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MySQL Update failing...
In need of some help. I
: Thursday, June 27, 2002 11:07 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MySQL Update failing...
In need of some help. I have a PHP form page that is updating a
MySQL database that is not working. Here is the code for the three pages
that work together for this application
hi all
I want to know storage required for my database.
How i can determine size required for indexing a column ?
(my column's type that indexed is varchar(15))
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hmm...
index it - and you will know
olinux
--- [EMAIL PROTECTED] wrote:
hi all
I want to know storage required for my database.
How i can determine size required for indexing a
column ?
(my column's type that indexed is varchar(15))
Thanks
--
PHP Database Mailing List
Hi all,
I have a Cobalt Raq 4 running Linux. I've installed the .pkg file
RaQ3-RaQ4-MySQL-3.23.37-1.pkg I can telnet into the server and I type
mysql, now I see that I'm in MySql, but when I type
bin/mysqladmin -password and put a password in, it just goes to the next
line with a - and a
At 14:58 -0400 6/24/02, Page Works Web Solutions wrote:
Hi all,
I have a Cobalt Raq 4 running Linux. I've installed the .pkg file
RaQ3-RaQ4-MySQL-3.23.37-1.pkg I can telnet into the server and I type
mysql, now I see that I'm in MySql, but when I type
bin/mysqladmin -password and put a
neficial to check the event log. More clues may lie in
there. If the webserver has any type of error log check that as well.
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 1:10 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-D
Are you able to connect to the MySQL server using a client?
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL Socket error :\
PHP Warning: MySQL Connection Failed: Can't
, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL Socket error :\
PHP Warning: MySQL Connection Failed: Can't create TCP/IP socket
(10106)
in c:\flashinlabs\web\http\provamysql.php on line 3
this is the LOG error.
i'm into panic.
Aaron T. Weiker [EMAIL PROTECTED] ha scritto nel m
Hi
I have a mysql table that has a field in it called 'DATETIMEADDED' which
has data type 'datetime' I want to display the contents of the field on my
page. I have tried usng the following code but the value in the
'DATETIMEADDED' only the value in the 'NAME' field which is a varchar is
On Friday 21 June 2002 21:42, Charlie Grosvenor wrote:
Hi
I have a mysql table that has a field in it called 'DATETIMEADDED'
which has data type 'datetime' I want to display the contents of the field
on my page. I have tried usng the following code but the value in the
'DATETIMEADDED'
Hi
sorry for my english but i'm italian.
I have a server who run with
WIN XP HOME
Abyss Web Server (Freeware) www.aprelium.com
MySql 4.0.1-alpha-nt
PHP 4.2.1
when i use mysql_connect($host,$user,$pass) or die(mysql_error()); function
he write:
Can't create TCP/IP socket (10106)
i have
: Friday, June 21, 2002 11:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MYSQL Socket error :\
Hi
sorry for my english but i'm italian.
I have a server who run with
WIN XP HOME
Abyss Web Server (Freeware) www.aprelium.com
MySql 4.0.1-alpha-nt
PHP 4.2.1
when i use mysql_connect
ROTECTED]
Subject: [PHP-DB] MYSQL Socket error :\
Hi
sorry for my english but i'm italian.
I have a server who run with
WIN XP HOME
Abyss Web Server (Freeware) www.aprelium.com
MySql 4.0.1-alpha-nt
PHP 4.2.1
when i use mysql_connect($host,$user,$pass) or die(mys
]
Subject: Re: [PHP-DB] MYSQL Socket error :\
Thanks Dan, but i have already tested this solution...
i have build a very little test script, who generate this error.
?php
mysql_connect(127.0.0.1,root,admin) or
die(mysql_error()); print(connected!!!);
?
i am in localhost and i use
Howdy all,
If someone call tell me why this MySQL query is not working, I'd be VERY thankful. I
don't see a damn thing wrong with it, but I could have been looking at it too long.
Here is the query:
$query = UPDATE articles2 SET title=\$title, brief=\$brief\, doclink=\$doclink\
WHERE
Hi All:
I quickly skimmed the MySQL manual and didn't see any information on
clustering. Does MySQL have any support for clustering or some type of
redundant failover systems?
Thanks!
Matt Babineau
Freelance Internet Developer
-
e: mailto:[EMAIL
Yes,it's called Replication in the MySQL documentation.
However, since the info in the manual is kind of sparse so I would hop
on google and do a search for specific instructions on how to do it when
your ready, but to answer your question, yes, MySQL does do
Redundancy/Failover. (Ofcourse you
://www.criticalcode.com
PO BOX 601
Manchester, NH 03105
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 8:55 AM
To: [EMAIL PROTECTED]
Cc: Matt Babineau
Subject: Re: [PHP-DB] MySQL Clustering, redundancy
Yes,it's called Replication in the MySQL documentation
901 - 1000 of 1362 matches
Mail list logo