Re: creating table w/ php help

thanks, that did it.

Cornelia Boenigk wrote:

> > $query = "CREATE table $tablename (id INT UNSIGNED NOT NULL
> > AUTO_INCREMENT PRIMARY KEY, ip TEXT, customer TEXT, dslphone TEXT,
> date
> > TEXT, vpivci TEXT)";
>
> AUTO_INCREMENT is used in MySQL. With PostgreSQL you should use the
> keyword SERIAL. Also UNSIGNED is not used.
>
> > Here is the second problem. By looking at the php manual for the
> pg-exec
> > function (changed to pg-query in php 4)
> It *will* change from PHP 4.2.0 on. pg_exec() is still valid for all
> releases < 4.2.0.
>
> Regards
> Conni
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster