t variable problem

homer09001

i keep getting an error message when i submit a form on my site here is the error message:

Parse error: parse error, unexpected T_VARIABLE in /usr/local/www/data/_www/gea/pirep.php3 on line 17

and here is the source code for the php file:

<?
$DBhost = "localhost";
$DBuser = "gea";
$DBpass = "******";
$DBName = "gea";
$table = 'information';
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$id = $POST['id'];
$name = $POST['name'];
$hours = $_POST['hours'];

$sqlquery = "SELECT $id FROM $table"
$sqlquery = "INSERT INTO $table
VALUES('$hours')";

$results = mysql_query($sqlquery);

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Pilot ID : $id<p>Name : $name<p>Total Flight Time :
$hours</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

all i want the form to do is select a row in the table using the id submitted and writing in the hours that was submitted

bpat1434

The T_VARIABLE error is actually on your first SQL line. You need to end it with a semi-colon. You forgot it.

Well, your SQL is interesting. I think something like this would be better suited:

<?php
$DBhost = "localhost";
$DBuser = "gea";
$DBpass = "******";
$DBName = "gea";
$table = 'information';
$conn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName", $conn) or die("Unable to select
database $DBName");

$id = $_POST['id'];
$name = $_POST['name'];
$hours = $_POST['hours'];

$sqlquery = "INSERT INTO $table ('column_name') VALUES ('$hours') WHERE 'id' =  $id";

$results = mysql_query($sqlquery);
if(!$results || mysql_affected_rows($results) < 1)
{
    // Display error
}

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Pilot ID : $id<p>Name : $name<p>Total Flight Time :
$hours</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

~Brett

homer09001

thanx btw is there any way i can get it to add the hours submitted to the hours already in the database for that user?

bpat1434

Use mktime() or date() and submit as you normally would.

~Brett