Hi
Try running a grant query
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'mypassword';
which will probably fix it
Peter
-Original Message-
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
You will use the mysql_select_db() function. It sets the currently active database.
You will call this function each time you wish to change which database is being used
prior to issuing a query.
You need to open only one connection as long as the databases are on the same server.
If you
hi all,
i was just wondering if there are any naming conventions when creating
database connections. most of my books use
$sql = SQL STRING;
and
$sth = $db-query() or $result = $db-query()
I have no idea what sth stands for in this case, but was curious how
others name stuff.
thanks
on 3/30/03 9:52 AM, Charles Kline at [EMAIL PROTECTED] appended the
following bits to my mbox:
i was just wondering if there are any naming conventions when creating
database connections. most of my books use
$sql = SQL STRING;
and
$sth = $db-query() or $result = $db-query()
I have
In essence it doesn't matter so much which convention you use as long you
use a convention, use it consistently and the convention itself doesn't come
with too much complexity of it's own and is based on a clear philosophy.
The naming convention I use in any environment or language uses simple
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
Hi. I want to use PHP and MySQL to help make it easier to put
pictures on a website. What I want to do is make a page that allows the
client to submit a picture (or a bunch of pictures) and a caption for
each picture to me via a form of some sort. Then, once the file gets
here, I would
Hi,
Is it possible to catch the type of error message returned form a
mysql_query(); funtion
for example
if ($error == //duplicate row for table)
{
echo This row already exists in the table;
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
www.php.net/mysql-error
shaun wrote:
Hi,
Is it possible to catch the type of error message returned form a
mysql_query(); funtion
for example
if ($error == //duplicate row for table)
{
echo This row already exists in the table;
}
--
The above message is encrypted with double rot13
Just to illustrate how you'd go about doing this:
- User uploads image description
- You resize image with GD functions (look at imagecopyresized())
- Store URL and description to the mySQL table you made
It's a very simple thing to do once you organize your file structure where
you're going to
Good afternoon!!
I have several (50+) tables I have to create in MySql. Is there a good PHP example on
creating a table via PHP?? I will probably do all of the initial INSERTS that way, too.
Thanks!!
Robin Kopetzky
Black Mesa Computer/Internet Services
www.blackmesa-isp.net
I have several (50+) tables I have to create in MySql. Is there a good
PHP
example on creating a table via PHP?? I will probably do all of the
initial INSERTS that way, too.
You don't create a table via PHP, you simply pass a query through the
mysql_query() function. If that query is a CREATE
ARGGHHH!!!
Trying to use INFILE to load a small (125) entry block of data and all MqSql does is
puke:
ERROR 1148: The used command is not allowed with this MySql version. (3.23.55)
If this command is no good, then what the hell am I supposed to use
At least with MS, you have a nice, GUI
At least with MS, you have a nice, GUI to use...
http://www.phpmyadmin.net/
Neil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi; You could try mysqlimport with the following syntax:
mysqlimport -h localhost -u username -p -L dbname pathtofile
where' file' is tab delimited text held on local machine.
All the best,
Joe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Jason Wong wrote:
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
Ummm That's a good reason! As I said, I'm a newbie to PHP, and
Hi everybody,
In php.ini, I can set the maximum persistent connections for MySql or ODBC.
But I use Oracle 9i in my project. Who can tell me how to restrict maximum
persistent
connection for Oracle?
Thanks.
--Jerry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that sufficient to get MySQL 4 support?
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Monday 31 March 2003 04:46, Benjamin Higgins wrote:
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that sufficient to get MySQL 4 support?
Yes.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
*
Sure does - sure is.
-Original Message-
From: Benjamin Higgins [mailto:[EMAIL PROTECTED]
Sent: Monday, 31 March 2003 6:47 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MySQL 4
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that
20 matches
Mail list logo