[PHP-DB] parse error in create statement.

HI, Whats the error in this code. $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK;

Re: [PHP-DB] parse error in create statement.

Check your placement of all the '.' for a start. raz On 6/14/05, babu [EMAIL PROTECTED] wrote: HI, Whats the error in this code. $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

Re: [PHP-DB] parse error in create statement.

Also, correct me if I'm wrong, but this needs to be split into two seperate query strings and executed seperately... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] parse error in create statement.

$sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser. GRANT CONNECT TO .$adduser.; for the .'s

Re: [PHP-DB] parse error in create statement.

Missing a . in the line before the last quote GRANT CREATE TRIGGER TO .$adduser $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS

[PHP-DB] RE : Subject: Com 1

From: Nandar [EMAIL PROTECTED] To: php-db@lists.php.net Message-ID: [EMAIL PROTECTED] Date: Tue, 14 Jun 2005 10:01:59 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_0007_01C570C8.1A876C60 Subject: Com 1 Hi,. any one to know, how to send ascci

[PHP-DB] Security and MYSQL databases

Hello. Simple question. An SSL server and a standard a shared MYSQL server that I have with my hosts. If I am to set up a shopping cart system, is this a secure way of handling credit card details. What is the best way of receiving the details? I assume an email is not a good way as these

RE: [PHP-DB] Security and MYSQL databases

You should never [almost never ever] store cc details from your users. Integrate a 3rd party payment processor into your site and process the payments immediately. It will cut down on fraud and chargebacks by the users. Its also more secure since the cc details are not stored on your machine.

Re: [PHP-DB] Security and MYSQL databases

Thanks, I kind of suspected this, but it's good to be told. I wouldn't want to like to think my CC details were held on some database somewhere where it can get hacked into. Apart from paypal are there any other 3rd party payment processors that anyone recommends? I think we're perhaps

[PHP-DB] Strange MySQL Problem

I'm am having the hardest time getting PHP to connect to MySQL. From a command line I can say 'mysql -u root -p' and connect with no problems. From within my PHP script if I say $_connection = mysql_connect('localhost', 'root', 'password') or die(mysql_error()); I get: Can't

Re: [PHP-DB] Strange MySQL Problem. .

Brian D. McGrew wrote: I'm am having the hardest time getting PHP to connect to MySQL. From a command line I can say 'mysql -u root -p' and connect with no problems. [snip] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) what do you get with:

[PHP-DB] Postgres Bytea Field + Adodb

Hi, someone can helpme with inserting a binary data (from a file) to a Postgres Database with the ByteA field, i'm using the ADOdb class. THX -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] mysqldump but exclude one table

Hello everyone, I've a reader for sometime now, the best db list ever got into. Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible? Thanx - Yahoo! Mail Stay connected, organized, and protected. Take

Re: [PHP-DB] mysqldump but exclude one table. .

Hassan wrote: Hello everyone, I've a reader for sometime now, the best db list ever got into. Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible? [snip] from mysqldump --help --ignore-table=name Do not dump the specified table. To specify more

Re: [PHP-DB] mysqldump but exclude one table. .

C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) C:\mysqldump --help | grep table STDIN 6 Dumping definition and data mysql database or table STDIN 7 Usage: mysqldump [OPTIONS] database [tables] STDIN 22--add-drop-tableAdd a 'drop

Re: [PHP-DB] mysqldump but exclude one table. .. .

[EMAIL PROTECTED] wrote: C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) [snip] Ummm. What version are you using, Martin? David fairly fresh I'm afraid. mysqldump Ver 10.9 Distrib 4.1.9, for pc-linux-gnu (i686) your grep generates...