from php it looks like this:
$query = "UPDATE Flight F SET F.seats = F.seats-$rseats WHERE (F.fid = $fid)";
$result = mysql_query($query);
I tested it from the mysql command prompt first though like so:
UPDATE Flight F SET F.seats = F.seats-1 WHERE (F.fid = 1);
The bottom one works, but it won't from php and it's driving me crazy! I'm not receiving an error message either!
Thanks,
Griff
Bookmarks