Table Update

[whare]

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

[AndyB]

mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1'");

WHERE what condition??

[whare]

oohh I need to have a WHERE codition then ok i better set one then thanx :)

[whare]

[code]mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1' WHERE id='1'");[/code]

still not working

[AndyB]

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]

[whare]

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

:)