Jump to content

Archived

This topic is now archived and is closed to further replies.

whare

db submit error (i think lol)

Recommended Posts

Hi All

I keep getting this error and i have tried other wass of sorting the problem but carnt seem to work it out

Any Ideas??

Parse error: parse error, unexpected T_STRING in /home/www/evtecsolutions.com/dashairways/pirep2/includes/pirep.php on line 23

Here is my code

[code]<?
// Session and include info
session_start();
include 'config.php';
// Form Field info
$fltnum = $_POST['fltnum'];
$actype = $_POST['actype'];
$depair = $_POST['depair'];
$deptime = $_POST['deptime'];
$arair = $_POST['arair'];
$artime = $_POST['artime'];
$flttime = $_POST['flttime'];
$fltinfo = $_POST['fltinfo'];

$userid = $_SESSION['userid'];

// SQL to update the table "pirep"

$sql = mysql_query("INSERT INTO pirep (userid, fltnum, actype, depair, deptime, arair, artime, flttime, fltinfo, pirep_date)
        VALUES('$userid','$fltnum','$actype','$depair','$deptime','$arair','$artime','$flttime','$fltinfo', now())")
        or die (mysql_error())
// SQL table to update "pilot" [this is the bit with the error
mysql_query("UPDATE pilot SET lastpirep=now() WHERE userid='$userid'");
echo "Thankyou for your Pirep.";


?>
[/code]


Thanx All
Whare

Share this post


Link to post
Share on other sites
For one, your missing the semicolon at the end of this line:

[code]$sql = mysql_query("INSERT INTO pirep (userid, fltnum, actype, depair, deptime, arair, artime, flttime, fltinfo, pirep_date)
        VALUES('$userid','$fltnum','$actype','$depair','$deptime','$arair','$artime','$flttime','$fltinfo', now())")
        or die (mysql_error())[/code]

Share this post


Link to post
Share on other sites
It is amasing how easy it is to forget that lol

I will check it and see if it works lol

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.