Update script

[angelorigo]

Hi

I write a script to update some records from my postgresql database, so it work well for input type text fields.

I need to get it to work with textarea field but it is not working .

The value that must be displayed in the textarea is not displayed.
here is the code that do that:

//it select the fileds with the specific id that come from a previous script
...
do {
$myrow = pg_fetch_row ($result, $row);
print ("<tr><td>ID</td><td>$myrow[0]</td></tr>");
print ("<tr><td>Título</td><td><input type=text value=$myrow[1] name=titulo size=150 maxlength=150></td></tr>");
print ("<tr><td>Texto</td><td><textarea cols=90 rows=20 value=$myrow[2] name=texto></textarea></td></tr>");
$row++;
}
while ($row < $numrows);
...
So all the files arte displayed properly but not the texto fiels wich is the textarea that cames blank. Thanks in advance for help.!!

[drawmack]

print ("<tr><td>Texto</td><td><textarea cols=90 rows=20  name=texto>$myrow[2]</textarea></td></tr>");

[angelorigo]

Originally posted by drawmack

print ("<tr><td>Texto</td><td><textarea cols=90 rows=20  name=texto>$myrow[2]</textarea></td></tr>");

[/B]

That´s it! now it is working right i did not realize that textarea has no value atribute thank´s a lot

[angelorigo]

It is working right but when i pass to the update script below 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 21
ERROR

<?php
$id = $POST['id'];
$titulo = $POST['titulo'];
$texto = $_POST['texto'];

include 'db.php'; 
$query = "UPDATE informativo SET titulo='$titulo', texto='$texto' WHERE id='$id'";
$result = pg_query($db, $query);
if (!$result) {printf ("ERROR"); exit;}
print ("Estes valores foram atualizados:<P> - $titulo<BR>- $texto<BR>");
pg_close($db);

?>
What can it be?
thank´s in advance

[drawmack]

Originally posted by angelorigo
That´s it! now it is working right i did not realize that textarea has no value atribute thank´s a lot

you would have if you validated your code

http://validator.w3.org/

[drawmack]

Originally posted by angelorigo
Warning: pg_query() query failed: ERROR: pg_atoi: zero-length string in /var/www/html/adm/modificar_2.php on line 21
ERROR

What can it be?
thank´s in advance [/B]

well it's tell you the error is on line 21 and you've only given us 10 lines. Which line is it complaining about. My guess would be you set a field so that it must be filled in and now you are trying to update that field with a blank value.

[angelorigo]

this is the update section:

$id = $POST['id'];
$titulo = $POST['titulo'];
$texto = $_POST['texto'];

include 'db.php'; 
$query = "UPDATE informativo SET titulo='$titulo', texto='$texto' WHERE id='$id'";
$result = pg_query($db, $query);
if (!$result) {printf ("ERROR"); exit;}
print ("Estes valores foram atualizados:<P> - $titulo<BR>- $texto<BR>");
pg_close($db);

[angelorigo]

Originally posted by angelorigo
this is the update section:

$id = $POST['id'];
$titulo = $POST['titulo'];
$texto = $_POST['texto'];

include 'db.php'; 
$query = "UPDATE informativo SET titulo='$titulo', texto='$texto' WHERE id='$id'";
$result = pg_query($db, $query);
if (!$result) {printf ("ERROR"); exit;}
print ("Estes valores foram atualizados:<P> - $titulo<BR>- $texto<BR>");
pg_close($db); [/B][/QUOTE] 

This is the line 21 :
$result = pg_query($db, $query);