create table

Anon

I can't see anything wrong with this but it still doesn't work!

create table test (
ID int(5) DEFAULT '0' NOT NULL auto_increment);

Anon

That is because you need to make any auto_increment field an index.. in this case i would recoment PRIMARY KEY(ID)...

create table test (
ID int(5) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY(ID)
);

Andreas Bernhardsen

Anon

Cheers, Andreas, but I'm still getting the same error with your way.

Anon

hmmm... it works ok with me... so it's not the query that is wrong... what error message are you getting?

Andreas

Anon

Parse error on Line 10.

This is the file (passwords etc. removed) ...

<?php

// create connection
$dbDatabase = " ";
$dbServer = " ";
$dbPort = " ";
$dbUserName = " ";
$dbPassword = " ";
$connection = pg_connect ( "dbname=$dbDatabase host=$dbServer port=$dbPort user=$dbUserName password=$dbPassword" );
}

create table test (
ID int(5) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY(ID)
);

Anon

line 10 is the }, right ?!?

i don't see the { ...

but that only counts if you posted the complete file and not just a part ...

cya Rob

Anon

That shouldn't be there (sorry).

Parse error on line 11 now.

Also tried ...

<?php

$query = "create table test (
ID int(5) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY(ID)
)";

$query_result = pg_exec ($connection, $query);

And hey, thanks for getting back to me so fast on this all the time!

Anon

Ah. See, you do need to post the whole thing.
This is PostgreSQL, not MySQL, and auto_increment
is a MySQL extension. The equivalent for psql is:

  id serial not null, ...

and there's no requirement to make an index on it
unless you want to.

BTW, your previous example could not work regardless;
the table definition is not a PHP statement, it's a
string you have to send as a query to the database
(as you do here.)