Jump to content

Archived

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

whare

Table Update

Recommended Posts

Hi All

Right im having problems updating a table entry here is the code

[code]<?php

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 = 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());

$result = mysql_query("SELECT * FROM pilot WHERE userid='$userid'");
while($row = mysql_fetch_array( $result )) {
$flttot = $row['tothour'];
$totflt = $flttime + $flttot;
}
mysql_query("UPDATE pilot SET tothour='$totflt' WHERE userid='$userid'");
$stat = $_SESSION['userlevel'];
if($stat==0){
mysql_query("UPDATE pilot SET userlevel='1' WHERE userid='$userid'");
}
mysql_query("UPDATE pilot SET lastpirep=now() WHERE userid='$userid'");
echo "Thankyou for your Pirep.";

$result = mysql_query("SELECT * FROM stats");
while($row = mysql_fetch_array( $result )) {
$pireps = $row['pireps'];
$hour = $row['hours'];
$pirep1 = $pireps + 1;
$hour1 = $hour + $totflt;
}
mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1'");

?>

[/code]

now the code does not update the table but also does not return any errors in the code any ideas on this one (mostlily something simple it always is lol

Share this post


Link to post
Share on other sites
mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1'");

WHERE what condition??

Share this post


Link to post
Share on other sites
oohh I need to have a WHERE codition then ok i better set one then thanx :)

Share this post


Link to post
Share on other sites
[code]mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1' WHERE id='1'");[/code]

still not working

Share this post


Link to post
Share on other sites
Try:

[code]$query = "UPDATE stats SET pirep='$pirep1', hours='$hour1' WHERE id='1'";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query); // useful error message[/code]

Share this post


Link to post
Share on other sites
That worked loads better

Thank you 

It gave me an error about a typo [as i said in the first post a simple problem lol]

Thanx Alot mate

:)

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.