Problem insert into DB

alfpalafox

Hello all,

I'm trying to make a poll, but with the page where I'm trying to insert the data I get an error in line 27 where theer's nothing, in fact this line is outside the script tags

Could you help me on this?, this is my code and thank you all.

<?php
/ Nombre: Insert01.php
Funcion: Inserta primeros valores de la encuesta
/

echo "<body background=logo-it.gif>";
include ("conexion_bd.php");

if($continuar)
{
$conectar = conexion();
//declaracion de variables para SQL
$lock_encuesta = "LOCK TABLES encuesta.datos WRITE";
$unlock_encuesta = "UNLOCK TABLES";

$sql_insert = "INSERT INTO encuesta.datos(id_pregunta, valor) VALUES ('1', '$qst01')";
$sql_update = "UPDATE encuesta.datos SET valor = valor + '$qst01' WHERE encuesta.id_pregunta = '1'";
$query = "SELECT * FROM encuesta.datos WHERE id_pregunta = '1';

   mysql_query($lock_encuesta) or die (mysql_error());
   mysql_query($sql_update) or die (mysql_error());
   mysql_query($unlock_encuesta) or die (mysql_error());

mysql_close($conectar);
exit;
}

php?>

philipolson

It's ?> not php?>

alfpalafox

I get the same result, i've already tried that. any other ideas?

philipolson

The $query definition is missing a closing ".

alfpalafox

Thank you, you're right, I was missing that.

One more question, after I make the insertions to the database, I need to call another web page (name it segunda.php. How can I do this.

I was trying to use include ("segunda.php"); but It didn't work

Any idea?

philipolson

Why not include the db processing script on top of segunda.php ? Minus the html of course.

raymie

Move the database updates etc to before any HTML output and if you want to show the second page instead of the current one....

header("Location: secondpage.php") ;

alfpalafox

I've used this:

header ("http:127.0.0.1/secondpage.php");

But I get this message:

Warning: Cannot add header information - headers already sent by (output started at c:\poll\insert01.php:7)

And I don't know if the line 7 which is echo "<body background = image.gif>"; is sending some header.

Thanks

philipolson

it is, remove all output. The manual on header() talks a bit about it.

alfpalafox

Thankyou for your help and your patience.

michael

Or, if you absolutely have to, use ob_start();