Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
> On Tue, May 18, 2010 at 2:51 PM, Niel Archer wrote: > >> > Is there a different syntax to the mysql delete statement when the > >> > "WHERE" > >> > clause points only to half of the primary key? > >> > > >> > The structure is as follows: > >> > CREATE TABLE IF NOT EXISTS ` table1` ( > >> >   `i

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Bastien Koert
On Tue, May 18, 2010 at 2:51 PM, Niel Archer wrote: >> > Is there a different syntax to the mysql delete statement when the "WHERE" >> > clause points only to half of the primary key? >> > >> > The structure is as follows: >> > CREATE TABLE IF NOT EXISTS ` table1` ( >> >   `id1` int(10) unsigned N

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
> > Is there a different syntax to the mysql delete statement when the "WHERE" > > clause points only to half of the primary key? > > > > The structure is as follows: > > CREATE TABLE IF NOT EXISTS ` table1` ( > > `id1` int(10) unsigned NOT NULL, > > `id2` int(10) unsigned NOT NULL, > > PRIM

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
> Is there a different syntax to the mysql delete statement when the "WHERE" > clause points only to half of the primary key? > > The structure is as follows: > CREATE TABLE IF NOT EXISTS ` table1` ( > `id1` int(10) unsigned NOT NULL, > `id2` int(10) unsigned NOT NULL, > PRIMARY KEY (`id1`,

[PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Systems
Is there a different syntax to the mysql delete statement when the "WHERE" clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY (`id1`,`id2`), KEY `i

Re: [PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Artur Ejsmont
You probably miss the mysql extension or have different one than you are calling. Please call in script to see what extensions are loaded. if there is some other module supporting mysql just use different way to run sql. otherwise you need to look into php.ini and see if module is available and

[PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Alexander Schunk
Hello, i want to create a database with php. A look in the php manual says that you need a special 4.x MySQL version for using mysql_create_db(). I am getting error message: Call to undefined function mysql_create_db(). When is this function defined and in what version of MySQL? yours sincerly

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Artur Ejsmont
May also be granted rights to login from '%' which will resolve to any host name except localhost. On 18 May 2010 08:24, "Peter Lind" wrote: On 18 May 2010 09:19, nagendra prasad wrote: > Hi All, > > I am getting t... It means that either the password you're using is wrong or the user doesn't h

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Chaitanya Yanamadala
it means the root user password which u are using is the wrong one.. Chaitanya On Tue, May 18, 2010 at 12:49 PM, nagendra prasad wrote: > Hi All, > > I am getting this error while tried to run a downloaded script in WAMP: > > [1045] dbconn: mysql_connect: Access denied for user 'root'@'localho

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Peter Lind
On 18 May 2010 09:19, nagendra prasad wrote: > Hi All, > > I am getting this error while tried to run a downloaded script in WAMP: > > [1045] dbconn: mysql_connect: Access denied for user 'root'@'localhost' > (using password: YES) > > Dose anyone know what exactly this means. > > Best, > Guru. >

[PHP-DB] Need Help in error msg

2010-05-18 Thread nagendra prasad
Hi All, I am getting this error while tried to run a downloaded script in WAMP: [1045] dbconn: mysql_connect: Access denied for user 'root'@'localhost' (using password: YES) Dose anyone know what exactly this means. Best, Guru.