id field error

Поиск
Список
Период
Сортировка
Искать
От
angelo.rigo@globo.com
Тема
id field error
Дата
Msg-id
3CC7A89800004414@nplex.globo.com
Список
Дерево обсуждения
Re: id field error Surojit Niyogi <surojit@bungeecode.com>
Hi !
I´m doing my first publishing system for a last aquired boooks for a library.

the problem begin in the id field, wich i choose to be primary key and unique.
i could just insert data one time the others give me this error:

 Cannot insert a duplicate key into unique index biblioteca_pkey

i use this piece of code below to insert the data:

$query = "INSERT INTO biblioteca (id, autor, titulo, editora) values ('$id',
'$autor', '$titulo', '$editora')";
$result = pg_exec($db, $query);

may i can alter the id collumn and the query to insert the data anybody
knows what exactly to do ?

Thank´s

Ângelo




________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.

В списке pgsql-php по дате отправления
От: Kwabena Adowah Adu
Дата:
Сообщение: Re: Variables
От: Jeff Self
Дата:
Сообщение: Re: id field error
FAQ