Re: [PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread R B
thank you. On Mon, Feb 9, 2009 at 1:14 PM, Shawn McKenzie wrote: > R B wrote: > > I´m looking that i have another problem: > > > > I´m making a software to install in any server. > > > > The software needs a database, so i want to create a script install.php > > to create the database when thi

Re: [PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread Shawn McKenzie
R B wrote: > I´m looking that i have another problem: > > I´m making a software to install in any server. > > The software needs a database, so i want to create a script install.php > to create the database when this script is executed. > > At this point of the instalation, i don´t know none of

[PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread Shawn McKenzie
Shawn McKenzie wrote: > Shawn McKenzie wrote: >> R B wrote: >>> Hello, >>> >>> When i create a mysql database with the next command: >>> >>> mysql_query("CREATE DATABASE my_db",$con) >>> >>> In the server is created the database, but usually the name is created with >>> a prefix. >>> >>> In this ca

Re: [PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread R B
I´m looking that i have another problem: I´m making a software to install in any server. The software needs a database, so i want to create a script install.php to create the database when this script is executed. At this point of the instalation, i don´t know none of the users that are defined

[PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread Shawn McKenzie
Shawn McKenzie wrote: > R B wrote: >> Hello, >> >> When i create a mysql database with the next command: >> >> mysql_query("CREATE DATABASE my_db",$con) >> >> In the server is created the database, but usually the name is created with >> a prefix. >> >> In this case: someuser_my_db >> >> How can i

Re: [PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread R B
I´m creating a software that use a database, and i want to include a install.php file to install the database of the software. I can create the database in the install.php file with mysql_query("CREATE DATABASE my_db",$con) But when is created, i don´t know the complete name of the database, beca

[PHP] Re: mysql_query - CREATE DATABASE

2009-02-09 Thread Shawn McKenzie
R B wrote: > Hello, > > When i create a mysql database with the next command: > > mysql_query("CREATE DATABASE my_db",$con) > > In the server is created the database, but usually the name is created with > a prefix. > > In this case: someuser_my_db > > How can i detect with PHP the complete na

[PHP] Re: mysql_query() ERROR

2002-08-21 Thread Bogdan Stancescu
It's not the ")" characters, it's the quotes - make sure you addslashes() to all the variables. Also make sure you don't double-slash - depending on your php.ini settings, PHP may automatically slash incoming variables. Bogdan Mike Fifield wrote: > This is a query that I am sending to mysql.

[PHP] Re: mysql_query() problem

2001-12-16 Thread Yasuo Ohgaki
Brian Rue wrote: > Hi, > > I'm getting the error > <> > > from this code: > > function validateUser($username,$password) { > $conn = connectToMySQL(); > mysql_select_db($db_name,$conn); > $query="select * from members where username='".$username."' AND > password='".$password."'"; > $resul

[PHP] Re: mysql_query()

2001-08-14 Thread _lallous
I have made this a small script called SQL2PHP, --- SQL2PHP --- file3.sql can contain: --- DROP DATABASE t; CREATE DATABASE t; USE t; # # Table structure for table 'brands' # DROP TABLE /*!32200 IF EXISTS*/ brands; CREATE TABLE /*!32300 IF NOT EXISTS*/ brands ( id int(10) unsigned NOT