My hosting company gave me one database and one root user account, and I
have no access for priviliges at all. So as far as I can tell, the only way
for me to connect to the database on my site is to do a
mysql_connect(host, user, pass), where the user and pass are the ones
for this one super
On Sun, 23 Jan 2005 10:43:03 +0400, Radwan Aladdin
[EMAIL PROTECTED] wrote:
I wanted to know the best Random Function for PHP.. But please I don't want
duplications to happen at the same second.. because I receive many
customers..
For that purpose, mt_rand ( [int min, int max]) function is
A better idea would be, back to basics, back to learning SQL.
Otherwise you'll get PLENTY rows and don't even know why ;)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I do support you too, Jerry. People should either
somehow exclude
'php-db'/other mailing lists to be auto-replied to
or they must keep
off their auto-replies with themselves.
Yes most mail systems allows you to exclude certain
domains from getting a auto response. Or if they own
their
I do support you too, Jerry. People should either somehow exclude
'php-db'/other mailing lists to be auto-replied to or they must keep
off their auto-replies with themselves.
Its quite stupid recieving emails saying I am out of office when we
are waiting for more urgent things.
Regards,
Samar
What i love even better is when somebody on a mailing list, makes the
email hand back a receipt, how many people on this list, 10k+? Ouch
thats a lot of replies. Heh.
Marcus Joyce
JeRRy wrote:
I do support you too, Jerry. People should either
somehow exclude
'php-db'/other mailing lists to
Simple _complete_ solution: Find a different hosting company that provides a
virtual server and root access to everything about your account. Cost should
be nominal, but probably not free.
Simple _partial_ solution: Use INCLUDEs for the login portions of the
script(s) and place them in a
On Sunday 23 January 2005 23:40, JeRRy wrote:
I do support you too, Jerry. People should either
somehow exclude
'php-db'/other mailing lists to be auto-replied to
or they must keep
off their auto-replies with themselves.
Yes most mail systems allows you to exclude certain
domains
On Mon, 24 Jan 2005 01:56:03 +0800, Jason Wong [EMAIL PROTECTED] wrote:
More specifically, smart autoresponders will not respond to mailing lists,
bounces, etc.
If they are some kind of extensions or plug-ins to email clients, I
guess you could put up some more info on them to enlighten all of
Let me explain this a bit better, or try to. ;)
Let's say I have some code on MY SERVER.
I will call it MYSERVER and an outside server
outside my local area OUTSIDESERVER.
Now I have PHP on MYSERVER to connect to a database
on an OUTSIDESERVER and once establish do a few
updates/deletes etc.
What admin tools do you have for the db? PhpMyAdmin? something else? Many of
those can be used to create additional user accounts with more limited
restricitions.
Bastien
From: Shay [EMAIL PROTECTED]
Reply-To: Shay [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Given only one
Depends on what you mean by security safe. Safe for sensitive data? Nope.
Its all sent clear text over the net unless you use ssl encryption. You will
need to alter the second remote db to accept a connection/account coming
from your primary server. Your host may not allow that, you'll need to
Shay definitely has bad hosting.
the guy wants a seperate mysql user with readonly privileges on his DB which
is good practice. only ...
his hostingco. has given him a single DB and a single user a/c. no doubt they
manage
their system via a webinterface - when every they add a customer, they
On Mon, 24 Jan 2005 05:20:20 +1100 (EST), JeRRy [EMAIL PROTECTED] wrote:
Let me explain this a bit better, or try to. ;)
Let's say I have some code on MY SERVER.
I will call it MYSERVER and an outside server
outside my local area OUTSIDESERVER.
Now I have PHP on MYSERVER to connect to a
if you have kind of geo id number you could use that, failing to have that
info, you could re-arrange the data to have Akron - Central, Akron - SE (so
that all is in a standard format)
Bastien
From: Chris Payne [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] GROUP BY? Urgent help
Hi there,
The problem is, the database is imported from a huge properties database and
can only be imported in the format from the central database of estate
agents, so I can't reformat it in the tables itself.
Each table has the same fields, but one is for condo's, one is for
residential etc
Chris Payne wrote:
Hi there,
The problem is, the database is imported from a huge properties database and
can only be imported in the format from the central database of estate
agents, so I can't reformat it in the tables itself.
Each table has the same fields, but one is for condo's, one is for
Ah, that's ugly. Non-standard data is a bitch to make work. What i would do
then is create a virtual column with a case-when-then construct based on an
instring of area (like akron). Have a look at the mysql manual
(http://dev.mysql.com/doc/mysql/en/case-statement.html) for the syntax.
Is
Yes they gave me phpMyAdmin to use, and no, I have no access to the
user/privilege table. So the only way to output database entries is to
connect with the single super account they gave me.
I have a question about what you said Doug:
Use INCLUDEs for the login portions of the script(s) and
Shay wrote:
Yes they gave me phpMyAdmin to use, and no, I have no access to the
user/privilege table. So the only way to output database entries is to
connect with the single super account they gave me.
Principally, this means you cannot allocate user accounts for mysql. No
big deal unless
--- Doug Thompson [EMAIL PROTECTED] wrote:
Shay wrote:
Yes they gave me phpMyAdmin to use, and no, I have
no access to the
user/privilege table. So the only way to output
database entries is to
connect with the single super account they gave
me.
I find this unusual. I'm on a
Another thought on this:
Even though you don't have access via phpmyadmin to get to the users table,
could you try to create users/grant privileges via straight sql thur the PMA
sql window?
ie
grant select, insert, update to 'bob'@'localhost' on mysql.users indentified
by password('my_pass');
Without the ability to update the database mysql, your suggestion doesn't
work.
Just to confirm, here is a quick check to perform locally.
1. Log in as root.
2. Create DB test and user test with all privileges with grant option on only database test.
(grant all privileges on test.* to
On Monday 24 January 2005 02:13, Samar wrote:
On Mon, 24 Jan 2005 01:56:03 +0800, Jason Wong [EMAIL PROTECTED] wrote:
More specifically, smart autoresponders will not respond to mailing
lists, bounces, etc.
If they are some kind of extensions or plug-ins to email clients, I
guess you could
24 matches
Mail list logo