Hi.
call this function, phpinfo(); in a *.php file.
That should return alot of usesfull info.
Make sure the mysql extension is being loaded.
If so check the value of the following php config var:
; Default socket name for local MySQL connects. If empty,
; uses the built-in ; MySQL defaults.
Hi Daniel.
Distribute it under the CC license?
http://creativecommons.org/about/licenses/index_html
Keith
In theory, theory and practice are the same;
in practice they are not.
On Fri, 19 May 2006, Daniel Orner wrote:
> To: mysql@lists.mysql.com
> From: Daniel Orner <[EMAIL PROTECTED]>
> Subj
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
For any major changes to a database such as you describe, if
you have the disk space, I would advise copying the database
and performing your changes on the copy, just i
Well, mysql has support for regex matching. The thing is
though, why store invalid email addresses in you database?
I think what you are doing is the right approach.
Check the email address validity first in php BEFORE saving
it to the database. At least you then know you are only
storing vali
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat,
icense,
> "Creative Commons licenses are not intended to apply to software. They
> should not be used for software."
> So I'm not entirely sure why you're recommending it. ^^; It is
> released under the GPL.
>
> --Daniel
>
> "Keith Roberts&
There is no reason why you cannot use diffeent package
managers for your system. The only thing is do not run two
managers at the same time, as they require exclusive access
to the rpm database.
Trying to use more than one package manager, or multiple
instances of the same one is not a good id
Check this out, it works a treat for me:
http://www.tmda.net
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 24 May 2006, Jørn Dahl-Stamnes wrote:
> To: mysql@lists.mysql.com
> From: Jørn Dahl-Stamnes <[EMAIL PROTECTED]>
> Subject: Re: SPAMs
>
> O
The identifier quote character is the backtick (`):
mysql> SELECT * FROM `select` WHERE `select`.id > 100;
Or could you just use an ALTER TABLE statement to change the
name in your database, and then change the div name in your
application code?
HTH
Keith Roberts
In theory, theory and pra
mirror
MD5: 0eaa7a8ec18699ce550db1713a27cda3 | Signature
HTH
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Fri, 2 Jun 2006, yuan edit wrote:
> To: mysql@lists.mysql.com
> From: yuan edit <[EMAIL PROTECTED]>
> Subject: mysql edition problem
>
> my opera
Are you moving to a new unpopulated server, or are there
already mysql users on the new server?
If it is a new server with no other mysql users onboard,
then I guess it is as easy as copying the mysql system
database (/var/lib/mysql/mysql on my system) across to the
new server, with the other
o far wrong by getting these two
books together.
Regards
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Fri, 9 Jun 2006, Chris White wrote:
> To: mysql@lists.mysql.com
> From: Chris White <[EMAIL PROTECTED]>
> Subject: Books on MySQL 5
&g
ility reasons?
I would really like to see a slim and trim version of mysql,
the SQL commands, and the supporting cli programs,
that is up to date and has a very fast learning curve.
Just my little gripe.
Kind Regards
Keith Roberts
In theory, theory and practice are the same;
in practice they ar
Jun 2006, Gaspar Bakos wrote:
> To: Keith Roberts <[EMAIL PROTECTED]>
> From: Gaspar Bakos <[EMAIL PROTECTED]>
> Subject: Re: my-huge.cnf quite outdated
>
> Hi, Keith,
>
> RE:
> > This seems to be the way things are with mysql nowdays.
> > Is it not t
| ipf_1 | ipf_2 | ipf_3
1 2 JohnSmith email_addy
Which will allow you to retrieve all the values you want
from the table as one row without having to repeat the
userid column?
HTH
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Wed, 14 Jun
to what php is, and what it can do.
HTH
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
To unsubscribe from this list, please see detailed
instructions already posted at:
http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2
On Thu
nt_offset |
+-+
| 201 |
+-+
1 row in set (0.02 sec)
mysql>
HTH
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Fri, 23 Jun 2006, Tom Ray [Lists] wrote:
> To: mysql@lists.mysql.com
> From: "Tom Ray [Li
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
--
Keith Roberts
IT Manager - Laptops For Less
2995 White Star
Anaheim, CA
18 matches
Mail list logo
