[SOLVED] MySQL Help

[andrew6607]

Hello,

I am trying to set up a System For A Virtual Airline. When someone enters the amount of hours they did on a flight and then it ads it to the currents hours in the database. Example.. They currently have 200 Hours logged. And They submit a report with 2.8 Hours. So then the table would be updated and then say they have 202.8 Hours.

 

Thanks!

[Northern Flame]

so whats your question?

[andrew6607]

The Questions is.. How Would i get the 2.8 Hours into the database so it would equal 202.8?

[Northern Flame]

run a mysql_query to select the hours,

mysql_query("SELECT hours FROM table_name")

 

and then add 2.8 to it.

[andrew6607]

Yea i know about the query. But how would i add the hours to the table. Thats What IM Wondering!

[Northern Flame]

$hours = mysql_fetch_array($query);

 

$new_hours = $hours['hours'] + 2.8

 

mysql_query("UPDATE table_name SET hours = '$new_hours'");

 

(might need to add a WHERE in there if you have multiple rows

and only want one row to be affected)