Re: Update script

Hi,


Ângelo Marcos Rigo wrote, On 8/14/2003 3:46 PM:
> Hi
>
> I have a script to update some records in a postgresql
> database. when i do modify what i have to modify it
> give me the warning:
>
> Warning: pg_query() query failed: ERROR: pg_atoi:
> zero-length string in
> /var/www/html/adm/modificar_2.php on line 24
> ERROR
>
> this is line 24:
>     $result = pg_query($db, $query);
>
> this is modificar_2.php :
>
> <?php
>     $id = $_POST['id'];
>     $titulo = $_POST['titulo'];
>     $texto = $_POST['texto'];
>
>     include 'db.php';
>     $query = "UPDATE table SET titulo='$titulo',
> texto='$texto' WHERE id='$id'";
print $query; You will get:
UPDATE table SET titulo='somthing',texto='text' WHERE id=''

And your pg version is >= 7.2, where you can not insert '' string in
integer type. cast $id as integer, '".($id+0)."' or intval or others.

C.