whare Posted August 19, 2006 Share Posted August 19, 2006 Hi AllRight im having problems updating a table entry here is the code[code]<?phpsession_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 Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 19, 2006 Share Posted August 19, 2006 mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1'");WHERE what condition?? Quote Link to comment Share on other sites More sharing options...
whare Posted August 19, 2006 Author Share Posted August 19, 2006 oohh I need to have a WHERE codition then ok i better set one then thanx :) Quote Link to comment Share on other sites More sharing options...
whare Posted August 19, 2006 Author Share Posted August 19, 2006 [code]mysql_query("UPDATE stats SET pirep='$pirep1' AND hours='$hour1' WHERE id='1'");[/code]still not working Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 19, 2006 Share Posted August 19, 2006 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] Quote Link to comment Share on other sites More sharing options...
whare Posted August 19, 2006 Author Share Posted August 19, 2006 That worked loads betterThank you It gave me an error about a typo [as i said in the first post a simple problem lol]Thanx Alot mate:) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.